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();
}
