public List <Td_zydh_Origin> InportSomeRowsOriginTable(DataTable dt, int nYear, long lProvinceID, long lParentDepartmentID = 0)
{
List <Td_zydh_Origin> returnArr = new List <Td_zydh_Origin>();
List <Td_zydh_Origin> addArr = new List <Td_zydh_Origin>();
string dm = "", mc = "";
foreach (DataRow dr in dt.Rows)
{
dm = dr["ZYDH"].ToString();
mc = dr["ZYMC"].ToString();
ArrayList names = new ArrayList(); ArrayList values = new ArrayList();
names.Add("DelFlag"); values.Add(false);
names.Add("YearCode"); values.Add(nYear);
names.Add("ProvinceID"); values.Add(lProvinceID);
names.Add("DM"); values.Add(dm);
names.Add("MC"); values.Add(mc);
names.Add("ParentDepartmentID"); values.Add(lParentDepartmentID);
Expression <Func <Td_zydh_Origin, bool> > where = GetAndLambdaExpression <Td_zydh_Origin>(names, values);
List <Td_zydh_Origin> list = GetRecord(where);
if ((list != null) && (list.Count > 0))
{
returnArr.Add(list[0]);
}
else
{
Td_zydh_Origin model = new Td_zydh_Origin();
model.YearCode = nYear;
model.ProvinceID = lProvinceID;
model.DM = dm;
model.MC = mc;
model.RelationID = 0;
model.ParentDepartmentID = lParentDepartmentID;
model.Kldm = GetOriginListID(KLDM_list, GetOneStrValue(dr, "KLDM"));
model.Zkfx = GetOneStrValue(dr, "ZKFX");
model.Tjsxbz = GetOneStrValue(dr, "TJSXBZ");
model.Xzdm = GetOriginListID(XZDM_list, GetOneStrValue(dr, "XZDM"));
model.Sfbz = Convert.ToInt32(GetOneStrValue(dr, "SFBZ", CosDataBase.INT_TYPE));
model.Bxdd = GetOneStrValue(dr, "BXDD");
model.Zylbdm = GetOriginListID(ZYLBDM_list, GetOneStrValue(dr, "ZYLBDM"));
model.Ccdm = GetOriginListID(ZYLBDM_list, GetOneStrValue(dr, "ZYLBDM"));
model.Bz = GetOneStrValue(dr, "BZ");
addArr.Add(model);
returnArr.Add(model);
}
}
if ((addArr != null) && (addArr.Count > 0))
{
AddRecords(addArr);
}
return(returnArr);
}
private Td_zydh getOneMainRecord(long lParentDepartmentID, Td_zydh_Origin orgModel)
{
Expression <Func <Td_zydh, bool> > where = (c => c.KldmOrigin == orgModel.Kldm && c.ZylbdmOrigin == orgModel.Zylbdm && c.XzdmOrigin == orgModel.Xzdm && c.ParentDepartmentID == lParentDepartmentID && c.Code == orgModel.DM);
List <Td_zydh> list = GetRecord(where);
if ((list != null) && (list.Count > 0))
{
return(list[0]);
}
else
{
return(null);
}
}
