protected PProductInforFacade(PProductInforModel 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
}
