private void btnSave_Click(object sender, EventArgs e)
{
ConfirmPO newConfirmPOObj = new ConfirmPO();
newConfirmPOObj.KHMS = txbKHMS.Text;
newConfirmPOObj.IDContract = txbIDContract.Text;
newConfirmPOObj.POID = txbPOID.Text;
newConfirmPOObj.PONumber = txbPONumber.Text;
newConfirmPOObj.ConfirmPOID = txbConfirmPOID.Text;
newConfirmPOObj.MrPhoBan = txbForBan.Text;
newConfirmPOObj.MrPhoBanMobile = txbMobileForBan.Text;
newConfirmPOObj.MrGD_CSKH = txbGDCSKH.Text;
newConfirmPOObj.MrGD_CSKH_mobile = txbMobileGDCSKH.Text;
newConfirmPOObj.MrGD_CSKH_Landline = txbLandLineGDCSKH.Text;
newConfirmPOObj.MrrGD_CSKH_LandlineExt = txbExt.Text;
int ret = 0;
/*Create Folder NTKT*/
string strContractDirectory = txbIDContract.Text.Replace('/', '_');
strContractDirectory = strContractDirectory.Replace('-', '_');
string strPODirectory = "F:\\OPM\\" + strContractDirectory + "\\" + txbPONumber.Text;
ret = newConfirmPOObj.CheckExistConfirmPO(txbConfirmPOID.Text);
if (0 == ret)
{
ret = newConfirmPOObj.InsertNewConfirmPO(newConfirmPOObj);
if (0 == ret)
{
MessageBox.Show(ConstantVar.CreateNewConfirmPOFail);
}
else
{
MessageBox.Show(ConstantVar.CreateNewConfirmPOSuccess);
/*Create Bao Lanh Thuc Hien Hop Dong*/
string fileCVXNDH_temp = @"F:\LP\CV_XNDH_Template.docx";
string strCVXNDHName = strPODirectory + "\\CV Xác Nhận Đơn Hàng_" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
strCVXNDHName = strCVXNDHName.Replace("/", "_");
ContractObj contractObj = new ContractObj();
ret = ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj);
PO pO = new PO();
ret = PO.GetObjectPO(txbPOID.Text, ref pO);
this.Cursor = Cursors.WaitCursor;
OpmWordHandler.Create_VBConfirm_PO(fileCVXNDH_temp, strCVXNDHName, newConfirmPOObj, pO, contractObj);
this.Cursor = Cursors.Default;
}
/*Create File Nghiệm Thu Kỹ Thuật*/
/*Request Update Catalog Admin*/
}
}
public static void Create_VBConfirm_PO(object filename, object SaveAs, ConfirmPO confirmPO, PO objPO, ContractObj contractObj)
{
WordOffice.Application wordApp = new WordOffice.Application();
object missing = Missing.Value;
WordOffice.Document myWordDoc = null;
if (File.Exists((string)filename))
{
object readOnly = false;
object isVisible = false;
wordApp.Visible = false;
myWordDoc = wordApp.Documents.Open(ref filename, ref missing, ref readOnly,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing);
myWordDoc.Activate();
//find and replace
FindAndReplace(wordApp, "<dd>", " " + DateTime.Now.ToString("dd") + " ");
FindAndReplace(wordApp, "<MM>", " " + DateTime.Now.ToString("MM") + " ");
FindAndReplace(wordApp, "<yyyy>", " " + DateTime.Now.ToString("yyyy") + " ");
FindAndReplace(wordApp, "<XNDH_ID>", " " + confirmPO.ConfirmPOID + " ");
FindAndReplace(wordApp, "<DateNow>", " " + DateTime.Now.ToString("dd/MM/yyyy") + " ");
FindAndReplace(wordApp, "<PO_Number>", " " + confirmPO.PONumber + " ");
FindAndReplace(wordApp, "<PO_ID>", " " + confirmPO.POID + " ");
FindAndReplace(wordApp, "<PO_DateCreated>", " " + objPO.DateCreatedPO + " ");
FindAndReplace(wordApp, "<KHMS>", " " + confirmPO.KHMS + " ");
FindAndReplace(wordApp, "<Contract_ID>", " " + confirmPO.IDContract + " ");
FindAndReplace(wordApp, "<Contract_Name>", " " + contractObj.NameContract + " ");
FindAndReplace(wordApp, "<Contract_DateSigned>", " " + contractObj.DateSigned + " ");
FindAndReplace(wordApp, "<Site_B>", " " + contractObj.SiteB + " ");
FindAndReplace(wordApp, "<MrPhoBan>", " " + confirmPO.MrPhoBan + " ");
FindAndReplace(wordApp, "<Mobile>", " " + confirmPO.MrPhoBanMobile + " ");
FindAndReplace(wordApp, "<MrGDCSKH>", " " + confirmPO.MrGD_CSKH + " ");
FindAndReplace(wordApp, "<MrGDMobile>", " " + confirmPO.MrGD_CSKH_mobile + " ");
FindAndReplace(wordApp, "<LandLine>", " " + confirmPO.MrGD_CSKH_Landline + " ");
FindAndReplace(wordApp, "<Ext>", " " + confirmPO.MrrGD_CSKH_LandlineExt + " ");
}
else
{
MessageBox.Show("File Xác Nhận Đơn Hàng Not Found!");
}
//Save as
myWordDoc.SaveAs2(ref SaveAs, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing);
myWordDoc.Close();
wordApp.Quit();
MessageBox.Show("File Xác Nhận Đơn Hàng Đã Được Created!");
}
