private void btnSave_Click(object sender, EventArgs e) { /*Check PO in DB*/ int ret = 0; /*Save The Edited Contract Info */ PO newPO = new PO(); newPO.IDContract = txbIDContract.Text; newPO.IDPO = txbPOCode.Text; newPO.PONumber = txbPOName.Text; newPO.NumberOfDevice = float.Parse(txbNumberDevice.Text); newPO.DateCreatedPO = TimePickerDateCreatedPO.Value.ToString("yyyy-MM-dd"); newPO.DurationConfirmPO = TimePickerDateConfirmPO.Value.ToString("yyyy-MM-dd"); newPO.DefaultActiveDatePO = TimepickerDefaultActive.Value.ToString("yyyy-MM-dd"); newPO.DeadLinePO = TimePickerDeadLinePO.Value.ToString("yyyy-MM-dd"); newPO.TotalValuePO = float.Parse(txbValuePO.Text); newPO.Tupo = float.Parse(txbTUPO.Text); //Check và tạo forder theo mẫu string DriveName = ""; DriveInfo[] driveInfos = DriveInfo.GetDrives(); foreach (DriveInfo driveInfo in driveInfos) { //MessageBox.Show(driveInfo.Name.ToString()); if (String.Compare(driveInfo.Name.ToString().Substring(0, 3), @"D:\") == 0 || String.Compare(driveInfo.Name.ToString().Substring(0, 3), @"E:\") == 0) { //MessageBox.Show(driveInfo.Name.ToString().Substring(0, 1)); DriveName = driveInfo.Name.ToString().Substring(0, 3); break; } } Directory.CreateDirectory(DriveName + "OPM"); Directory.CreateDirectory(DriveName + "OPM" + txbPOName.Text); string strPODirectory = DriveName + "OPM\\" + txbPOName.Text; /*Create Folder Contract on F Disk*/ //string strContractDirectory = txbIDContract.Text.Replace('/', '_'); //strContractDirectory = strContractDirectory.Replace('-', '_'); //string strPODirectory = "F:\\OPM\\" + strContractDirectory + "\\" + txbPOName.Text; ret = newPO.GetDetailPO(txbPOCode.Text); if (0 == ret) { if (!Directory.Exists(strPODirectory)) { Directory.CreateDirectory(strPODirectory); MessageBox.Show("Folder have been created!!!"); } else { MessageBox.Show("Folder already exist!!!"); } ret = newPO.InsertNewPO(newPO); if (2 == ret) { MessageBox.Show("Cập nhật thành công"); } else { MessageBox.Show(ConstantVar.CreateNewPOSuccess); UpdateCatalogPanel(txbPOName.Text); /*Create Bao Lanh Thuc Hien Hop Dong*/ Directory.CreateDirectory(DriveName + "LP"); string fileBLTUPO_temp = DriveName + @"LP\BLPO_Template.docx"; //string fileBLTUPO_temp = @"F:\LP\BLPO_Template.docx"; string strBLTUPOName = strPODirectory + "\\De nghi Bao lanh thuc hien & tam ung PO MSTT.docx"; /*truy Suất thông tin của Contract*/ ContractObj contractObj = new ContractObj(); ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj); this.Cursor = Cursors.WaitCursor; OpmWordHandler.Create_BLTU_PO(fileBLTUPO_temp, strBLTUPOName, txbPOName.Text, txbIDContract.Text, contractObj.NameContract, contractObj.DateSigned, TimePickerDateCreatedPO.Value.ToString("yyyy-MM-dd"), txbValuePO.Text, txbTUPO.Text, contractObj.SiteB, TimepickerDefaultActive.Value.ToString("yyyy-MM-dd")); /*Send Email To DF*/ string fileBLTUPO_temp1 = DriveName + @"LP\VBDNTU.docx"; //string fileBLTUPO_temp = @"F:\LP\BLPO_Template.docx"; string strBLTUPOName1 = strPODirectory + "\\Van ban de nghi tam ung.docx"; /*truy Suất thông tin của Contract*/ ContractObj contractObj1 = new ContractObj(); ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj1); this.Cursor = Cursors.WaitCursor; OpmWordHandler.Create_VBTUHD(fileBLTUPO_temp1, strBLTUPOName1, txbPOName.Text, txbIDContract.Text, contractObj1.NameContract, contractObj1.DateSigned, TimePickerDateCreatedPO.Value.ToString("yyyy-MM-dd"), txbValuePO.Text, txbTUPO.Text, contractObj1.SiteB, TimepickerDefaultActive.Value.ToString("yyyy-MM-dd")); /*Send Email To DF*/ } /*Create Bao Lanh Thuc Hien Hop Dong*/ //string filename = @"F:\LP\MSTT_Template.docx"; //string strBLHPName = strContractDirectory + "\\Bao_Lanh_Hop_Dong.docx"; //OpmWordHandler.CreateBLTH_Contract(filename, strBLHPName, tbContract.Text, tbBidName.Text, tbxDateSigned.Text, tbxSiteB.Text, txbGaranteeValue.Text, txbGaranteeActiveDate.Text); /*Send Email To DF*/ //OPMEmailHandler.fSendEmail("Mail From DoanTD Gmail", strBLHPName); //UpdateCatalogPanel(txbPOCode.Text); } //đọc file excel--Dưỡng List <ListExpPO> listExpPOs = new List <ListExpPO>(); if (txbnamefilePO.Text != null) { int retEx = OpmExcelHandler.fReadExcelFilePO(txbnamefilePO.Text, txbPOCode.Text, ref listExpPOs); if (retEx == 1) { ListExpPO listExpPO = new ListExpPO(); int retInsert = listExpPO.InsertMultiListPO(listExpPOs); if (retInsert == 1) { MessageBox.Show("thông tin trong File PO đã lưu thành công"); } else { MessageBox.Show("thông tin trong File PO không lưu được"); } } else { MessageBox.Show("Đọc file không thành công"); } } else { MessageBox.Show("Chưa import file Phan bo hop dong"); } }
private void btnSave_Click(object sender, EventArgs e) { /*Check PO in DB*/ int ret = 0; /*Save The Edited Contract Info */ PO newPO = new PO(); newPO.IDContract = txbIDContract.Text; newPO.IDPO = txbPOCode.Text; newPO.PONumber = txbPOName.Text; newPO.NumberOfDevice = float.Parse(txbNumberDevice.Text); newPO.DateCreatedPO = TimePickerDateCreatedPO.Value.ToString("yyyy-MM-dd"); newPO.DurationConfirmPO = TimePickerDateConfirmPO.Value.ToString("yyyy-MM-dd"); newPO.DefaultActiveDatePO = TimepickerDefaultActive.Value.ToString("yyyy-MM-dd"); newPO.DeadLinePO = TimePickerDeadLinePO.Value.ToString("yyyy-MM-dd"); newPO.TotalValuePO = float.Parse(txbValuePO.Text); /*Create Folder Contract on F Disk*/ string strContractDirectory = txbIDContract.Text.Replace('/', '_'); strContractDirectory = strContractDirectory.Replace('-', '_'); string strPODirectory = "F:\\OPM\\" + strContractDirectory + "\\" + txbPOName.Text; ret = newPO.GetDetailPO(txbPOCode.Text); if (0 == ret) { if (!Directory.Exists(strPODirectory)) { Directory.CreateDirectory(strPODirectory); MessageBox.Show("Folder have been created!!!"); } else { MessageBox.Show("Folder already exist!!!"); } ret = newPO.InsertNewPO(newPO); if (0 == ret) { MessageBox.Show(ConstantVar.CreateNewPOFail); } else { MessageBox.Show(ConstantVar.CreateNewPOSuccess); UpdateCatalogPanel(txbPOName.Text); /*Create Bao Lanh Thuc Hien Hop Dong*/ string fileBLTUPO_temp = @"F:\LP\BLPO_Template.docx"; string strBLTUPOName = strPODirectory + "\\De nghi Bao lanh thuc hien & tam ung PO MSTT.docx"; /*truy Suất thông tin của Contract*/ ContractObj contractObj = new ContractObj(); ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj); this.Cursor = Cursors.WaitCursor; OpmWordHandler.Create_BLTU_PO(fileBLTUPO_temp, strBLTUPOName, txbPOName.Text, txbIDContract.Text, contractObj.NameContract, contractObj.DateSigned, TimePickerDateCreatedPO.Value.ToString("yyyy-MM-dd"), txbValuePO.Text, txbTUPO.Text, contractObj.SiteB, txbActiveAfter.Text); /*Send Email To DF*/ OPMEmailHandler.fSendEmail("Mail From DoanTD Gmail", strBLTUPOName); this.Cursor = Cursors.Default; } /*Create Bao Lanh Thuc Hien Hop Dong*/ //string filename = @"F:\LP\MSTT_Template.docx"; //string strBLHPName = strContractDirectory + "\\Bao_Lanh_Hop_Dong.docx"; //OpmWordHandler.CreateBLTH_Contract(filename, strBLHPName, tbContract.Text, tbBidName.Text, tbxDateSigned.Text, tbxSiteB.Text, txbGaranteeValue.Text, txbGaranteeActiveDate.Text); /*Send Email To DF*/ //OPMEmailHandler.fSendEmail("Mail From DoanTD Gmail", strBLHPName); //UpdateCatalogPanel(txbPOCode.Text); } }