问题描述
我必须比较来自UI的IEnumerable数据和来自SQL Server 2008的IEnumerable数据,并且必须将新元素从UI插入/更新到DB,并根据UI数据从DB中删除元素。
我在DB中有Distribution_X_ListType表格:
I have to compare the IEnumerable data from UI and the IEnumerable data from SQL Server 2008 and have to insert/update the new elements from UI to DB and delete the elements from DB based on UI data.
I am having Distribution_X_ListType table in DB as:
DistributionID ListTypeID EmployeeNumber DepartmentID LocationID
1 2 84528 NULL NULL
1 3 NULL 8051 NULL
1 5 NULL NULL 319
我是在项目中具有如下界面:
I am having an interface in a project as follows:
public interface IDistributionList : IEntity
{
string Name { get; set; }
bool ActiveFlag { get; set; }
...........................
...........................
IEnumerable<IDistributionListType> ListTypes { get; set; }
}
另一个界面是:
The another interface is:
public interface IDistributionListType
{
int? DistributionID { get; set; }
int ListTypeID { get; set; }
int EmployeeNumber { get; set; }
int DepartmentID { get; set; }
int LocationID { get; set; }
}
在另一个项目中,我有如下保存功能:
In another project I am having Save function as follows:
public int Save(IDistributionList distributionList)
{
SqlDataReader reader = null;
int rowsaffected = 0;
try
{
sqlcommand = new SqlCommand("spGetDistributionListTypeByID", con); //spGetDistributionListTypeByID - This SP returns all the members from Distribution_X_ListType table for the given distribution ID
sqlcommand.CommandType = CommandType.StoredProcedure;
sqlcommand.Parameters.AddWithValue("@Distribution_ID", distributionList.ID);
reader = sqlcommand.ExecuteReader();
while (reader.Read())
{
????Value Should be stored in an IDistributionListType variable,say IDistributionListTypeFromDB
}
????IDistributionListType from function parameter(Lets say from UI) should be compared with the above IDistributionListTypeFromDB data.
????Insert/Delete should be done in DB by comparing the data.
}
}
从UI获取IDistributionListType的值:
Let the value of IDistributionListType from UI:
DistributionID ListTypeID EmployeeNumber DepartmentID LocationID
1 2 84528 NULL NULL
1 5 NULL NULL 64
从DB获取IDistributionListType的值:
Let the value of IDistributionListType from DB:
DistributionID ListTypeID EmployeeNumber DepartmentID LocationID
1 2 84528 NULL NULL
1 3 NULL 8051 NULL
1 5 NULL NULL 319
我需要使用UI中的数据更新数据库。我还有两个SP:
I need to update the DB with the data from UI. I am having two more SPs as :
spInsertUpdateDistributionListType - Insert/Update Distribution_X_ListType table based on DistributionID and listtypeID
spDeleteDistributionListType - Delete Distribution_X_ListType table based on DistributionID and listtypeID
我不知道怎么编码?区域。有人请帮忙。在此先感谢。
I don''t know how to code in ???? areas. Anybody please helpout. Thanks in advance.
推荐答案
这篇关于基于IEnumerable比较的操作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!