//private void simpleButton1_Click(object sender, EventArgs e)
//{
// LinkLabel lin=new LinkLabel();
// lin.Text = dem.ToString() + "ậh dhfdjh sdjfsdjh";
// flowLayoutPanel1.Controls.Add(lin);
//}
void LoadTree()
{
DataTable lstApp = _control.LoadAllApplication();
TreeNode root = new TreeNode("Quản lý document");
root.Name = "-1";
tvDocument.Nodes.Add(root);
CTLSearchBug ctlSearchBug = new CTLSearchBug();
foreach (DataRow row in lstApp.Rows)
{
TreeNode nodeApp = new TreeNode(Convert.ToString(row[0]) + " ( " + ctlSearchBug.GetMaxdatemodify(Convert.ToString(row[0]).Trim()) + " )");
nodeApp.ImageIndex = 0;
nodeApp.SelectedImageIndex = 0;
DataTable lstItem = _control.LoadDetailForApp(Convert.ToString(row[0]));
root.Nodes.Add(nodeApp);
foreach (DataRow rowItem in lstItem.Rows)
{
TreeNode nodeItem = new TreeNode(Convert.ToString(rowItem["Item"]) + " ( " + ctlSearchBug.GetMaxdatemodify(Convert.ToString(row[0]).Trim(), Convert.ToString(rowItem["Item"]).Trim()) + " )", 1, 1);
nodeApp.Nodes.Add(nodeItem);
DataTable dtevent = new DataTable();
dtevent = _control.LoadEventForApp(Convert.ToString(row[0]), Convert.ToString(rowItem["Item"]));
foreach (DataRow rowevent in dtevent.Rows)
{
object datemodify = rowevent["DateModify"];
TreeNode nodeEvent = new TreeNode(Convert.ToString(rowevent["Event"]) + " ( " + (datemodify.ToString() == string.Empty ? Convert.ToDateTime(rowevent["DateCreated"]).ToString("dd-MM-yy HH:mm:ss") : Convert.ToDateTime(datemodify).ToString("dd-MM-yy HH:mm:ss")) + " )", 2, 2);
//nodeEvent.Text = Convert.ToString(rowevent["Event"]);
nodeEvent.Name = Convert.ToString(rowevent["ID"]);
nodeItem.Nodes.Add(nodeEvent);
}
}
}
root.Expand();
}
private void btexportExcell_Click(object sender, EventArgs e)
{
FrmNhapLyDo nhapLyDo = new FrmNhapLyDo();
nhapLyDo.ShowDialog();
if (nhapLyDo._isdongy)
{
SaveFileDialog save = new SaveFileDialog();
save.Filter = "*.xls|*.xls|*.pdf|*.pdf";
if (save.ShowDialog() == DialogResult.OK)
{
CXoa.Visible = false;
GrDSSKU.ExportToXls(save.FileName);
if (txtghichu.Text != string.Empty)
{
CTLImportExcel excel = new CTLImportExcel();
excel.WireGhiChuExcel(save.FileName, txtghichu.Text, gridView1.DataRowCount + 5);
}
File.Copy(save.FileName, Path.Combine(Path.Combine(Path.Combine(Application.StartupPath, "ExpCust"), DateTime.Now.ToString("MMyyyy")), DateTime.Now.ToString("ddMMyyhhmmss")));
//GrDSSKU.ExportToXls(save.);
//GrDSSKU.ExportToXls(save.FileName);
CXoa.Visible = true;
CTLSearchBug ctlSearchBug = new CTLSearchBug();
ctlSearchBug.InsertTraceLog(Config._MaNV, DateTime.Now, GetIP(), "FrmXuatBangGia", 1, "FrontEnd Utility", "Export Export Excel");
InfoMessage.HienThi("Xuất file " + save.FileName + " Thành công!!", "Xuất file Excel", "Thông báo",
HinhAnhThongBao.THANHCONG, NutThongBao.DONGY);
}
}
}
public void XetQuyenNhanVien(string id)
{
CTLSearchBug sb = new CTLSearchBug();
DataTable dt = sb.GetQuyenNhanVien(id);
foreach (DataRow dataRow in dt.Rows)
{
switch (dataRow["TenForm"].ToString())
{
case "FrmManageDocument":
btnMasterControl.Enabled = true;
break;
case "FrmSearchBug":
btnUseDocument.Enabled = true;
break;
case "FrmScaleAddTool":
btnScaleAdapterTool.Enabled = true;
break;
case "FrmCheckGia":
btnCheckPrice.Enabled = true; break;
case "FrmBackupDataWinDss":
//btbangbaogia.Enabled = true;
break;
case "FrmKiot":
btnKHTVCheck.Enabled = true;
break;
case "FrmSynPrice":
btSyncPrice.Enabled = true;
break;
case "FrmbangBaoGia":
btbangbaogia.Enabled = true;
break;
case "FrmDonDatHang":
btGhiNhanDonHang.Enabled = true;
break;
case "FrmCheckSKU_CKTM":
btCheckCKTM.Enabled = true;
break;
case "FrmCheckCurrentcy":
frmCheckCurency.Enabled = true;
break;
}
}
}
private void BTXuatfile_Click(object sender, EventArgs e)
{
//SaveFileDialog saveFileDialog = new SaveFileDialog();
//saveFileDialog.Filter = "PRCUPD.*|PRCUPD.*";
//saveFileDialog.FileName = "PRCUPD.001";
//if (saveFileDialog.ShowDialog() == DialogResult.OK)
//{
try
{
if (gridView1.DataRowCount <= 0)
{
InfoMessage.HienThi("Không có dữ liệu export!!!!!", "Vui lòng kiểm tra lại", "Thông báo",
HinhAnhThongBao.THONGTIN, NutThongBao.DONGY);
return;
}
gridView1.FocusedRowHandle = -1;
bool isdata = false;
for (int i = 0; i < gridView1.DataRowCount; i++)
{
DataRow row = gridView1.GetDataRow(i);
if (Convert.ToBoolean(row["Check"]))
{
isdata = true;
}
}
if (!isdata)
{
InfoMessage.HienThi("vui lòng chọn dữ liệu export!!!!!", "Vui lòng kiểm tra lại", "Thông báo",
HinhAnhThongBao.THONGTIN, NutThongBao.DONGY);
return;
}
CTLSearchBug ctlSearchBug = new CTLSearchBug();
int iTo = 0;
int maxP = GetMaxFilePRCUPD();
if (_filepuge < maxP)
{
_filepuge = maxP + 1;
}
if (_filepuge < 999)
{
_filepuge += 1;
}
//for (int i = 0; i < gridView1.DataRowCount;)
//{
//int numTemp = gridView1.DataRowCount - i;
//iTo = numTemp> 100 ? iTo + 100 : iTo + (numTemp);
DirectoryInfo directoryInfo = new DirectoryInfo(Path.Combine(Path.Combine(Application.StartupPath, "ExportBackup"), DateTime.Now.ToString("yyyyMMddhhmm")));
if (!directoryInfo.Exists)
{
directoryInfo.Create();
}
if (!ExportFile(@"H:\Pollfile"))
{
InfoMessage.HienThi("Conect server không thành công!!!!!", "Vui lòng kiểm tra lại", "Thông báo",
HinhAnhThongBao.THONGTIN, NutThongBao.DONGY);
return;
}
ExportFile(directoryInfo.FullName);
//}
// Ghi log file khi export
ctlSearchBug.InsertTraceLog(Config._MaNV, DateTime.Now, GetIP(), "FrmSynPrice", 1, "FrontEnd Utility", "Export PRCUPD file");
InfoMessage.HienThi("Export file " + " thành công !!!!!", "Export file", "Thanh cong",
HinhAnhThongBao.THANHCONG, NutThongBao.DONGY);
return;
}
catch (Exception exception)
{
CTLError.WriteError("Export file from DSSKU ", exception.Message);
//ctlSearchBug.InsertTraceLog(Config._MaNV, DateTime.Now, GetIP(), "FrmSynPrice", 0);
return;
throw;
}
}
public FrmSearchBug()
{
InitializeComponent();
_control = new CTLSearchBug();
LoadTree();
}
protected void linkLabel_LinkClick(object sender, LinkLabelLinkClickedEventArgs e)
{
LinkLabel link = (LinkLabel)sender;
Webdetail.CreateNewDocument();
CTLSearchBug searchBug = new CTLSearchBug();
DataTable createdocument = searchBug.GetCreateDocument(_Tablemanin.Rows[Convert.ToInt32(link.Name)]["ID"].ToString());
if (createdocument != null)
{
if (createdocument.Rows.Count > 0)
{
_isPrintClick = false;
string create = createdocument.Rows[0]["Creator"].ToString();
string date = createdocument.Rows[0]["DateCreated"].ToString();
if (createdocument.Rows[0]["UpDateBy"].ToString().Trim() != "NULL" && createdocument.Rows[0]["UpDateBy"].ToString().Trim() == "null")
{
create = createdocument.Rows[0]["UpDateBy"].ToString();
}
DataTable tbTenNV = searchBug.GetNameCreateDoc(create);
Webdetail.CreateNewDocument();
if (createdocument.Rows[0]["DateModify"].ToString() != string.Empty)
{
date = createdocument.Rows[0]["DateModify"].ToString();
}
if (tbTenNV != null)
{
if (tbTenNV.Rows.Count > 0)
{
create = tbTenNV.Rows[0]["TenNV"] + " - " + tbTenNV.Rows[0]["MaST"] + " - " + tbTenNV.Rows[0]["TenSieuThi"];
}
}
string s = @"<!DOCTYPE html PUBLIC " + '"' + "-//W3C//DTD XHTML 1.0 Transitional//EN" + '"' + " " + '"' + "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" + '"' + @">
<html>
<head>
<meta HTTP-EQUIV=" + '"' + "Content-Type" + '"' + " CONTENT=" + '"' + "text/html; charset=utf-8" + '"' + @" /><title>
</title><style type=" + '"' + "text/css" + '"' + @">
.cs742CAEF8{text-align:center;text-indent:36pt;padding:0pt 0pt 0pt 0pt;margin:0pt 0pt 0pt 36pt}
.cs5EFED22F{color:#000000;background-color:#FFFFC0;font-family:Times New Roman; font-size:11pt; font-weight:normal; font-style:italic; }
.cs676C7CC9{text-align:left;text-indent:0pt;padding:0pt 0pt 0pt 0pt;margin:0pt 0pt 0pt 0pt}
.csC0D2101E{color:#0000FF;background-color:#FFFFC0;font-family:Times New Roman; font-size:11pt; font-weight:normal; font-style:italic; }
.cs6EF5D217{color:#0000FF;background-color:#FFFFC0;font-family:Times New Roman; font-size:11pt; font-weight:normal; font-style:italic; }
.cs3D49C0F4{text-align:center;text-indent:36pt;padding:0pt 0pt 0pt 0pt;margin:0pt 0pt 0pt 36pt}
</style>
</head><body>
<span><p class=" + '"' + @"cs742CAEF8" + '"' + @"><span class=" + '"' + @"csC0D2101E" + '"' + @">" + date + " -- " + @"</span><span class=" + '"' + "csC0D2101E" + '"' + @"> </span><span class="+ '"' + @"csC0D2101E" + '"' + @"> " + create + @"</span></p></span><p class=" + '"' + "cs3D49C0F4" + '"' + "><span class=" + '"' + "cs6EF5D217" + '"' + @">Tài liệu mật - lưu hành nội bộ</span></p><p class=" + '"' + @"cs742CAEF8" + '"' + @"><span class=" + '"' + @"cs5EFED22F" + '"' + @">-------------------------------------------------------</span></p>
</body>
</html>"
;
RichEditControl richEditControl = new RichEditControl();
richEditControl.HtmlText = s;
richEditControl.Refresh();
Webdetail.Document.InsertRtfText(Webdetail.Document.CaretPosition, richEditControl.RtfText);
richEditControl.Dispose();
}
}
//Webdetail.RtfText = dataTable.Rows[0]["IssueContent"].ToString();
RichEditControl noidungftf = new RichEditControl();
noidungftf.RtfText = _Tablemanin.Rows[Convert.ToInt32(link.Name)]["IssueContent"].ToString();
Webdetail.Document.InsertRtfText(Webdetail.Document.CaretPosition, noidungftf.RtfText);
noidungftf.Dispose();
//Webdetail.RtfText = _Tablemanin.Rows[Convert.ToInt32(link.Name)]["IssueContent"].ToString();
_IDDocument = _Tablemanin.Rows[Convert.ToInt32(link.Name)]["ID"].ToString();
if (CheckFeedback(_IDDocument))
{
//Webdetail.Height -= 30;
btviewCm.Enabled = true;
}
else
{
btviewCm.Enabled = false;
}
flowLayoutPanel1.Controls.Clear();
flowLayoutPanel1.Controls.Add(labThongTinlienQuang);
for (int i = 0; i < _Tablemanin.Rows.Count; i++)
{
if (i.ToString() == link.Name)
{
continue;
}
ControlAtt controlAtt = new ControlAtt();
//LinkLabel linkLabel = new LinkLabel();
//linkLabel.Text = _Tablemanin.Rows[i]["Title"].ToString();
//linkLabel.Name = i.ToString();
//linkLabel.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLabel_LinkClick);
//flowLayoutPanel1.Controls.Add(linkLabel);
controlAtt.getlink.Text = _Tablemanin.Rows[i]["Event"].ToString();
controlAtt.getlink.Name = i.ToString();
controlAtt.getlink.LinkClicked += new LinkLabelLinkClickedEventHandler(linkLabel_LinkClick);
controlAtt.getpicturebox.Image = imageList2.Images[0];
flowLayoutPanel1.Controls.Add(controlAtt);
}
_TableAttfile = null;
_TableAttfile = _control.GetAttachment(_Tablemanin.Rows[Convert.ToInt32(link.Name)]["ID"].ToString());
loadAttachmentFile(_TableAttfile);
createdocument.Dispose();
_TableAttfile = null;
}
