public static int SaveINDocDet(INDocDet info) { return ConnectDB.ExecuteScalar("sp_INDocDetSave", new String[] { "BranchID", "DocNbr", "Module", "LineRef", "TranType", "TranDate", "WhID", "ToWhID", "FreeItem", "ProductID", "TranDesc", "LotID", "INUnit", "LineQty", "UnitCost", "TotalCost", "InvtMult", "ObjID", "ShipperID", "RsID", "Rlsed", "SONbr", "PONbr", "Cnvfact", "UnitRate", "DetailQty", "Crtd_DateTime", "Crtd_Prog", "Crtd_User", "LUpd_DateTime", "LUpd_Prog", "LUpd_User", "Version" }, new Object[] { info.BranchID, info.DocNbr, info.Module, info.LineRef, info.TranType, info.TranDate, info.WhID, info.ToWhID, info.FreeItem, info.ProductID, info.TranDesc, info.LotID, info.INUnit, info.LineQty, info.UnitCost, info.TotalCost, info.InvtMult, info.ObjID, info.ShipperID, info.RsID, info.Rlsed, info.SONbr, info.PONbr, info.Cnvfact, info.UnitRate, info.DetailQty, info.Crtd_DateTime, info.Crtd_Prog, info.Crtd_User, info.LUpd_DateTime, info.LUpd_Prog, info.LUpd_User, info.Version }); }
private void _SaveINDocDet() { INDocDet infoDocDet = new INDocDet(); //thong tin giong nhau cua cac dong infoDocDet.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text == "") infoDocDet.DocNbr = _strFistChar + (Int16.Parse(_strLastNbr) + 1).ToString("000000"); else infoDocDet.DocNbr = txtDocNbr.Text; infoDocDet.Module = "IN"; infoDocDet.TranType = _strFistChar; infoDocDet.WhID = cmbWhID.SelectedValue.ToString(); infoDocDet.ToWhID = ""; infoDocDet.TranDate = dtmDocDate.Value.Date; infoDocDet.FreeItem = false; infoDocDet.ObjID = ""; infoDocDet.ShipperID = ""; infoDocDet.RsID = cmbReason.SelectedValue.ToString(); infoDocDet.Rlsed = 0; infoDocDet.SONbr = ""; infoDocDet.PONbr = ""; infoDocDet.Crtd_DateTime = DateTime.Now; infoDocDet.Crtd_Prog = _strPro; infoDocDet.Crtd_User = _strUser; infoDocDet.LUpd_DateTime = DateTime.Now; infoDocDet.LUpd_Prog = _strPro; infoDocDet.LUpd_User = _strUser; //thong tin rieng tung dong if (dgvDocDet != null) { for (int i = 0; i < dgvDocDet.Rows.Count; i++) { infoDocDet.LotID = dgvDocDet.Rows[i].Cells["LotID"].FormattedValue.ToString().Trim(); infoDocDet.ProductID = dgvDocDet.Rows[i].Cells["ProductID"].FormattedValue.ToString().Trim(); infoDocDet.TranDesc = dgvDocDet.Rows[i].Cells["TranDesc"].FormattedValue.ToString().Trim(); infoDocDet.LineRef = dgvDocDet.Rows[i].Cells["LineRef"].FormattedValue.ToString().Trim(); infoDocDet.InvtMult = int.Parse(dgvDocDet.Rows[i].Cells["InvtMult"].FormattedValue.ToString()); infoDocDet.INUnit = dgvDocDet.Rows[i].Cells["INUnit"].FormattedValue.ToString().Trim(); infoDocDet.LineQty = float.Parse(dgvDocDet.Rows[i].Cells["LineQty"].FormattedValue.ToString()); infoDocDet.Cnvfact = float.Parse(dgvDocDet.Rows[i].Cells["Cnvfact"].FormattedValue.ToString()); infoDocDet.UnitRate = float.Parse(dgvDocDet.Rows[i].Cells["UnitRate"].FormattedValue.ToString()); infoDocDet.DetailQty = float.Parse(dgvDocDet.Rows[i].Cells["DetailQty"].FormattedValue.ToString()); infoDocDet.UnitCost = float.Parse(dgvDocDet.Rows[i].Cells["UnitCost"].FormattedValue.ToString()); infoDocDet.TotalCost = float.Parse(dgvDocDet.Rows[i].Cells["TotalCost"].FormattedValue.ToString()); int kq; kq = IN201Ctrl.SaveINDocDet(infoDocDet); } } }
private void _SaveINDocDetRelease() { _intLineRef = Convert.ToInt32(_dtDocDet.Compute("max(LineRef)", string.Empty)); INDocDet infoDocDet = new INDocDet(); //thong tin giong nhau cua cac dong infoDocDet.DocNbr = txtDocNbr.Text; infoDocDet.BranchID = cmbBranchID.SelectedValue.ToString(); infoDocDet.Module = "IN"; infoDocDet.TranType = _strFistChar; infoDocDet.WhID = cmbToWhID.SelectedValue.ToString(); infoDocDet.ToWhID = ""; infoDocDet.TranDate = dtmDocDate.Value.Date; infoDocDet.FreeItem = false; infoDocDet.ObjID = ""; infoDocDet.ShipperID = ""; infoDocDet.RsID = cmbReason.SelectedValue.ToString(); infoDocDet.Rlsed = 0; infoDocDet.SONbr = ""; infoDocDet.PONbr = ""; infoDocDet.Crtd_DateTime = DateTime.Now; infoDocDet.Crtd_Prog = _strPro; infoDocDet.Crtd_User = _strUser; infoDocDet.LUpd_DateTime = DateTime.Now; infoDocDet.LUpd_Prog = _strPro; infoDocDet.LUpd_User = _strUser; infoDocDet.Version = ""; //thong tin rieng tung dong if (dgvDocDet != null) { for (int i = 0; i < dgvDocDet.Rows.Count; i++) { infoDocDet.LotID = dgvDocDet.Rows[i].Cells["LotID"].FormattedValue.ToString().Trim(); infoDocDet.ProductID = dgvDocDet.Rows[i].Cells["ProductID"].FormattedValue.ToString().Trim(); infoDocDet.TranDesc = dgvDocDet.Rows[i].Cells["TranDesc"].FormattedValue.ToString().Trim(); infoDocDet.LineQty = float.Parse(dgvDocDet.Rows[i].Cells["LineQty"].FormattedValue.ToString()); infoDocDet.InvtMult = 1; infoDocDet.INUnit = dgvDocDet.Rows[i].Cells["INUnit"].FormattedValue.ToString().Trim(); infoDocDet.LineRef = (_intLineRef + 1).ToString(); _intLineRef = _intLineRef + 1; infoDocDet.Cnvfact = float.Parse(dgvDocDet.Rows[i].Cells["Cnvfact"].FormattedValue.ToString()); infoDocDet.UnitRate = float.Parse(dgvDocDet.Rows[i].Cells["UnitRate"].FormattedValue.ToString()); infoDocDet.DetailQty = float.Parse(dgvDocDet.Rows[i].Cells["DetailQty"].FormattedValue.ToString()); infoDocDet.UnitCost = float.Parse(dgvDocDet.Rows[i].Cells["UnitCost"].FormattedValue.ToString()); infoDocDet.TotalCost = float.Parse(dgvDocDet.Rows[i].Cells["TotalCost"].FormattedValue.ToString()); int kq; kq = IN202Ctrl.SaveINDocDet(infoDocDet); } } }
private INDocDet _GetINDocDet(int rowindex) { INDocDet infoDocDet = new INDocDet(); //thong tin giong nhau cua cac dong infoDocDet.BranchID = cmbBranchID.SelectedValue.ToString(); if (txtDocNbr.Text == "") infoDocDet.DocNbr = _strFistChar + (Int16.Parse(_strLastNbr) + 1).ToString("000000"); else infoDocDet.DocNbr = txtDocNbr.Text; infoDocDet.Module = "IN"; infoDocDet.TranType = _strFistChar; infoDocDet.WhID = cmbWhID.SelectedValue.ToString(); infoDocDet.ToWhID = cmbToWhID.SelectedValue.ToString(); infoDocDet.TranDate = dtmDocDate.Value.Date; infoDocDet.FreeItem = false; infoDocDet.ObjID = ""; infoDocDet.ShipperID = ""; infoDocDet.RsID = cmbReason.SelectedValue.ToString(); infoDocDet.Rlsed = 0; infoDocDet.SONbr = ""; infoDocDet.PONbr = ""; infoDocDet.Crtd_DateTime = DateTime.Now; infoDocDet.Crtd_Prog = _strPro; infoDocDet.Crtd_User = _strUser; infoDocDet.LUpd_DateTime = DateTime.Now; infoDocDet.LUpd_Prog = _strPro; infoDocDet.LUpd_User = _strUser; infoDocDet.Version = ""; infoDocDet.LotID = dgvDocDet.Rows[rowindex].Cells["LotID"].FormattedValue.ToString().Trim(); infoDocDet.ProductID = dgvDocDet.Rows[rowindex].Cells["ProductID"].FormattedValue.ToString().Trim(); infoDocDet.TranDesc = dgvDocDet.Rows[rowindex].Cells["TranDesc"].FormattedValue.ToString().Trim(); infoDocDet.LineRef = dgvDocDet.Rows[rowindex].Cells["LineRef"].FormattedValue.ToString().Trim(); infoDocDet.InvtMult = int.Parse(dgvDocDet.Rows[rowindex].Cells["InvtMult"].FormattedValue.ToString()); infoDocDet.INUnit = dgvDocDet.Rows[rowindex].Cells["INUnit"].FormattedValue.ToString().Trim(); infoDocDet.LineQty = float.Parse(dgvDocDet.Rows[rowindex].Cells["LineQty"].FormattedValue.ToString()); infoDocDet.Cnvfact = float.Parse(dgvDocDet.Rows[rowindex].Cells["Cnvfact"].FormattedValue.ToString()); infoDocDet.UnitRate = float.Parse(dgvDocDet.Rows[rowindex].Cells["UnitRate"].FormattedValue.ToString()); infoDocDet.DetailQty = float.Parse(dgvDocDet.Rows[rowindex].Cells["DetailQty"].FormattedValue.ToString()); infoDocDet.UnitCost = float.Parse(dgvDocDet.Rows[rowindex].Cells["UnitCost"].FormattedValue.ToString()); infoDocDet.TotalCost = float.Parse(dgvDocDet.Rows[rowindex].Cells["TotalCost"].FormattedValue.ToString()); return infoDocDet; }