private void btnKTKT_Click(object sender, EventArgs e)
{
string strContractDirectory = txbIDContract.Text.Replace('/', '_');
strContractDirectory = strContractDirectory.Replace('-', '_');
string strPODirectory = @"F:\\OPM\\" + strContractDirectory + "\\" + txbPOName.Text;
/*Create Bao Lanh Thuc Hien Hop Dong*/
int ret = 0;
string fileBBKTKTHH_temp = @"F:\LP\Bien_Ban_KTKT_HH_Template.docx";
string strBBKTKT = strPODirectory + "\\Biên Bản Kiểm Tra Kỹ Thuật_" + txbPOName.Text + "_" + txbIDContract.Text + ".docx";
strBBKTKT = strBBKTKT.Replace("/", "_");
ContractObj contractObj = new ContractObj();
ret = ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj);
PO pO = new PO();
ret = PO.GetObjectPO(txbPOCode.Text, ref pO);
NTKT nTKT = new NTKT();
nTKT.GetObjectNTKTByIDPO(txbPOCode.Text, ref nTKT);
SiteInfo siteInfo = new SiteInfo();
siteInfo.GetSiteInfoObject(txbIDContract.Text, ref siteInfo);
this.Cursor = Cursors.WaitCursor;
OpmWordHandler.Create_BBKTKT_HH(fileBBKTKTHH_temp, strBBKTKT, contractObj, pO, nTKT, siteInfo);
this.Cursor = Cursors.Default;
}
//tạo chứng nhận chất lượng
public static void Create_CNCL(object filename, object SaveAs, string idContract, string pOnumber, string KHMS, string idNTKT, float Nod)
{
WordOffice.Application wordApp = new WordOffice.Application();
object missing = Missing.Value;
WordOffice.Document myWordDoc = null;
try
{
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();
NTKT nTKT = new NTKT();
int ret = nTKT.GetObjectNTKT(idNTKT, ref nTKT);
//find and replace
FindAndReplace(wordApp, "<Contract_ID>", " " + idContract + " ");
FindAndReplace(wordApp, "<PO_Number>", " " + pOnumber + " ");
FindAndReplace(wordApp, "<KHMS>", " " + KHMS + " ");
FindAndReplace(wordApp, "<Total>", " " + (Nod).ToString() + " ");
FindAndReplace(wordApp, "<NofDe>", " " + (Nod - Math.Round((Nod) * 0.02)).ToString() + " ");
FindAndReplace(wordApp, "<BHD>", " " + Math.Round((Nod) * 0.02).ToString() + " ");
string[] dateNow = convertDateFormat.ConvertFormatDate(DateTime.Now.ToString("dd-MM-yyyy"), "dd-MM-yyyy", "dd/MM/yyyy");
FindAndReplace(wordApp, "<dd>/<MM>/<yyyy>", " " + dateNow[0] + "/" + dateNow[1] + "/" + dateNow[2]);
}
else
{
MessageBox.Show("File 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 chứng nhận hợp quy của thiết bị được tạo");
}
catch (Exception)
{
myWordDoc.Close();
wordApp.Quit();
MessageBox.Show("File chứng nhận hợp quy của thiết bị không được tạo thành công");
}
}
// tạo chứng chỉ phần mềm
public static void Create_Sofware_Certificate_Template(object filename, object SaveAs, string idContract, string pOnumber, string KHMS, string idNTKT, float numoD)
{
WordOffice.Application wordApp = new WordOffice.Application();
object missing = Missing.Value;
WordOffice.Document myWordDoc = null;
try
{
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();
NTKT nTKT = new NTKT();
int ret = nTKT.GetObjectNTKT(idNTKT, ref nTKT);
//find and replace
FindAndReplace(wordApp, "<Contract_ID>", " " + idContract + " ");
FindAndReplace(wordApp, "<PO_Number>", " " + pOnumber + " ");
FindAndReplace(wordApp, "<KHMS>", " " + KHMS + " ");
FindAndReplace(wordApp, "<NoD>", " " + (numoD).ToString() + " ");
FindAndReplace(wordApp, "<NoD0.98>", " " + (numoD - Math.Round((numoD) * 0.02)).ToString() + " ");
FindAndReplace(wordApp, "<NoD0.02>", " " + Math.Round((numoD) * 0.02).ToString() + " ");
string[] dateNow = convertDateFormat.ConvertFormatDate(DateTime.Now.ToString("dd-MM-yyyy"), "dd-MM-yyyy", "dd/MM/yyyy");
FindAndReplace(wordApp, "<DateNow>", " " + dateNow[0] + "/" + dateNow[1] + "/" + dateNow[2]);
}
else
{
MessageBox.Show("File 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 Giấy chứng nhận bản quyền phần mềm Được Tạo");
}
catch (Exception)
{
myWordDoc.Close();
wordApp.Quit();
MessageBox.Show("File Giấy chứng nhận bản quyền phần mềm không Tạo thành công");
}
}
private void btnKTKT_Click(object sender, EventArgs e)
{
//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;
//string strContractDirectory = txbIDContract.Text.Replace('/', '_');
//strContractDirectory = strContractDirectory.Replace('-', '_');
//string strPODirectory = @"F:\\OPM\\" + strContractDirectory + "\\" + txbPOName.Text;
/*Create Bao Lanh Thuc Hien Hop Dong*/
int ret = 0;
Directory.CreateDirectory(DriveName + "LP");
string fileBBKTKTHH_temp = DriveName + @"LP\Bien_Ban_KTKT_HH_Template.docx";
//string fileBBKTKTHH_temp = @"F:\LP\Bien_Ban_KTKT_HH_Template.docx";
string strBBKTKT = strPODirectory + "\\Biên Bản Kiểm Tra Kỹ Thuật_" + txbPOName.Text + "_" + txbIDContract.Text + ".docx";
strBBKTKT = strBBKTKT.Replace("/", "_");
ContractObj contractObj = new ContractObj();
ret = ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj);
PO pO = new PO();
ret = PO.GetObjectPO(txbPOCode.Text, ref pO);
NTKT nTKT = new NTKT();
nTKT.GetObjectNTKTByIDPO(txbPOCode.Text, ref nTKT);
SiteInfo siteInfoB = new SiteInfo();
SiteInfo siteInfoA = new SiteInfo();
siteInfoB.GetSiteInfoObject(txbIDContract.Text, ref siteInfoB);
siteInfoA.GetSiteInfoA(txbIDContract.Text, ref siteInfoA);
this.Cursor = Cursors.WaitCursor;
OpmWordHandler.Create_BBKTKT_HH(fileBBKTKTHH_temp, strBBKTKT, contractObj, pO, nTKT, siteInfoB, siteInfoA);
this.Cursor = Cursors.Default;
}
//@Dưỡng Bùi -- Show thông tin NTKT lên UI
public void setValueItemForNTKT(string IDNTKT)
{
NTKT nTKT = new NTKT();
nTKT.GetObjectNTKT(IDNTKT, ref nTKT);
string idPO = null, poNumber = null, idContract = null;
int ret = nTKT.getPOinfor(IDNTKT, ref idPO, ref poNumber, ref idContract);
PO pO = new PO();
string namecontract = null, KHMS = null;
pO.DisplayPO(idPO, ref namecontract, ref KHMS);
this.txbKHMS.Text = (string)KHMS;
this.txbIDContract.Text = (string)idContract;
this.txbPOID.Text = (string)nTKT.POID;
this.txbPONumber.Text = (string)poNumber;
this.txbNTKTID.Text = (string)nTKT.ID_NTKT;
dateTimePickerNTKT.Value = Convert.ToDateTime(nTKT.DateDuKienNTKT);
}
public static void Create_BBKTKT_HH(object filename, object SaveAs, ContractObj contractObject, PO objPO, NTKT nTKT, SiteInfo siteInfo)
{
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, "<PO_Number>", " " + objPO.PONumber + " ");
FindAndReplace(wordApp, "<PO_ID>", " " + objPO.IDPO + " ");
FindAndReplace(wordApp, "<PO_CreatedDate>", " " + objPO.DateCreatedPO + " ");
FindAndReplace(wordApp, "<XNDH_ID>", " " + objPO.IDPO + " ");
FindAndReplace(wordApp, "<XNDH_CreatedDate>", " " + objPO.DefaultActiveDatePO + " ");
FindAndReplace(wordApp, "<NTKT_ID>", " " + nTKT.ID_NTKT + " ");
FindAndReplace(wordApp, "<NTKT_CreatedDate>", " " + nTKT.getCreateDate + " ");
FindAndReplace(wordApp, "<DC>", " " + objPO.NumberOfDevice + " ");
FindAndReplace(wordApp, "<PDC>", " " + (Math.Round((objPO.NumberOfDevice) * 0.02)) + " ");
FindAndReplace(wordApp, "<DateNow>", " " + DateTime.Now.ToString("dd/MM/yyyy") + " ");
FindAndReplace(wordApp, "<Contract_ID>", " " + contractObject.IdContract + " ");
FindAndReplace(wordApp, "<Contract_Name>", " " + contractObject.NameContract + " ");
FindAndReplace(wordApp, "<KHMS>", " " + contractObject.KHMS + " ");
FindAndReplace(wordApp, "<Contract_DateSigned>", " " + contractObject.DateSigned + " ");
FindAndReplace(wordApp, "<Site_B>", " " + contractObject.SiteB + " ");
FindAndReplace(wordApp, "<Address_Site_B>", " " + siteInfo.Address + " ");
FindAndReplace(wordApp, "<LandLine_Site_B>", " " + siteInfo.Phonenumber + " ");
FindAndReplace(wordApp, "<Fax_Site_B>", " " + siteInfo.Tin + " ");
}
else
{
MessageBox.Show("File 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 Biên Bản Kiểm Tra Kĩ Thuật Hàng Hóa Được Tạo");
}
public static void Create_RQNTKT_PO(object filename, object SaveAs, NTKT nTKT, 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, "<NTKT_ID>", " " + nTKT.ID_NTKT + " ");
FindAndReplace(wordApp, "<Date_NTKT_DuKien>", " " + nTKT.DateDuKienNTKT + " ");
FindAndReplace(wordApp, "<PO_Number>", " " + nTKT.PONumber + " ");
FindAndReplace(wordApp, "<PO_ID>", " " + nTKT.POID + " ");
FindAndReplace(wordApp, "<Created_DatePO>", " " + objPO.DateCreatedPO + " ");
FindAndReplace(wordApp, "<KHMS>", " " + nTKT.KHMS + " ");
FindAndReplace(wordApp, "<Contract_ID>", " " + nTKT.IDContract + " ");
FindAndReplace(wordApp, "<Contract_Name>", " " + contractObj.NameContract + " ");
FindAndReplace(wordApp, "<SignedDate_Contract>", " " + contractObj.DateSigned + " ");
FindAndReplace(wordApp, "<Site_B>", " " + contractObj.SiteB + " ");
FindAndReplace(wordApp, "<Mr_PhoBan>", " " + nTKT.MrPhoBan + " ");
FindAndReplace(wordApp, "<Mobile>", " " + nTKT.MrPhoBanMobile + " ");
FindAndReplace(wordApp, "<Mr_GD_HTKT_CSKH>", " " + nTKT.MrGD_CSKH + " ");
FindAndReplace(wordApp, "<Mr_GD_Mobile>", " " + nTKT.MrGD_CSKH_mobile + " ");
FindAndReplace(wordApp, "<MrGDLandLine>", " " + nTKT.MrGD_CSKH_Landline + " ");
FindAndReplace(wordApp, "<Ext>", " " + nTKT.MrrGD_CSKH_LandlineExt + " ");
}
else
{
MessageBox.Show("File 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 Yêu Cầu Nghiệm Thu Kỹ Thuật Đã Được Created!");
}
private void btnSave_Click(object sender, EventArgs e)
{
NTKT newNKTTObj = new NTKT();
newNKTTObj.KHMS = txbKHMS.Text;
newNKTTObj.IDContract = txbIDContract.Text;
newNKTTObj.POID = txbPOID.Text;
newNKTTObj.PONumber = txbPONumber.Text;
newNKTTObj.ID_NTKT = txbNTKTID.Text;
newNKTTObj.DateDuKienNTKT = dateTimePickerNTKT.Value.ToString("yyyy-MM-dd");
newNKTTObj.MrPhoBan = txbForBan.Text;
newNKTTObj.MrPhoBanMobile = txbMobileForBan.Text;
newNKTTObj.MrGD_CSKH = txbGDCSKH.Text;
newNKTTObj.MrGD_CSKH_mobile = txbMobileGDCSKH.Text;
newNKTTObj.MrGD_CSKH_Landline = txbLandLineGDCSKH.Text;
newNKTTObj.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 = newNKTTObj.CheckExistNTKT(txbNTKTID.Text);
if (0 == ret)
{
if (!Directory.Exists(strPODirectory))
{
Directory.CreateDirectory(strPODirectory);
MessageBox.Show("Folder " + txbPONumber.Text + " have been created!!!");
}
else
{
MessageBox.Show("Folder " + txbPONumber.Text + " already exist!!!");
}
ret = newNKTTObj.InsertNewNTKT(newNKTTObj);
if (0 == ret)
{
MessageBox.Show(ConstantVar.CreateNewNTKTFail);
}
else
{
MessageBox.Show(ConstantVar.CreateNewNTKTSuccess);
UpdateCatalogPanel("NTKT_" + txbNTKTID.Text);
/*Create Bao Lanh Thuc Hien Hop Dong*/
string fileRQNTKT_temp = @"F:\LP\NTKT_Request_template.docx";
string strRQNTKTName = strPODirectory + "\\CV De Nghi NTKT_" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
strRQNTKTName = strRQNTKTName.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_RQNTKT_PO(fileRQNTKT_temp, strRQNTKTName, newNKTTObj, pO, contractObj);
this.Cursor = Cursors.Default;
}
/*Create File Nghiệm Thu Kỹ Thuật*/
/*Request Update Catalog Admin*/
}
}
public static void Create_BBKTKT_HH(object filename, object SaveAs, ContractObj contractObject, PO objPO, NTKT nTKT, SiteInfo siteInfo, SiteInfo siteInfoA)
{
WordOffice.Application wordApp = new WordOffice.Application();
object missing = Missing.Value;
WordOffice.Document myWordDoc = null;
try
{
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, "<PO_Number>", " " + objPO.PONumber + " ");
FindAndReplace(wordApp, "<PO_ID>", " " + objPO.IDPO + " ");
string[] PO_CreatedDate = convertDateFormat.ConvertFormatDate(objPO.DateCreatedPO, "yyyy-MM-dd", "dd/MM/yyyy");
FindAndReplace(wordApp, "<PO_CreatedDate>", " " + PO_CreatedDate[0] + "/" + PO_CreatedDate[1] + "/" + PO_CreatedDate[2]);
FindAndReplace(wordApp, "<XNDH_ID>", " " + objPO.IDPO + " ");
string[] XNDH_CreatedDate = convertDateFormat.ConvertFormatDate(objPO.DefaultActiveDatePO, "yyyy-MM-dd", "dd/MM/yyyy");
FindAndReplace(wordApp, "<XNDH_CreatedDate>", " " + XNDH_CreatedDate[0] + "/" + XNDH_CreatedDate[1] + "/" + XNDH_CreatedDate[2]);
FindAndReplace(wordApp, "<NTKT_ID>", " " + nTKT.ID_NTKT + " ");
string[] NTKT_CreatedDate = convertDateFormat.ConvertFormatDate(nTKT.getCreateDate, "yyyy-MM-dd", "dd/MM/yyyy");
FindAndReplace(wordApp, "<NTKT_CreatedDate>", " " + NTKT_CreatedDate[0] + "/" + NTKT_CreatedDate[1] + "/" + NTKT_CreatedDate[2]);
FindAndReplace(wordApp, "<DC>", " " + (Math.Round(nTKT.NumberOfDevice - (nTKT.NumberOfDevice) * 0.02)) + " ");
FindAndReplace(wordApp, "<PDC>", " " + (Math.Round((nTKT.NumberOfDevice) * 0.02)) + " ");
string[] dateNow = convertDateFormat.ConvertFormatDate(DateTime.Now.ToString("dd-MM-yyyy"), "dd-MM-yyyy", "dd/MM/yyyy");
FindAndReplace(wordApp, "<DateNow>", " " + dateNow[0] + "/" + dateNow[1] + "/" + dateNow[2]);
FindAndReplace(wordApp, "<Contract_ID>", " " + contractObject.IdContract + " ");
FindAndReplace(wordApp, "<Contract_Name>", " " + contractObject.NameContract + " ");
FindAndReplace(wordApp, "<KHMS>", " " + contractObject.KHMS + " ");
string[] Contract_DateSigned = convertDateFormat.ConvertFormatDate(contractObject.DateSigned, "dd-MM-yyyy", "dd/MM/yyyy");
FindAndReplace(wordApp, "<Contract_DateSigned>", " " + Contract_DateSigned[0] + "/" + Contract_DateSigned[1] + "/" + Contract_DateSigned[2]);
FindAndReplace(wordApp, "<Site_B>", " " + contractObject.SiteB + " ");
FindAndReplace(wordApp, "<Address_Site_B>", " " + siteInfo.Address + " ");
FindAndReplace(wordApp, "<LandLine_Site_B>", " " + siteInfo.Phonenumber + " ");
FindAndReplace(wordApp, "<Fax_Site_B>", " " + siteInfo.Tin + " ");
FindAndReplace(wordApp, "<LandLine_Site_A>", " " + siteInfoA.Phonenumber + " ");
FindAndReplace(wordApp, "<Fax_Site_A>", " " + siteInfoA.Tin + " ");
}
else
{
MessageBox.Show("File 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 Biên Bản Kiểm Tra Kĩ Thuật Hàng Hóa Được Tạo");
}
catch (Exception)
{
myWordDoc.Close();
wordApp.Quit();
MessageBox.Show("File Biên Bản Kiểm Tra Kĩ Thuật Hàng Hóa không Tạo thành công");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
NTKT newNKTTObj = new NTKT();
newNKTTObj.KHMS = txbKHMS.Text;
newNKTTObj.IDContract = txbIDContract.Text;
newNKTTObj.POID = txbPOID.Text;
newNKTTObj.PONumber = txbPONumber.Text;
newNKTTObj.ID_NTKT = txbNTKTID.Text;
newNKTTObj.DateDuKienNTKT = dateTimePickerNTKT.Value.ToString("yyyy-MM-dd");
newNKTTObj.MrPhoBan = txbForBan.Text;
newNKTTObj.MrPhoBanMobile = txbMobileForBan.Text;
newNKTTObj.MrGD_CSKH = txbGDCSKH.Text;
newNKTTObj.MrGD_CSKH_mobile = txbMobileGDCSKH.Text;
newNKTTObj.MrGD_CSKH_Landline = txbLandLineGDCSKH.Text;
newNKTTObj.MrrGD_CSKH_LandlineExt = txbExt.Text;
int nod = Convert.ToInt32(txbNoD.Text);
newNKTTObj.NumberOfDevice = (float)nod;
int ret = 0;
/*Create Folder NTKT*/
//string strContractDirectory = txbIDContract.Text.Replace('/', '_');
//strContractDirectory = strContractDirectory.Replace('-', '_');
//string strPODirectory = "F:\\OPM\\" + strContractDirectory + "\\" + txbPONumber.Text + "\\" + "NTKT_" +txbNTKTID.Text.ToString();
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" + txbPONumber.Text);
Directory.CreateDirectory(DriveName + "OPM" + txbPONumber.Text + "\\" + "NTKT_" + txbNTKTID.Text.ToString());
string strPODirectory = DriveName + "OPM\\" + txbPONumber.Text + "\\" + "NTKT_" + txbNTKTID.Text.ToString();
ret = newNKTTObj.CheckExistNTKT(txbNTKTID.Text);
if (0 == ret)
{
if (!Directory.Exists(strPODirectory))
{
Directory.CreateDirectory(strPODirectory);
MessageBox.Show("Folder " + txbPONumber.Text + " have been created!!!");
}
else
{
MessageBox.Show("Folder " + txbPONumber.Text + " already exist!!!");
}
ret = newNKTTObj.InsertNewNTKT(newNKTTObj);
if (0 == ret)
{
MessageBox.Show(ConstantVar.CreateNewNTKTFail);
}
else
{
MessageBox.Show(ConstantVar.CreateNewNTKTSuccess);
UpdateCatalogPanel("NTKT_" + txbNTKTID.Text);
/*Create Bao Lanh Thuc Hien Hop Dong*/
Directory.CreateDirectory(DriveName + "LP");
//string fileRQNTKT_temp = @"F:\LP\NTKT_Request_template.docx";
//string fileSofware_Certificate_Template = @"F:\LP\Sofware_Certificate_Template.docx";
//string fileCNCL = @"F:\LP\GIAY CHUNG NHAN CHAT LUONG_TONG_HOP_Template.docx";
string fileRQNTKT_temp = DriveName + @"LP\NTKT_Request_template.docx";
string fileSofware_Certificate_Template = DriveName + @"\LP\Sofware_Certificate_Template.docx";
string fileCNCL = DriveName + @"LP\GIAY CHUNG NHAN CHAT LUONG_TONG_HOP_Template.docx";
string strRQNTKTName = strPODirectory + "\\CV De Nghi NTKT_" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
string strSofware_Certificate = strPODirectory + "\\Chung chi ban quyen phan mem" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
string strCNCL = strPODirectory + "\\Chung nhan chat luong" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
strRQNTKTName = strRQNTKTName.Replace("/", "_");
strSofware_Certificate = strSofware_Certificate.Replace("/", "_");
strCNCL = strCNCL.Replace("/", "_");
ContractObj contractObj = new ContractObj();
int ret0 = ContractObj.GetObjectContract(txbIDContract.Text, ref contractObj);
PO pO = new PO();
int ret1 = PO.GetObjectPO(txbPOID.Text, ref pO);
this.Cursor = Cursors.WaitCursor;
NTKT nTKT = new NTKT();
nTKT.GetObjectNTKTByIDPO(txbPOID.Text, ref nTKT);
int num = Convert.ToInt32(txbNoD.Text);
nTKT.NumberOfDevice = (float)num;
float numofD = (float)num;
OpmWordHandler.Create_RQNTKT_PO(fileRQNTKT_temp, strRQNTKTName, nTKT, pO, contractObj);
OpmWordHandler.Create_Sofware_Certificate_Template(fileSofware_Certificate_Template, strSofware_Certificate, contractObj.IdContract, txbPONumber.Text, txbKHMS.Text, txbNTKTID.Text, numofD);
OpmWordHandler.Create_CNCL(fileCNCL, strCNCL, contractObj.IdContract, txbPONumber.Text, txbKHMS.Text, txbNTKTID.Text, numofD);
/////////////////////////////
/*Create Bao Lanh Thuc Hien Hop Dong*/
int ret2 = 0;
string fileBBKTKTHH_temp = DriveName + @"Bien_Ban_KTKT_HH_Template.docx";
string strBBKTKT = strPODirectory + "\\Biên Bản Kiểm Tra Kỹ Thuật_" + txbPONumber.Text + "_" + txbIDContract.Text + ".docx";
strBBKTKT = strBBKTKT.Replace("/", "_");
SiteInfo siteInfoB = new SiteInfo();
SiteInfo siteInfoA = new SiteInfo();
siteInfoB.GetSiteInfoObject(txbIDContract.Text, ref siteInfoB);
siteInfoA.GetSiteInfoA(txbIDContract.Text, ref siteInfoA);
this.Cursor = Cursors.WaitCursor;
OpmWordHandler.Create_BBKTKT_HH(fileBBKTKTHH_temp, strBBKTKT, contractObj, pO, nTKT, siteInfoB, siteInfoA);
this.Cursor = Cursors.Default;
}
/*Create File Nghiệm Thu Kỹ Thuật*/
/*Request Update Catalog Admin*/
}
}
