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 });
 }
示例#2
0
        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);
                }

            }
        }
示例#3
0
        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);
                }

            }
        }
示例#4
0
        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;
        }