private void cmdLuu_Click(object sender, EventArgs e) { try { DataTable tb = (DataTable)dgvKho.DataSource; if (tb != null) { for (int i = 0; i < tb.Rows.Count; i++) { if (isModifedRow(tb.Rows[i])) { Pharmacy.Info.KhoInfo info = SetInfo(tb, i, 0); tKho.UpdateKho(info); //tpriceUnit.Update_priceunit1(int.Parse(tb.Rows[i]["ID"].ToString()), // float.Parse(tb.Rows[i]["Price"].ToString()), DateTime.Now); } if (isNewRow(tb.Rows[i])) { Pharmacy.Info.KhoInfo info = SetInfo(tb, i, 1); tKho.InsertKho(info); } if (isDeletedRow(tb.Rows[i])) { Pharmacy.Info.KhoInfo info = SetInfoDelete(tb, i); tKho.UpdateKho(info); } } } ShowKho(); } catch (Exception ex) { TLog.WriteErr("frmKho_SetInfo", ex.Message + "|" + ex.StackTrace); } }
public Pharmacy.Info.KhoInfo SetInfoDelete(DataTable tb, int i) { Pharmacy.Info.KhoInfo info = new Pharmacy.Info.KhoInfo(); info.Makho = int.Parse(tb.Rows[i]["MAKHO", DataRowVersion.Original].ToString()); info.Ten = tb.Rows[i]["TEN", DataRowVersion.Original].ToString(); info.Diachi = tb.Rows[i]["DIACHI", DataRowVersion.Original].ToString(); info.Dienthoai = tb.Rows[i]["DIENTHOAI", DataRowVersion.Original].ToString(); info.Ngaylap = DateTime.Parse(tb.Rows[i]["NGAYLAP", DataRowVersion.Original].ToString()); info.Tinhtrang = -1; info.Sodk = tb.Rows[i]["SODK", DataRowVersion.Original].ToString(); return info; }
public Pharmacy.Info.KhoInfo SetInfoDelete(DataTable tb, int i) { Pharmacy.Info.KhoInfo info = new Pharmacy.Info.KhoInfo(); info.Makho = int.Parse(tb.Rows[i]["MAKHO", DataRowVersion.Original].ToString()); info.Ten = tb.Rows[i]["TEN", DataRowVersion.Original].ToString(); info.Diachi = tb.Rows[i]["DIACHI", DataRowVersion.Original].ToString(); info.Dienthoai = tb.Rows[i]["DIENTHOAI", DataRowVersion.Original].ToString(); info.Ngaylap = DateTime.Parse(tb.Rows[i]["NGAYLAP", DataRowVersion.Original].ToString()); info.Tinhtrang = -1; info.Sodk = tb.Rows[i]["SODK", DataRowVersion.Original].ToString(); return(info); }
public Pharmacy.Info.KhoInfo SetInfo(DataTable tb, int i, int flag) { Pharmacy.Info.KhoInfo info = new Pharmacy.Info.KhoInfo(); if (flag == 1)//insert info.Makho = 0; else info.Makho = int.Parse(tb.Rows[i]["MAKHO"].ToString()); info.Ten = tb.Rows[i]["TEN"].ToString(); info.Diachi = tb.Rows[i]["DIACHI"].ToString(); info.Dienthoai = tb.Rows[i]["DIENTHOAI"].ToString(); info.Ngaylap = DateTime.Parse(tb.Rows[i]["NGAYLAP"].ToString()); info.Tinhtrang = 0; info.Sodk = tb.Rows[i]["SODK"].ToString(); return info; }
public Pharmacy.Info.KhoInfo SetInfo(DataTable tb, int i, int flag) { Pharmacy.Info.KhoInfo info = new Pharmacy.Info.KhoInfo(); if (flag == 1) //insert { info.Makho = 0; } else { info.Makho = int.Parse(tb.Rows[i]["MAKHO"].ToString()); } info.Ten = tb.Rows[i]["TEN"].ToString(); info.Diachi = tb.Rows[i]["DIACHI"].ToString(); info.Dienthoai = tb.Rows[i]["DIENTHOAI"].ToString(); info.Ngaylap = DateTime.Parse(tb.Rows[i]["NGAYLAP"].ToString()); info.Tinhtrang = 0; info.Sodk = tb.Rows[i]["SODK"].ToString(); return(info); }