/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.Unify.Tb_Unify_Customer model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.Unify.Tb_Unify_Customer model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.Unify.Tb_Unify_Customer> DataTableToList(DataTable dt) { List <MobileSoft.Model.Unify.Tb_Unify_Customer> modelList = new List <MobileSoft.Model.Unify.Tb_Unify_Customer>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.Unify.Tb_Unify_Customer model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.Unify.Tb_Unify_Customer(); if (dt.Rows[n]["CustSynchCode"].ToString() != "") { model.CustSynchCode = new Guid(dt.Rows[n]["CustSynchCode"].ToString()); } if (dt.Rows[n]["CommSynchCode"].ToString() != "") { model.CommSynchCode = new Guid(dt.Rows[n]["CommSynchCode"].ToString()); } //model.UnCustID=dt.Rows[n]["UnCustID"].ToString(); model.CustTypeName = dt.Rows[n]["CustTypeName"].ToString(); model.CustName = dt.Rows[n]["CustName"].ToString(); model.NickName = dt.Rows[n]["NickName"].ToString(); model.FixedTel = dt.Rows[n]["FixedTel"].ToString(); model.MobilePhone = dt.Rows[n]["MobilePhone"].ToString(); model.FaxTel = dt.Rows[n]["FaxTel"].ToString(); model.EMail = dt.Rows[n]["EMail"].ToString(); model.LoginPwd = dt.Rows[n]["LoginPwd"].ToString(); model.Surname = dt.Rows[n]["Surname"].ToString(); model.Name = dt.Rows[n]["Name"].ToString(); model.Sex = dt.Rows[n]["Sex"].ToString(); if (dt.Rows[n]["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(dt.Rows[n]["Birthday"].ToString()); } model.Nationality = dt.Rows[n]["Nationality"].ToString(); model.PaperName = dt.Rows[n]["PaperName"].ToString(); model.PaperCode = dt.Rows[n]["PaperCode"].ToString(); model.PassSign = dt.Rows[n]["PassSign"].ToString(); model.Address = dt.Rows[n]["Address"].ToString(); model.PostCode = dt.Rows[n]["PostCode"].ToString(); model.MGradeSign = dt.Rows[n]["MGradeSign"].ToString(); model.Recipient = dt.Rows[n]["Recipient"].ToString(); model.Interests = dt.Rows[n]["Interests"].ToString(); model.Hobbies = dt.Rows[n]["Hobbies"].ToString(); model.WorkUnit = dt.Rows[n]["WorkUnit"].ToString(); model.Job = dt.Rows[n]["Job"].ToString(); model.Linkman = dt.Rows[n]["Linkman"].ToString(); model.LinkmanTel = dt.Rows[n]["LinkmanTel"].ToString(); model.SmsTel = dt.Rows[n]["SmsTel"].ToString(); if (dt.Rows[n]["IsUnit"].ToString() != "") { model.IsUnit = int.Parse(dt.Rows[n]["IsUnit"].ToString()); } model.LegalRepr = dt.Rows[n]["LegalRepr"].ToString(); model.LegalReprTel = dt.Rows[n]["LegalReprTel"].ToString(); model.Charge = dt.Rows[n]["Charge"].ToString(); model.ChargeTel = dt.Rows[n]["ChargeTel"].ToString(); if (dt.Rows[n]["ProvinceID"].ToString() != "") { model.ProvinceID = int.Parse(dt.Rows[n]["ProvinceID"].ToString()); } if (dt.Rows[n]["CityID"].ToString() != "") { model.CityID = int.Parse(dt.Rows[n]["CityID"].ToString()); } if (dt.Rows[n]["BoroughID"].ToString() != "") { model.BoroughID = int.Parse(dt.Rows[n]["BoroughID"].ToString()); } if (dt.Rows[n]["RoomCount"].ToString() != "") { model.RoomCount = int.Parse(dt.Rows[n]["RoomCount"].ToString()); } model.RoomSigns = dt.Rows[n]["RoomSigns"].ToString(); model.Memo = dt.Rows[n]["Memo"].ToString(); if (dt.Rows[n]["LiveType1"].ToString() != "") { model.LiveType1 = int.Parse(dt.Rows[n]["LiveType1"].ToString()); } if (dt.Rows[n]["LiveType2"].ToString() != "") { model.LiveType2 = int.Parse(dt.Rows[n]["LiveType2"].ToString()); } if (dt.Rows[n]["LiveType3"].ToString() != "") { model.LiveType3 = int.Parse(dt.Rows[n]["LiveType3"].ToString()); } if (dt.Rows[n]["IsDebts"].ToString() != "") { model.IsDebts = int.Parse(dt.Rows[n]["IsDebts"].ToString()); } if (dt.Rows[n]["IsUsual"].ToString() != "") { model.IsUsual = int.Parse(dt.Rows[n]["IsUsual"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } if (dt.Rows[n]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString()); } model.HeadImgURL = dt.Rows[n]["HeadImgURL"].ToString(); model.Introduce = dt.Rows[n]["Introduce"].ToString(); model.Hometown = dt.Rows[n]["Hometown"].ToString(); model.BirAnimal = dt.Rows[n]["BirAnimal"].ToString(); model.Constellation = dt.Rows[n]["Constellation"].ToString(); model.BloodGroup = dt.Rows[n]["BloodGroup"].ToString(); model.Stature = dt.Rows[n]["Stature"].ToString(); model.BodilyForm = dt.Rows[n]["BodilyForm"].ToString(); model.MaritalStatus = dt.Rows[n]["MaritalStatus"].ToString(); model.Qualification = dt.Rows[n]["Qualification"].ToString(); model.GraduateSchool = dt.Rows[n]["GraduateSchool"].ToString(); model.Occupation = dt.Rows[n]["Occupation"].ToString(); model.Telphone = dt.Rows[n]["Telphone"].ToString(); model.MobileTel = dt.Rows[n]["MobileTel"].ToString(); model.EmailSign = dt.Rows[n]["EmailSign"].ToString(); model.HomePage = dt.Rows[n]["HomePage"].ToString(); model.QQSign = dt.Rows[n]["QQSign"].ToString(); model.MSNSign = dt.Rows[n]["MSNSign"].ToString(); model.BroadbandNum = dt.Rows[n]["BroadbandNum"].ToString(); model.TeleFixedTel = dt.Rows[n]["TeleFixedTel"].ToString(); model.TeleMobile = dt.Rows[n]["TeleMobile"].ToString(); model.IPTVAccount = dt.Rows[n]["IPTVAccount"].ToString(); if (dt.Rows[n]["TotalPosts"].ToString() != "") { model.TotalPosts = int.Parse(dt.Rows[n]["TotalPosts"].ToString()); } if (dt.Rows[n]["Experience"].ToString() != "") { model.Experience = int.Parse(dt.Rows[n]["Experience"].ToString()); } model.CustCardSign = dt.Rows[n]["CustCardSign"].ToString(); if (dt.Rows[n]["CardSendDate"].ToString() != "") { model.CardSendDate = DateTime.Parse(dt.Rows[n]["CardSendDate"].ToString()); } if (dt.Rows[n]["CardActiveDate"].ToString() != "") { model.CardActiveDate = DateTime.Parse(dt.Rows[n]["CardActiveDate"].ToString()); } if (dt.Rows[n]["CardLossDates"].ToString() != "") { model.CardLossDates = DateTime.Parse(dt.Rows[n]["CardLossDates"].ToString()); } if (dt.Rows[n]["IsCardSend"].ToString() != "") { model.IsCardSend = int.Parse(dt.Rows[n]["IsCardSend"].ToString()); } if (dt.Rows[n]["IsCardActive"].ToString() != "") { model.IsCardActive = int.Parse(dt.Rows[n]["IsCardActive"].ToString()); } if (dt.Rows[n]["IsCardLoss"].ToString() != "") { model.IsCardLoss = int.Parse(dt.Rows[n]["IsCardLoss"].ToString()); } //model.OrdSNum=dt.Rows[n]["OrdSNum"].ToString(); model.WanQinId = dt.Rows[n]["WanQinId"].ToString(); model.WanQinPass = dt.Rows[n]["WanQinPass"].ToString(); model.ShiPingId = dt.Rows[n]["ShiPingId"].ToString(); model.ShiPingPass = dt.Rows[n]["ShiPingPass"].ToString(); model.ZhiLenId = dt.Rows[n]["ZhiLenId"].ToString(); model.ZhiLenPass = dt.Rows[n]["ZhiLenPass"].ToString(); model.WaterCardNum = dt.Rows[n]["WaterCardNum"].ToString(); model.WaterCardPass = dt.Rows[n]["WaterCardPass"].ToString(); model.ElectricityNum = dt.Rows[n]["ElectricityNum"].ToString(); model.ElectricityPass = dt.Rows[n]["ElectricityPass"].ToString(); model.GasNum = dt.Rows[n]["GasNum"].ToString(); model.GasPass = dt.Rows[n]["GasPass"].ToString(); modelList.Add(model); } } return(modelList); }