public void LoadToData(MaCuon macuon, string may, int vitri) { switch (softwareType) { case "SV": string sql = @"INSERT INTO {0} (MaCuon, Vitri, SoKG, Duyet) VALUES ('{1}',{2},{3},'{4}')"; decimal sokg = macuon.SoKg; db.UpdateByNonQuery(string.Format(sql, machineTable, macuon.Macuon.ToString(), vitri, sokg, macuon.Duyet)); mainFrm.SyncMainGrid(); break; case "MV": string machine = machineTable.Substring(0, 3).ToString(); string sql1 = @"INSERT INTO {0}_{1} (MaCuon, Vitri, SoKG,Duyet) VALUES ('{2}',{3},{4},'{5}')"; decimal sokg1 = macuon.SoKg; db.UpdateByNonQuery(string.Format(sql1, machineTable, may, macuon.Macuon.ToString(), vitri, sokg1, macuon.Duyet)); mainFrm.SyncMainGrid(); break; } }
private void UpdateData(string macuon, string may) { string ngay = DateTime.Now.ToString(); MaCuon mc = new MaCuon(); string dataCnn = Config.GetValue("DataConnection").ToString(); dataCnn = dataCnn.Replace("POS", "HTCPH"); Database hoaTieuDb = Database.NewCustomDatabase(dataCnn); mc.Macuon = macuon; //lay manvl + kho + ky hieu + ty le khoi var manl = hoaTieuDb.GetValue(string.Format("SELECT MaNL FROM DT42 WHERE MaCuon = '{0}'", macuon.Trim())); string cVitri = ""; string msch = machineTable.Substring(0, 3).ToString(); if (manl != null) { mc.MaNL = manl.ToString(); DataTable dmNL = hoaTieuDb.GetDataTable(string.Format("SELECT KyHieu, Kho FROM wDMNL2 WHERE Ma = '{0}'", manl.ToString())); if (dmNL.Rows.Count > 0) { mc.KyHieu = dmNL.Rows[0]["KyHieu"].ToString(); mc.Kho = dmNL.Rows[0]["Kho"].ToString(); } var tileK = hoaTieuDb.GetValue(string.Format("SELECT TiLeK from DMNL WHERE Ma = '{0}'", manl.ToString())); if (tileK != null) { mc.TileK = Convert.ToDecimal(string.IsNullOrEmpty(tileK.ToString()) ? "0" : tileK.ToString()); } DataTable dbo = db.GetDataTable(string.Format("SELECT Duyet,SoKg,ViTri from {0}_{1} WHERE MaCuon = '{2}'", msch, may, mc.Macuon)); if (dbo.Rows.Count > 0) { mc.Duyet = dbo.Rows[0]["Duyet"].ToString(); mc.SoKg = Convert.ToDecimal(dbo.Rows[0]["SoKg"].ToString()); cVitri = dbo.Rows[0]["ViTri"].ToString(); } } string _machine = machineTable.Substring(0, 3).ToString(); decimal sosokgBd = mc.SoKg; decimal duongkinh = 0; Input dkFrm = new Input(); dkFrm.ShowDialog(); if (dkFrm.DialogResult != DialogResult.Cancel) { duongkinh = dkFrm.duongkinh; } decimal soluongCL = (duongkinh / 1000) * Convert.ToDecimal(mc.Kho) * Convert.ToDecimal("3.14") * mc.TileK; decimal soluongSD = mc.SoKg - soluongCL; string sql = @"INSERT INTO YeuCauXuatKho (Ngay, MaCuon, SoLuongBD, SoLuongSD, SoLuongCL, NguoiDuyet, LSX, Duyet, NguoiLap,ViTri) VALUES ('{0}','{1}',{2},{3},{4},'{5}', '{6}',1, '{7}', '{8}_{9}_{10}')"; db.UpdateByNonQuery(string.Format(sql, ngay, mc.Macuon, mc.SoKg, soluongSD, soluongCL, mc.Duyet, "LSX", mainFrm.loginUser["Ma"].ToString(), msch, may, cVitri)); string sql2 = @"DELETE FROM {0}_{1} WHERE MaCuon = '{2}'"; db.UpdateByNonQuery(string.Format(sql2, _machine, may, mc.Macuon)); mainFrm.SyncMainGrid(); this.Close(); }