void addModuleSelf(string moduleCode, string moduleName, int ID, int parentID, int qty, string manageId, string moduleCodeHD) { string typeID = "T0068"; DataTable dt = LibQLSX.Select("select TypeId from SourceCode with(nolock) where FolderCode = '" + moduleCode + "'"); if (dt.Rows.Count > 0) { typeID = TextUtils.ToString(dt.Rows[0]["TypeId"]); } ProjectProductsModel projectProduct = new ProjectProductsModel(); #region Create ProjectModule DataTable dtPMID = LibQLSX.Select(" SELECT top 1 ProjectModuleId FROM ProjectModule with(nolock) order by ProjectModuleId desc"); string PMid = TextUtils.ToString(dtPMID.Rows[0]["ProjectModuleId"]); PMid = PMid.Substring(2, PMid.Length - 2); PMid = "PM" + string.Format("{0:00000000}", TextUtils.ToInt(PMid) + 1); ProjectModuleModel projectModule = new ProjectModuleModel(); projectModule.IsModuleStandard = 0; projectModule.Note = ""; projectModule.ProjectModuleCode = moduleCode; projectModule.ProjectModuleName = moduleName; projectModule.Specifications = ""; projectModule.ProjectModuleId = PMid; ProjectModuleBO.Instance.InsertQLSX(projectModule); #endregion #region Update ProjectProducts ArrayList listPP = ProjectProductsBO.Instance.FindByAttribute("PProductId", manageId); projectProduct = (ProjectProductsModel)listPP[0]; projectProduct.ProjectModuleId = projectModule.ProjectModuleId; projectProduct.TypeId = typeID; ProjectProductsBO.Instance.UpdateQLSX(projectProduct); #endregion #region Create ChildModule DataRow[] drsChild = _dtModule.Select("ParentID = " + ID); if (drsChild.Length > 0) { foreach (DataRow item in drsChild) { string moduleCode1 = TextUtils.ToString(item["F5"]); string moduleName1 = TextUtils.ToString(item["F3"]); int ID1 = TextUtils.ToInt(item["ID"]); int parentID1 = TextUtils.ToInt(item["ParentID"]); int qty1 = TextUtils.ToInt(item["F7"]); string manageId1 = projectProduct.PProductId; addModule(moduleCode1, moduleName1, ID1, parentID1, qty1, manageId1, ""); } } #endregion }
private void chưaYCVTToolStripMenuItem_Click(object sender, EventArgs e) { string pProductId = TextUtils.ToString(treeData.FocusedNode.GetValue(colPProductId)); if (pProductId == "") { return; } ProjectProductsModel m = (ProjectProductsModel)ProjectProductsBO.Instance.FindByAttribute("PProductId", pProductId)[0]; m.IsYCVT = 0; ProjectProductsBO.Instance.UpdateQLSX(m); treeData.FocusedNode.SetValue(colIsYCVT, false); }
void addModule(string moduleCode, string moduleName, int ID, int parentID, int qty, string manageId, string moduleCodeHD) { string typeID = "T0068"; DataTable dt = LibQLSX.Select("select TypeId from SourceCode with(nolock) where FolderCode = '" + moduleCode + "'"); if (dt.Rows.Count > 0) { typeID = TextUtils.ToString(dt.Rows[0]["TypeId"]); } ProjectProductsModel projectProduct = new ProjectProductsModel(); if (parentID == 0) { if (moduleCode.StartsWith("TPAD")) { DataTable dtPP = LibQLSX.Select("select * from vGetProductOfProject with(nolock) where ManageId = '" + manageId + "' and PPCode = '" + moduleCodeHD + "'"); foreach (DataRow row in dtPP.Rows) { string id = TextUtils.ToString(row["PProductId"]); #region Create ProjectModule DataTable dtPMID = LibQLSX.Select(" SELECT top 1 ProjectModuleId FROM ProjectModule with(nolock) order by ProjectModuleId desc"); string PMid = TextUtils.ToString(dtPMID.Rows[0]["ProjectModuleId"]); PMid = PMid.Substring(2, PMid.Length - 2); PMid = "PM" + string.Format("{0:00000000}", TextUtils.ToInt(PMid) + 1); ProjectModuleModel projectModule = new ProjectModuleModel(); projectModule.IsModuleStandard = 0; projectModule.Note = ""; projectModule.ProjectModuleCode = moduleCode; projectModule.ProjectModuleName = moduleName; projectModule.Specifications = ""; projectModule.ProjectModuleId = PMid; ProjectModuleBO.Instance.InsertQLSX(projectModule); #endregion #region Update ProjectProducts ArrayList listPP = ProjectProductsBO.Instance.FindByAttribute("PProductId", id); projectProduct = (ProjectProductsModel)listPP[0]; projectProduct.ProjectModuleId = PMid; projectProduct.TypeId = typeID; ProjectProductsBO.Instance.UpdateQLSX(projectProduct); #endregion #region Create ChildModule DataRow[] drsChild = _dtModule.Select("ParentID = " + ID); if (drsChild.Length > 0) { foreach (DataRow item in drsChild) { string moduleCode1 = TextUtils.ToString(item["F5"]); string moduleName1 = TextUtils.ToString(item["F3"]); int ID1 = TextUtils.ToInt(item["ID"]); int parentID1 = TextUtils.ToInt(item["ParentID"]); int qty1 = TextUtils.ToInt(item["F7"]); string manageId1 = projectProduct.PProductId; addModule(moduleCode1, moduleName1, ID1, parentID1, qty1, manageId1, ""); } } #endregion } } else //Nếu là vật tư phụ { #region Create ProjectModule DataTable dtPMID = LibQLSX.Select(" SELECT top 1 ProjectModuleId FROM ProjectModule with(nolock) order by ProjectModuleId desc"); string PMid = TextUtils.ToString(dtPMID.Rows[0]["ProjectModuleId"]); PMid = PMid.Substring(2, PMid.Length - 2); PMid = "PM" + string.Format("{0:00000000}", TextUtils.ToInt(PMid) + 1); ProjectModuleModel projectModule = new ProjectModuleModel(); projectModule.IsModuleStandard = 0; projectModule.Note = ""; projectModule.ProjectModuleCode = moduleCode; projectModule.ProjectModuleName = moduleName; projectModule.Specifications = ""; projectModule.ProjectModuleId = PMid; ProjectModuleBO.Instance.InsertQLSX(projectModule); #endregion #region Create ProjectProducts DataTable dtPPID = LibQLSX.Select(" SELECT top 1 PProductId FROM ProjectProducts with(nolock) order by PProductId desc"); string PPid = TextUtils.ToString(dtPPID.Rows[0]["PProductId"]); PPid = PPid.Substring(2, PPid.Length - 2); PPid = "PP" + string.Format("{0:00000000}", TextUtils.ToInt(PPid) + 1); projectProduct.DepartmentCreateId = "D009"; projectProduct.DepartmentDesignId = "D009"; projectProduct.ManageId = manageId; projectProduct.ManufacturerId = "M000000001"; projectProduct.PProductInforId = ""; projectProduct.ProjectId = TextUtils.ToString(grvProject.GetFocusedRowCellValue(colProjectID)); projectProduct.ProjectModuleId = projectModule.ProjectModuleId; projectProduct.Status = 2; projectProduct.StatusCheckDesignInfor = 1; projectProduct.StatusConfirm = 1; projectProduct.Total = qty; projectProduct.TypeId = typeID; projectProduct.Origin = "Việt Nam"; projectProduct.PProductId = PPid; ProjectProductsBO.Instance.InsertQLSX(projectProduct); #endregion } } else //nếu là module con { #region Create ProjectModule DataTable dtPMID = LibQLSX.Select(" SELECT top 1 ProjectModuleId FROM ProjectModule with(nolock) order by ProjectModuleId desc"); string PMid = TextUtils.ToString(dtPMID.Rows[0]["ProjectModuleId"]); PMid = PMid.Substring(2, PMid.Length - 2); PMid = "PM" + string.Format("{0:00000000}", TextUtils.ToInt(PMid) + 1); ProjectModuleModel projectModule = new ProjectModuleModel(); projectModule.IsModuleStandard = 0; projectModule.Note = ""; projectModule.ProjectModuleCode = moduleCode; projectModule.ProjectModuleName = moduleName; projectModule.Specifications = ""; projectModule.ProjectModuleId = PMid; ProjectModuleBO.Instance.InsertQLSX(projectModule); #endregion #region Create ProjectProducts DataTable dtPPID = LibQLSX.Select(" SELECT top 1 PProductId FROM ProjectProducts with(nolock) order by PProductId desc"); string PPid = TextUtils.ToString(dtPPID.Rows[0]["PProductId"]); PPid = PPid.Substring(2, PPid.Length - 2); PPid = "PP" + string.Format("{0:00000000}", TextUtils.ToInt(PPid) + 1); projectProduct.DepartmentCreateId = "D009"; projectProduct.DepartmentDesignId = "D009"; projectProduct.ManageId = manageId; projectProduct.ManufacturerId = "M000000001"; projectProduct.PProductInforId = ""; projectProduct.ProjectId = TextUtils.ToString(grvProject.GetFocusedRowCellValue(colProjectID)); projectProduct.ProjectModuleId = projectModule.ProjectModuleId; projectProduct.Status = 2; projectProduct.StatusCheckDesignInfor = 1; projectProduct.StatusConfirm = 1; projectProduct.Total = qty; projectProduct.TypeId = typeID; projectProduct.Origin = "Việt Nam"; projectProduct.PProductId = PPid; ProjectProductsBO.Instance.InsertQLSX(projectProduct); #endregion #region Create ChildModule DataRow[] drsChild = _dtModule.Select("ParentID = " + ID); if (drsChild.Length > 0) { foreach (DataRow item in drsChild) { string moduleCode1 = TextUtils.ToString(item["F5"]); string moduleName1 = TextUtils.ToString(item["F3"]); int ID1 = TextUtils.ToInt(item["ID"]); int parentID1 = TextUtils.ToInt(item["ParentID"]); int qty1 = TextUtils.ToInt(item["F7"]); string manageId1 = projectProduct.PProductId; addModule(moduleCode1, moduleName1, ID1, parentID1, qty1, manageId1, ""); } } #endregion } }
protected ProjectProductsFacade(ProjectProductsModel model) : base(model) { }
void addModule(string moduleCode, string moduleName, int ID, int qty, string manageId, decimal price) { string typeID = "T0068"; DataTable dt = LibQLSX.Select("select TypeId from SourceCode with(nolock) where FolderCode = '" + moduleCode + "'"); if (dt.Rows.Count > 0) { typeID = TextUtils.ToString(dt.Rows[0]["TypeId"]); } ProjectProductsModel projectProduct = new ProjectProductsModel(); #region Create PProductInfor DataTable dtPMID = LibQLSX.Select(" SELECT top 1 PProductInforId FROM PProductInfor with(nolock) order by PProductInforId desc"); string PMid = TextUtils.ToString(dtPMID.Rows[0]["PProductInforId"]);//PPI0000001 PMid = PMid.Substring(3, PMid.Length - 3); PMid = "PPI" + string.Format("{0:0000000}", TextUtils.ToInt(PMid) + 1); PProductInforModel ppi = new PProductInforModel(); ppi.PPCode = moduleCode.Length >= 50 ? moduleCode.Substring(0, 50) : moduleCode; ppi.PPName = moduleName; ppi.Price = price; ppi.PProductInforId = PMid; PProductInforBO.Instance.InsertQLSX(ppi); #endregion #region Create ProjectProducts DataTable dtPPID = LibQLSX.Select(" SELECT top 1 PProductId FROM ProjectProducts with(nolock) order by PProductId desc"); string PPid = TextUtils.ToString(dtPPID.Rows[0]["PProductId"]); PPid = PPid.Substring(2, PPid.Length - 2); PPid = "PP" + string.Format("{0:00000000}", TextUtils.ToInt(PPid) + 1); projectProduct.DepartmentCreateId = "D002"; //projectProduct.DepartmentDesignId = "D009"; projectProduct.ManageId = manageId; projectProduct.ManufacturerId = "M000000001"; projectProduct.ProjectModuleId = ""; projectProduct.ProjectId = TextUtils.ToString(grvProject.GetFocusedRowCellValue(colProjectID)); projectProduct.PProductInforId = ppi.PProductInforId; projectProduct.Status = 1; projectProduct.StatusCheckDesignInfor = 1; projectProduct.StatusConfirm = 1; projectProduct.Total = qty; projectProduct.TypeId = typeID; projectProduct.Origin = "Việt Nam"; projectProduct.PProductId = PPid; ProjectProductsBO.Instance.InsertQLSX(projectProduct); #endregion #region Create ChildModule DataRow[] drsChild = _dtProduct.Select("F2 = '" + ID + "'"); if (drsChild.Length > 0) { foreach (DataRow item in drsChild) { string moduleName1 = TextUtils.ToString(item["F4"]); string moduleCode1 = TextUtils.ToString(item["F5"]); if (moduleCode1 == "") { moduleCode1 = moduleName1.Length >= 50 ? moduleName1.Substring(0, 50) : moduleName1; } int ID1 = TextUtils.ToInt(item["F1"]); int qty1 = TextUtils.ToInt(item["F7"]); decimal price1 = TextUtils.ToDecimal(item["F8"]); string manageId1 = projectProduct.PProductId; addModule(moduleCode1, moduleName1, ID1, qty1, manageId1, price1); } } #endregion }