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;
}
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;
}
private void btnSave_Click(object sender, EventArgs e)
{
DP dP = new DP();
dP.Id = txbIdDP.Text;
dP.IdContract = txbIDContract.Text;
dP.IdPO = txbPOCode.Text;
dP.MaKT = txbAccountance.Text;
dP.DateDeliver = dtpRequest.Value.ToString("yyyy-MM-dd");
dP.DateOpen = dtpOutCap.Value.ToString("yyyy-MM-dd");
dP.Type = cbbType.Text;
dP.Note = txbPurpose.Text;
int ret = DP.InsertDP(dP);
if (ret == 1)
{
MessageBox.Show("Lưu thành công");
}
else
{
MessageBox.Show("Lưu không thành công");
}
//Check ổ đĩa và tạo forder trên PC
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;
}
}
string strContractDirectory = DriveName + "OPM\\" + txbPOName.Text;
Directory.CreateDirectory(DriveName + "OPM");
Directory.CreateDirectory(DriveName + "OPM" + txbPOName.Text);
string strfileDP = DriveName + "OPM\\" + strContractDirectory + "\\" + txbPOName.Text;
MessageBox.Show(strContractDirectory);
//string strContractDirectory = dP.IdContract.Replace('/', '_');
//strContractDirectory = strContractDirectory.Replace('-', '_');
//string strfileDP = "F:\\OPM\\" + strContractDirectory + "\\" + txbPOName.Text;
SiteInfo siteInfo = new SiteInfo();
siteInfo.GetSiteInfoObject(dP.IdContract, ref siteInfo);
if (1 == ret)
{
int retex = OPM.ExcelHandler.OpmExcelHandler.FindAndReplace(@"F:\LP\DP-template1.xlsx", strfileDP, dP.Id, dP.IdContract, siteInfo.Id, dP.DateDeliver, dP.DateOpen, siteInfo.HeadquaterInfo, dP.Note, dP.MaKT, txbNumber.Text);
if (retex == 0)
{
MessageBox.Show("file excel create false");
}
else
{
MessageBox.Show("file excel created ");
}
}
else
{
MessageBox.Show("lưu không 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*/
}
}
