public void insertGongHuoFang(DataTable dt) { using (nemanpingEntities3 can = new nemanpingEntities3()) { foreach (DataRow dr in dt.Rows) { if (dr[0] is DBNull || Convert.ToInt32(dr[0]) == 0) { GongHuoFang insets = new GongHuoFang() { PingMing = dr[1].ToString(), HuoHao = dr[2].ToString(), Guige = dr[3].ToString(), SeHao = dr[4].ToString(), Yanse = dr[5].ToString(), DanJia = dr[6].ToString(), GongHuoFangA = dr[7].ToString(), GongHuoFangB = dr[8].ToString(), BeiZhu = dr[9].ToString() }; can.GongHuoFang.Add(insets); } else { int id = Convert.ToInt32(dr[0]); var select = from sc in can.GongHuoFang where sc.Id == id select sc; var target = select.FirstOrDefault <GongHuoFang>(); target.PingMing = dr[1].ToString(); target.HuoHao = dr[2].ToString(); target.Guige = dr[3].ToString(); target.SeHao = dr[4].ToString(); target.Yanse = dr[5].ToString(); target.DanJia = dr[6].ToString(); target.GongHuoFangA = dr[7].ToString(); target.GongHuoFangB = dr[8].ToString(); target.BeiZhu = dr[9].ToString(); } } can.SaveChanges(); } }
public void deleteJaGongChang(List <int> id) { using (nemanpingEntities3 npe = new nemanpingEntities3()) { foreach (int strid in id) { if (strid != null) { if (strid != 0) { var select = from s in npe.JiaGongChang where s.id == strid select s; foreach (var item in select) { npe.JiaGongChang.Remove(item); } } } } npe.SaveChanges(); } }
public void insertJiaGongChang(DataTable dt) { using (nemanpingEntities3 can = new nemanpingEntities3()) { foreach (DataRow dr in dt.Rows) { if (dr[0] is DBNull || Convert.ToInt32(dr[0]) == 0) { JiaGongChang insets = new JiaGongChang() { Name = dr[1].ToString(), Address = dr[2].ToString(), Lianxiren = dr[3].ToString(), Phone = dr[4].ToString(), ZengZhiShui = dr[5].ToString(), Kaihuhang = dr[6].ToString(), Zhanghao = dr[7].ToString() }; can.JiaGongChang.Add(insets); } else { int id = Convert.ToInt32(dr[0]); var select = from sc in can.JiaGongChang where sc.id == id select sc; var target = select.FirstOrDefault <JiaGongChang>(); target.Name = dr[1].ToString(); target.Address = dr[2].ToString(); target.Lianxiren = dr[3].ToString(); target.Phone = dr[4].ToString(); target.ZengZhiShui = dr[5].ToString(); target.Kaihuhang = dr[6].ToString(); target.Zhanghao = dr[7].ToString(); } } can.SaveChanges(); } }