private void grvDaiLy_RowCellStyle(object sender, RowCellStyleEventArgs e)
{
GridView View = sender as GridView;
if (e.RowHandle >= 0 && index != 3)
{
O_DAILY dl = View.GetRow(e.RowHandle) as O_DAILY;
if (dl != null)
{
if (dl.SoDu < 0 - dl.QuyChet)
{
if (e.Column.FieldName == "Ten" || e.Column.FieldName == "SoDu")
{
e.Appearance.BackColor = Color.IndianRed;
}
}
if (dl.SoDu < 0 - dl.HanMuc && dl.HanMuc > 0)
{
if (e.Column.FieldName == "HanMuc")
{
e.Appearance.BackColor = Color.IndianRed;
}
}
}
}
}
public frmDaiLyThem(O_DAILY Dl)
{
InitializeComponent();
Text += " sửa";
_DaiLyO = Dl;
iNgayKiQuy.Enabled = false;
}
public frmNhanVienThem(O_DAILY DaiLyO)
{
InitializeComponent();
Text += " sửa";
btnLuu.Visible = DuLieuTaoSan.Q.NhanVienThemSua;
_KhachHangO = DaiLyO;
}
private void gridView1_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
{
O_DAILY gd = (O_DAILY)gridView1.GetRow(gridView1.GetSelectedRows()[0]);
GridView view = sender as GridView;
view.FocusedRowHandle = e.HitInfo.RowHandle;
contextMenu.Show(view.GridControl, e.Point);
}
private void BtnThonKe_Click(object sender, EventArgs e)
{
if (index == 1)
{
O_DAILY dl = GVDL.GetRow(GVDL.GetSelectedRows()[0]) as O_DAILY;
new frmBieuDoDaiLy(dl.ID).ShowDialog();
}
}
private void iDaiLy_EditValueChanged(object sender, EventArgs e)
{
O_DAILY dl = iIDKhachHang.GetSelectedDataRow() as O_DAILY;
lSignIn.EditValue = null;
signInOBindingSource.DataSource = lstSI.Where(w => w.DaiLy.Equals(dl.ID)).ToList();
iMatKhau.Text = RandomPassword();
}
public frmSignIn(O_DAILY dl)
{
InitializeComponent();
splitterControl1.Visible = groupControl2.Visible = false;
groupControl1.Dock = System.Windows.Forms.DockStyle.Fill;
btnThem.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
_dl = dl.ID;
}
private void BtnSIC_Click(object sender, EventArgs e)
{
O_DAILY dl = GVDL.GetRow(GVDL.GetSelectedRows()[0]) as O_DAILY;
if (dl.SIC > 0)
{
new frmSignIn(dl).ShowDialog();
}
}
public frmCongNoPhu(O_DAILY dl)
{
InitializeComponent();
GridViewHelper.SetFromGrid(this, GCCN, GVCN);
daiLyO = dl;
dtp1.EditValue = DateTime.ParseExact("01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(), "d/M/yyyy", null);
dtp2.EditValue = (DateTime.Today.Day == 1) ? DateTime.Today : DateTime.Today;
DuLieu();
Text += " " + dl.Ten;
}
private void GVKL_DoubleClick(object sender, EventArgs e)
{
if (GVKL.GetSelectedRows().Count() > 0)
{
_DaiLyO = GVKL.GetRow(GVKL.GetSelectedRows()[0]) as O_DAILY;
if (_DaiLyO != null)
{
new frmKhachLeThem(_DaiLyO).ShowDialog(this);
}
}
}
private void GVNV_DoubleClick(object sender, EventArgs e)
{
if (GVNV.GetSelectedRows().Count() > 0 && DuLieuTaoSan.Q.NhanVienThemSua)
{
_KhachHangO = GVNV.GetRow(GVNV.GetSelectedRows()[0]) as O_DAILY;
if (_KhachHangO != null)
{
new frmNhanVienThem(_KhachHangO).ShowDialog(this);
}
}
}
private void iIDKhachHang_EditValueChanged(object sender, EventArgs e)
{
if (iIDKhachHang.EditValue != null)
{
O_DAILY dl = (O_DAILY)iIDKhachHang.Properties.GetRowByKeyValue(iIDKhachHang.EditValue);
if (dl != null)
{
bieuDoOBindingSource.DataSource = new BieuDoD().DuLieu1(dl.ID, dl.NgayKiQuy);
}
}
}
private void btnExcel_Click(object sender, EventArgs e)
{
XtraFolderBrowserDialog fbd = new XtraFolderBrowserDialog();
if (fbd.ShowDialog() == DialogResult.OK)
{
D_GIAODICH gdb = new D_GIAODICH();
bool isok = false;
int n = lstDaiLy.CheckedItems.Count;
for (int i = 0; i < n; i++)
{
O_DAILY dl = lstDaiLy.GetItem(lstDaiLy.CheckedIndices[0]) as O_DAILY;
string daily = string.Format("{0}", dl.ID);
List <O_GIAODICH> lstCongNo = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily, true);
if (lstCongNo.Count > 1)
{
gridCTCongNo.Refresh();
isok = true;
CTGiaoDichDindingSource.DataSource = lstCongNo;
// Xuất excel
string strFile = fbd.SelectedPath + @"\" + dl.Ten + " - " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy") + ".xlsx";
XlsxExportOptionsEx opt = new XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản Công Nợ";
gridCTCongNo.ForceInitialize();
grvCTCongNo.Columns["LuyKe"].Width = 90;
grvCTCongNo.Columns["GiaThu"].Width = 90;
grvCTCongNo.Columns["GiaHeThong"].Width = 90;
grvCTCongNo.Columns["TaiKhoanCo"].Width = 90;
grvCTCongNo.Columns["TenKhach"].Width = 400;
grvCTCongNo.OptionsPrint.AutoWidth = false;
grvCTCongNo.OptionsView.ColumnAutoWidth = false;
gridCTCongNo.ExportToXlsx(strFile, opt);
int index = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index, false);
}
}
if (isok)
{
XuLyGiaoDien.Alert("Xuất file thành công!", Form_Alert.enmType.Success);
}
else
{
XuLyGiaoDien.Alert("Không có thông tin", Form_Alert.enmType.Info);
}
}
}
public frmKhachLeThem(O_DAILY _doiTuongO)
{
InitializeComponent();
_DaiLyO = _doiTuongO;
Text += " sửa";
}
private void wVJ_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
{
if (wVJ.ReadyState == WebBrowserReadyState.Complete && !wVJ.IsBusy)
{
HtmlElement head = wVJ.Document.GetElementsByTagName("head")[0];
HtmlElement scriptEl = wVJ.Document.CreateElement("script");
IHTMLScriptElement element = (IHTMLScriptElement)scriptEl.DomElement;
if (wVJ.Url.ToString().Contains("/Login.aspx")) // Đăng nhập
{
wVJ.Document.GetElementById("txtUsernameVNiSC").SetAttribute("value", "admin");
wVJ.Document.GetElementById("txtMatKhau").SetAttribute("value", "11223399");
wVJ.Document.GetElementById("txtAgentCode").SetAttribute("value", "THD");
SoLanDangNhap++;
if (SoLanDangNhap < 4)
{
dynamic body = wVJ.Document.Body.DomElement;
dynamic controlRange = body.createControlRange();
dynamic element1 = wVJ.Document.GetElementById("imgImageValidate").DomElement;
controlRange.add(element1);
controlRange.execCommand("Copy", false, null);
string res = string.Empty;
RetunA:
try
{
res = XuLyGiaoDien.ConvertImgToText((Bitmap)Clipboard.GetDataObject().GetData(DataFormats.Bitmap));
if (res.Length < 3)
{
goto RetunA;
}
}
catch { wVJ.Navigate("http://ags.thanhhoang.vn/Login.aspx"); }
if (wVJ.Document.GetElementById("RequiredFieldValidator3").OuterHtml.Contains("VISIBILITY: hidden"))
{
wVJ.Document.GetElementById("txtImageValidate").SetAttribute("value", res);
wVJ.Visible = true;
wVJ.Document.GetElementById("btnLogin").InvokeMember("click");
}
else
{
goto RetunA;
}
}
} // Đăng nhập
else if (wVJ.Url.ToString().Contains("/Default.aspx") || wVJ.Url.AbsolutePath.Contains("/Booking.aspx")) //Vào trang thêm đại lý
{
wVJ.Navigate("http://ags.thanhhoang.vn/Agent.aspx?Do=SubAgent");
}
else if (wVJ.Url.ToString().EndsWith("Agent.aspx?Do=SubAgent&Act=Add"))// Thêm đại lý
{
dldl = _lstDL.Where(w => w.MaAGS.Equals(lstDLAGS[0])).First();
wVJ.Document.GetElementById("ctl08_txtAgentCode").SetAttribute("value", lstDLAGS[0]);
wVJ.Document.GetElementById("ctl08_txtAgentName").SetAttribute("value", dldl.Ten);
if (lstDLAGS.Count > 0)
{
if (_lstSIChinh.Where(w => w.DaiLy.Equals(dldl.ID) && w.HangBay.Equals(3) && w.Chinh).Count() > 0)
{
lstQAGS.Remove(lstDLAGS[0]);
}
lstDLAGS.Remove(lstDLAGS[0]);
}
wVJ.Document.GetElementById("ctl08_btOK").InvokeMember("click");
}// Thêm đại lý
else if (wVJ.Url.ToString().EndsWith("Agent.aspx?Do=SubAgent"))//Kiểm tra tồn tại đại lý
{
if (lstDLAGS.Count == 0)
{
if (lstQAGS.Count == 0)
{
wVJ.Navigate("http://ags.thanhhoang.vn/Agent.aspx?Do=Ticketing");
}
else
{
wVJ.Navigate("http://ags.thanhhoang.vn/Accounting.aspx?Do=Deposit");
}
}
else
{
if (!ThemDaiLy)
{
HtmlElementCollection hc = wVJ.Document.GetElementsByTagName("div");
for (int i = 0; i < hc.Count; i++)
{
if (hc[i].GetAttribute("classname") == "item first")
{
if (lstDLAGS.Equals(hc[i].InnerText))
{
lstDLAGS.Remove(hc[i].InnerText);
}
}
}
}
ThemDaiLy = lstDLAGS.Count > 0;
if (lstDLAGS.Count > 0)
{
wVJ.Navigate("http://ags.thanhhoang.vn/Agent.aspx?Do=SubAgent&Act=Add");
}
else
{
wVJ.Navigate("http://ags.thanhhoang.vn/Agent.aspx?Do=Ticketing");
}
}
}//Kiểm tra tồn tại đại lý
else if (wVJ.Url.ToString().EndsWith("Accounting.aspx?Do=Deposit&Act=Add"))// Thêm quỹ
{
HtmlElementCollection hc = wVJ.Document.GetElementsByTagName("option");
for (int i = 4; i < hc.Count; i++)
{
lstdic.Add(hc[i].InnerText);
}
int o = lstdic.FindIndex(x => x.StartsWith("0"));
if (o < 0)
{
XtraMessageBox.Show("Đại lý chưa được thêm trên ags", "Thông báo");
Dispose();
Close();
}
else
{
element.text = @"function doPost() { document.getElementById('ctl08_ddlSubAgent').options.item(" + o + ").selected = true; }";
head.AppendChild(scriptEl);
wVJ.Document.InvokeScript("doPost");
wVJ.Document.GetElementById("ctl08_txtAmount").SetAttribute("value", "20000000");
wVJ.Document.GetElementById("ctl08_txtDocNo").SetAttribute("value", "1");
wVJ.Document.GetElementById("ctl08_txtDocDate").SetAttribute("value", DateTime.Now.ToString("dd/MM/yyyy"));
wVJ.Document.Window.ScrollTo(0, 170);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("SoCT", 2);
new D_DAILY().CapNhat(dic, _lstDL.Where(w => w.MaAGS.Equals(lstDLAGS[0])).First().ID);
}
}// Thêm quỹ
else if (wVJ.Url.ToString().Contains("Accounting.aspx?Do=Deposit"))
{
if (lstQAGS.Count > 0)
{
wVJ.Document.GetElementById("ctl08_btnAddNew").InvokeMember("click");
}
}// Thêm quỹ
else if (wVJ.Url.ToString().EndsWith("Agent.aspx?Do=Ticketing&Act=Add"))
{
dldl = _lstDL.Where(w => w.ID.Equals(_lstSIChinh[iVN].DaiLy)).First();
lstMaAGSW = lstMaAGSW.OrderByDescending(w => w).ToList();
HtmlElementCollection hc = wVJ.Document.GetElementsByTagName("option");
for (int i = 4; i < hc.Count; i++)
{
lstdic.Add(hc[i].InnerText);
}
int o = lstdic.FindIndex(x => x.StartsWith(dldl.MaAGS));
string _a = "AG" + dldl.MaAGS + "1";
if (lstMaAGSW.Where(w => w.Contains(dldl.MaAGS)).Count() > 0)
{
string a = lstMaAGSW.Where(w => w.Contains(dldl.MaAGS)).First();
_a = a.Substring(0, a.Length - 1) + (int.Parse(a.Substring(a.Length - 1, 1)) + 1);
}
wVJ.Document.GetElementById("ctl08_txtTenDangNhap").SetAttribute("value", _a);
wVJ.Document.GetElementById("ctl08_txtMatKhau").SetAttribute("value", _lstSIChinh[iVN].MatKhau);
wVJ.Document.GetElementById("ctl08_chkChangePassNextLogin").InvokeMember("click");
wVJ.Document.GetElementById("ctl08_txtHoTen").SetAttribute("value", dldl.Ten);
element.text = @"function doPost() { document.getElementById('ctl08_ddlSubAgent').options.item(" + o + ").selected = true; }";
head.AppendChild(scriptEl);
wVJ.Document.InvokeScript("doPost");
if (_lstSIChinh[iVN].Chinh)
{
element.text = @"function doPost() { document.getElementById('ctl08_ddlPermission').options.item(1).selected = true; }";
head.AppendChild(scriptEl);
wVJ.Document.InvokeScript("doPost");
}
Invoke(new MethodInvoker(delegate()
{
_lstSIChinh[iVN].End = true;
_lstSIChinh[iVN].SignIn = _a.ToString();
GCSI.DataSource = null;
GCSI.DataSource = _lstSIChinh;
GVSI.ExpandAllGroups();
}));
iVN++;
}
else if (wVJ.Url.ToString().EndsWith("Agent.aspx?Do=Ticketing"))
{
lstMaAGSW.Clear();
HtmlElementCollection hc = GetElementByClass("table", "table table-bordered").GetElementsByTagName("tr");
for (int i = 1; i < hc.Count; i++)
{
lstMaAGSW.Add(hc[i].GetElementsByTagName("td")[1].InnerText);
}
for (; iVN < _lstSIChinh.Count; iVN++)
{
if (_lstSIChinh[iVN].End || _lstSIChinh[iVN].HangBay != 3)
{
continue;
}
else
{
wVJ.Navigate("http://ags.thanhhoang.vn/Agent.aspx?Do=Ticketing&Act=Add");
break;
}
}
}
}
}
private void searchLookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
O_DAILY dl = searchLookUpEdit1.GetSelectedDataRow() as O_DAILY;
string[] EmailKeToanString = Regex.Replace(dl.EmailKeToan ?? string.Empty, @"\t|\n|\r", "|").Replace("||", "|").Split('|');
if (EmailKeToanString.Count() > 0)
{
txtTen.Text = (checkEdit1.Checked) ? EmailKeToanString[0] : "*****@*****.**";
}
else
{
txtTen.Text = "*****@*****.**";
}
txtTieuDe.Text = "{Quan Trọng} CẤP SIGIN-IN ĐẠI LÝ " + dl.Ten.ToUpper() + " " + dl.MaDL.ToUpper();
List <O_SIGNIN> signInOs = _lstSIChinh.Where(w => w.DaiLy.Equals(dl.ID)).OrderBy(w => w.HangBay).OrderBy(w => w.Khoa).ToList();
string VJ = string.Empty;
string QH = string.Empty;
string VN = string.Empty;
string BL = string.Empty;
string VU = string.Empty;
for (int i = 0; i < signInOs.Count; i++)
{
switch (signInOs[i].HangBay)
{
case 1:
BL += string.Format(@"<span class='csD4C8F03B'>
TK {2} : {0}<br/>
Mật khẩu : {1}<br/><br/>
</span>", signInOs[i].SignIn, signInOs[i].MatKhau, signInOs[i].Chinh ? "Xuất" : "Book");
break;
case 2:
VJ += string.Format(@"<span class='csD4C8F03B'>
TK {2} : {0}<br/>
Mật khẩu : {1}<br/><br/>
</span>", signInOs[i].SignIn, signInOs[i].MatKhau, signInOs[i].Chinh ? "Xuất" : "Book");
break;
case 3:
VN += string.Format(@"<span class='csD4C8F03B'>
Mã đại lý : THD<br/>
TK {2} : {0}<br/>
Mật khẩu : {1}<br/><br/>
</span>", signInOs[i].SignIn, signInOs[i].MatKhau, signInOs[i].Chinh ? "Xuất" : "Book");
break;
case 6013:
QH += string.Format(@"<span class='csD4C8F03B'>
Mã đại lý : 3780054 <br/>
TK {2} : {0}<br/>
Mật khẩu : {1}<br/><br/>
</span>", signInOs[i].SignIn, signInOs[i].MatKhau, signInOs[i].Chinh ? "Xuất" : "Book");
break;
default:
VU += string.Format(@"<span class='csD4C8F03B'>
TK {2} : {0}<br/>
Mật khẩu : {1}<br/><br/>
</span>", signInOs[i].SignIn, signInOs[i].MatKhau, signInOs[i].Chinh ? "Xuất" : "Book");
break;
}
}
if (VU.Length > 10)
{
VU = string.Format(@"<p class='cs5E94DF1'>
<span class='cs9886E0DD'>VIETRAVEL:</span><span class='csD4C8F03B'> </span>
<span class='cs5D2DD445'>
<a class='cs2356F87D' href='https://booking.vietravelairlines.vn/vi/ta' target='_blank'><span class='csA47FD31'>https://booking.vietravelairlines.vn/vi/ta</span></a>
</span>
<span class='csD4C8F03B'> </span><span class='cs7AFC66BE'><br/></span>
{0}
</span>
</p>", VU);
}
if (BL.Length > 10)
{
BL = string.Format(@"<p class='cs5E94DF1'>
<span class='cs9886E0DD'>JETSTAR:</span><span class='csD4C8F03B'> </span>
<span class='cs5D2DD445'>
<a class='cs2356F87D' href='https://booking.jetstar.com/agenthub/#/login?culture=vi-VN' target='_blank'><span class='csA47FD31'>https://booking.jetstar.com/agenthub/#/login?culture=vi-VN</span></a>
</span>
<span class='csD4C8F03B'> </span><span class='cs7AFC66BE'><br/></span>
{0}
</span>
</p>", BL);
}
if (VJ.Length > 10)
{
VJ = string.Format(@"<p class='cs5E94DF1'>
<span class='cs9886E0DD'>VIETJET:</span><span class='csD4C8F03B'> </span>
<span class='cs5D2DD445'>
<a class='cs2356F87D' href='https://www.vietjetair.com/Sites/Web/vi-VN/Home' target='_blank'><span class='csA47FD31'>https://www.vietjetair.com/Sites/Web/vi-VN/Home</span></a>
</span>
<span class='csD4C8F03B'> </span><span class='cs7AFC66BE'><br/></span>
{0}
</span>
</p>", VJ);
}
if (VN.Length > 10)
{
VN = string.Format(@"<p class='cs5E94DF1'>
<span class='cs9886E0DD'>VIETNAM AIRLINES:</span><span class='csD4C8F03B'> </span>
<span class='cs5D2DD445'>
<a class='cs2356F87D' href='http://ags.thanhhoang.vn/Login.aspx' target='_blank'><span class='csA47FD31'>http://ags.thanhhoang.vn/Login.aspx</span></a>
</span> |
<a class='cs2356F87D' href='http://muadi.com.vn/Login.aspx' target='_blank'><span class='csA47FD31'>http://muadi.com.vn/Login.aspx</span></a>
<span class='csD4C8F03B'> </span><span class='cs7AFC66BE'><br/></span>
{0}
</span>
</p>", VN);
}
if (QH.Length > 10)
{
QH = string.Format(@"<p class='cs5E94DF1'>
<span class='cs9886E0DD'>BAMBOO:</span><span class='csD4C8F03B'> </span>
<span class='cs5D2DD445'>
<a class='cs2356F87D' href='https://www.bambooairways.com/reservation/ibe/login?locale=vi' target='_blank'><span class='csA47FD31'>https://www.bambooairways.com/reservation/ibe/login?locale=vi</span></a>
</span>
<span class='csD4C8F03B'> </span><span class='cs7AFC66BE'><br/></span>
<span class='csD4C8F03B'>
{0}
</span>
</p>", QH);
}
txtMauEmail.HtmlText = ma.NoiDung.Replace("{VN}", VN).Replace("{VJ}", VJ).Replace("{QH}", QH).Replace("{VU}", VU).Replace("{BL}", BL);
}
private void btnExcel_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show("Bạn muốn xuất excel ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int n = lstDaiLyz.CheckedItems.Count;
if (n == 0)
{
XuLyGiaoDien.Alert("Chưa chọn đại lý tìm", Form_Alert.enmType.Info);
}
else
{
GCG.Visible = true;
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
List <long> a = new List <long>();
string daily = string.Format("{0}", lstDaiLyz.CheckedItems[0]);
a.Add(long.Parse(lstDaiLyz.CheckedItems[0].ToString()));
for (int i = 1; i < n; i++)
{
a.Add(long.Parse(lstDaiLyz.CheckedItems[i].ToString()));
daily += string.Format(",{0}", lstDaiLyz.CheckedItems[i]);
}
lst = new D_HOADON().DuLieu(string.Format("CONVERT(date, NgayThucHien) BETWEEN '{0}' AND '{1}' AND MaHD <> '0' AND ((GiaYeuCau - GiaHeThong) * PhanTram / 100) > 0 AND IDKhachHang in ({2}) ORDER BY IDKhachHang,MaHD,MaCho,GiaHeThong Desc", bdtpTu.DateTime.ToString("yyyyMMdd"), bdtpDen.DateTime.ToString("yyyyMMdd"), daily));
foreach (int b in a)
{
O_DAILY dl = lstDaiLy.Where(w => w.ID.Equals(b)).ToList()[0];
XuLyGiaoDien.wait.SetWaitFormDescription("Excel cho: " + dl.Ten);
List <O_HOADON> lstTam1 = lst.Where(w => w.IDKhachHang.Equals(b)).OrderBy(w => w.MaHD.Replace(" ", string.Empty)).ToList();
List <O_HOADON> lstTam = new List <O_HOADON>();
string newrow = string.Empty;
foreach (O_HOADON hd in lstTam1)
{
if (newrow != hd.MaHD && newrow.Length > 0)
{
lstTam.Add(new O_HOADON());
}
lstTam.Add(hd);
newrow = hd.MaHD;
}
lstTam.Add(new O_HOADON()
{
ID = -1,
GiaHeThong = lstTam.Sum(w => w.GiaHeThong),
GiaYeuCau = lstTam.Sum(w => w.GiaYeuCau),
CL1 = lstTam.Sum(w => w.CL1),
CL2 = lstTam.Sum(w => w.CL2),
});
DevExpress.XtraPrinting.XlsxExportOptionsEx opt = new DevExpress.XtraPrinting.XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản CTHD";
guiOBindingSource.DataSource = lstTam;
opt.ApplyFormattingToEntireColumn = DefaultBoolean.False;
opt.ShowGridLines = false;
string strFile = @"C:\HoaDon\CT HoaDon " + dl.Ten + ".xlsx";
Directory.CreateDirectory(@"C:\HoaDon");
GVG.ExportToXlsx(strFile, opt);
}
GCG.Visible = false;
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
}
}
private void BtnUpQuy_Click(object sender, EventArgs e)
{
O_DAILY dl = GVDL.GetRow(GVDL.GetSelectedRows()[0]) as O_DAILY;
new frmQuyAGS(dl).ShowDialog(this);
}
private void btnGuiMail_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show("Bạn muốn gửi mail ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int n = lstDaiLyz.CheckedItems.Count;
if (n == 0)
{
XuLyGiaoDien.Alert("Chưa chọn đại lý tìm", Form_Alert.enmType.Info);
}
else
{
O_CAUHINHSMTP cauHinhSMTPO = cauHinhSMTPD.DuLieu();
O_MAUEMAIL ma = new D_MAUEMAIL().DuLieu()[0];
SmtpClient client = new SmtpClient();
client.Port = cauHinhSMTPO.Port;
client.Host = cauHinhSMTPO.Host;
client.EnableSsl = cauHinhSMTPO.SSL;
client.Timeout = 10000;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(cauHinhSMTPO.Email, cauHinhSMTPO.Password);
GCG.Visible = true; if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
List <long> a = new List <long>();
string daily = string.Format("{0}", lstDaiLyz.CheckedItems[0]);
a.Add(long.Parse(lstDaiLyz.CheckedItems[0].ToString()));
for (int i = 1; i < n; i++)
{
a.Add(long.Parse(lstDaiLyz.CheckedItems[i].ToString()));
daily += string.Format(",{0}", lstDaiLyz.CheckedItems[i]);
}
lst = new D_HOADON().DuLieu(string.Format("CONVERT(date, NgayThucHien) BETWEEN '{0}' AND '{1}' AND MaHD <> '0' AND ((GiaYeuCau - GiaHeThong) * PhanTram / 100) > 0 AND IDKhachHang in ({2}) ORDER BY IDKhachHang,MaHD,MaCho,GiaHeThong Desc", bdtpTu.DateTime.ToString("yyyyMMdd"), bdtpDen.DateTime.ToString("yyyyMMdd"), daily));
DevExpress.XtraPrinting.XlsxExportOptionsEx opt = new DevExpress.XtraPrinting.XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản CTHD";
opt.ApplyFormattingToEntireColumn = DefaultBoolean.False;
opt.ShowGridLines = false;
bool sendOK = false;
foreach (int b in a)
{
O_DAILY dl = lstDaiLy.Where(w => w.ID.Equals(b)).ToList()[0];
txtMauEmail.HtmlText = ma.NoiDung.Replace("{0}", dl.MaDL).Replace("{1}", XuLyDuLieu.NotVietKey(dl.Ten));
string[] EmailKeToanString = System.Text.RegularExpressions.Regex.Replace(dl.EmailKeToan, @"\t|\n|\r", "|").Replace("||", "|").Split('|');
for (int ii = 0; ii < EmailKeToanString.Count(); ii++)
{
if (EmailKeToanString[ii].Length > 5)
{
List <O_HOADON> lstTam1 = lst.Where(w => w.IDKhachHang.Equals(b)).OrderBy(w => w.MaHD.Replace(" ", string.Empty)).ToList();
List <O_HOADON> lstTam = new List <O_HOADON>();
string newrow = string.Empty;
foreach (O_HOADON hd in lstTam1)
{
if (newrow != hd.MaHD && newrow.Length > 0)
{
lstTam.Add(new O_HOADON());
}
lstTam.Add(hd);
newrow = hd.MaHD;
}
lstTam.Add(new O_HOADON()
{
ID = -1,
GiaHeThong = lstTam.Sum(w => w.GiaHeThong),
GiaYeuCau = lstTam.Sum(w => w.GiaYeuCau),
CL1 = lstTam.Sum(w => w.CL1),
CL2 = lstTam.Sum(w => w.CL2),
});
MailMessage mm = new MailMessage();
mm.From = new MailAddress("*****@*****.**", "Thành Hoàng");
mm.BodyEncoding = UTF8Encoding.UTF8;
mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mm.IsBodyHtml = true;
RichEditMailMessageExporter exporter = new RichEditMailMessageExporter(txtMauEmail, mm);
exporter.Export();
mm.To.Add(new MailAddress(EmailKeToanString[ii]));
//mm.To.Add(new MailAddress("*****@*****.**"));
XuLyGiaoDien.wait.SetWaitFormDescription("Excel cho: " + dl.Ten);
guiOBindingSource.DataSource = lstTam;
string strFile = @"C:\HoaDon\CT HoaDon " + dl.Ten + ".xlsx";
System.IO.Directory.CreateDirectory(@"C:\HoaDon");
GVG.ExportToXlsx(strFile, opt);
mm.Attachments.Add(new Attachment(strFile));
mm.Subject = "Bảng kê hóa đơn Tháng " + bdtpTu.DateTime.Month + " - " + dl.Ten;
client.Send(mm);
sendOK = true;
mm.Attachments.Dispose();
if (File.Exists(strFile))
{
File.Delete(strFile);
}
}
}
}
GCG.Visible = false;
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
if (sendOK)
{
XuLyGiaoDien.Alert("Gửi mail thành công", Form_Alert.enmType.Success);
}
else
{
XuLyGiaoDien.Alert("Gửi mail không thành công", Form_Alert.enmType.Warning);
}
}
}
}
private void BtnChiTiet_Click(object sender, EventArgs e)
{
O_DAILY dl = GVDL.GetRow(GVDL.GetSelectedRows()[0]) as O_DAILY;
new frmCongNoPhu(dl).ShowDialog();
}
public frmSignInThem(O_DAILY dl)
{
InitializeComponent();
_SignInO.DaiLy = dl.ID;
Text += " thêm";
}
private void btnGuiMail_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show("Bạn muốn gửi mail ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
D_GIAODICH gdb = new D_GIAODICH();
List <string> vs = new List <string>();
if ((txtFileDinhKem.EditValue ?? string.Empty) != string.Empty)
{
vs = txtFileDinhKem.EditValue.ToString().Split(',').ToList();
}
int n = lstDaiLy.CheckedItems.Count;
if (n == 0)
{
XuLyGiaoDien.Alert("Chưa chọn đại lý cần gửi", Form_Alert.enmType.Info);
}
else
{
try
{
O_CAUHINHSMTP cauHinhSMTPO = cauHinhSMTPD.DuLieu();
O_MAUEMAIL ma = new D_MAUEMAIL().DuLieu()[0];
SmtpClient client = new SmtpClient();
client.Port = cauHinhSMTPO.Port;
client.Host = cauHinhSMTPO.Host;
client.EnableSsl = cauHinhSMTPO.SSL;
client.Timeout = 10000;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(cauHinhSMTPO.Email, cauHinhSMTPO.Password);
grvCTCongNo.Columns["Hang"].Width = 50;
grvCTCongNo.Columns["SoVeVN"].Width = 90;
grvCTCongNo.Columns["LuyKe"].Width = 90;
grvCTCongNo.Columns["GiaThu"].Width = 90;
grvCTCongNo.Columns["GiaHeThong"].Width = 90;
grvCTCongNo.Columns["TaiKhoanCo"].Width = 90;
grvCTCongNo.Columns["TenKhach"].Width = 250;
grvCTCongNo.OptionsPrint.AutoWidth = false;
grvCTCongNo.OptionsView.ColumnAutoWidth = false;
XlsxExportOptionsEx opt = new XlsxExportOptionsEx();
opt.CustomizeCell += op_CustomizeCell;
opt.SheetName = "Bản Công Nợ";
bool sendOK = false;
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
for (int i = 0; i < n; i++)
{
O_DAILY dl = lstDaiLy.GetItem(lstDaiLy.CheckedIndices[0]) as O_DAILY;
if (!dl.GuiMail)
{
int index1 = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index1, false);
continue;
}
lstInt.Add(dl.ID);
string daily = string.Format("{0}", dl.ID);
List <O_GIAODICH> lstCongNo = gdb.LayDanhSachCN((DateTime)dtpTuNgay.EditValue, (DateTime)dtpDenNgay.EditValue, daily, true);
txtMauEmail.HtmlText = ma.NoiDung.Replace("{0}", dl.MaDL).Replace("{1}", XuLyDuLieu.NotVietKey(dl.Ten));
if ((dl.EmailKeToan ?? string.Empty) == string.Empty)
{
goto RE1;
}
string[] EmailKeToanString = Regex.Replace(dl.EmailKeToan, @"\t|\n|\r", "|").Replace("||", "|").Split('|');
for (int ii = 0; ii < EmailKeToanString.Count(); ii++)
{
if (EmailKeToanString[ii].Length > 5)
{
MailMessage mm = new MailMessage();
mm.From = new MailAddress("*****@*****.**", "Thành Hoàng");
mm.BodyEncoding = UTF8Encoding.UTF8;
mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
mm.IsBodyHtml = true;
RichEditMailMessageExporter exporter = new RichEditMailMessageExporter(txtMauEmail, mm);
exporter.Export();
mm.To.Add(new MailAddress(EmailKeToanString[ii]));
//mm.To.Add(new MailAddress("*****@*****.**"));
if (lstCongNo.Count > 1)
{
XuLyGiaoDien.wait.SetWaitFormDescription("Gửi cho: " + dl.Ten + " (" + (i + 1) + "/" + n + ").");
CTGiaoDichDindingSource.DataSource = lstCongNo;
mm.Subject = "Công Nợ - " + dl.Ten + " - Từ ngày " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - đến ngày " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy");
#region Xuất excel
gridCTCongNo.ForceInitialize();
string strFile = @"C:\CongNo\" + dl.Ten + " - " + ((DateTime)dtpTuNgay.EditValue).ToString("dd_MM_yyyy") + " - " + ((DateTime)dtpDenNgay.EditValue).ToString("dd_MM_yyyy") + ".xlsx";
Directory.CreateDirectory(@"C:\CongNo");
gridCTCongNo.ExportToXlsx(strFile, opt);
#endregion
mm.Attachments.Add(new Attachment(strFile));
foreach (string g in vs)
{
if (g.Count() > 0)
{
mm.Attachments.Add(new Attachment(g));
}
}
client.Send(mm);
sendOK = true;
mm.Attachments.Dispose();
if (File.Exists(strFile))
{
File.Delete(strFile);
}
}
}
}
RE1 :
int index = lstDaiLy.FindItem(0, true, delegate(ListBoxFindItemArgs ei) { ei.IsFound = object.Equals(dl.ID, ei.ItemValue); });
lstDaiLy.SetItemChecked(index, false);
}
if (sendOK)
{
XuLyGiaoDien.Alert("Gửi mail thành công", Form_Alert.enmType.Success);
}
else
{
XuLyGiaoDien.Alert("Gửi mail không thành công", Form_Alert.enmType.Warning);
}
}
catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Thông báo"); }
gdb.ChayCapNhatLuyKe(lstInt);
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
}
}
}
void Wb()
{
var chromeDriverService = ChromeDriverService.CreateDefaultService();
var options = new ChromeOptions();
//chromeDriverService.HideCommandPromptWindow = true;
O_NHACUNGCAP cCO = new D_NHACUNGCAP().DuLieu().Where(w => w.Ten.Equals("VJ")).First();
try { driver = new ChromeDriver(chromeDriverService, options, TimeSpan.FromSeconds(300)); }
catch { options.BinaryLocation = @"C:\Program Files\Google\Chrome\Application\chrome.exe"; driver = new ChromeDriver(chromeDriverService, options, TimeSpan.FromSeconds(300)); }
js = driver as IJavaScriptExecutor;
wait = new WebDriverWait(driver, TimeSpan.FromMinutes(5));
for (int i = 0; i < _lstSIChinh.Count; i++)
{
if (_lstSIChinh[i].End || _lstSIChinh[i].HangBay != 2)
{
continue;
}
#region VJ
if (!driver.Url.Contains("vietjetair"))
{
driver.Navigate().GoToUrl("https://www.vietjetair.com/Sites/Web/vi-VN/Home");
wait.Until(d => d.PageSource.Contains("https://agents.vietjetair.com/sitelogin.aspx?lang=vi"));
js.ExecuteScript("location.href = 'https://agents.vietjetair.com/sitelogin.aspx?lang=vi';");
wait.Until(d => d.PageSource.Contains("javascript:SubmitForm();"));
driver.FindElement(By.CssSelector("input[name='txtAgentID']")).SendKeys(cCO.TaiKhoan); //thẻ có tên là
driver.FindElement(By.CssSelector("#txtAgentPswd")).SendKeys(cCO.MatKhau); // # ID
driver.FindElement(By.CssSelector(".button")).Click(); // . Class
wait.Until(d => d.PageSource.Contains("button_big subAgencgyBtn"));
driver.FindElement(By.LinkText("Đại lý con")).Click();
wait.Until(d => CountElementByClassName(driver, "a", "user-icon ng-scope") == 5);
ChromeFindElementByClassName("a", "user-icon ng-scope", 0).Click();
wait.Until(d => d.FindElements(By.LinkText("New user")).Count > 0);
wait.Until(d => d.PageSource.Contains("base-loading-class") == false);
}
O_DAILY dl = _lstDL.Where(w => w.ID.Equals(_lstSIChinh[i].DaiLy)).ToList()[0];
switch (_lstSIChinh[i].CanLam)
{
case 0:
driver.FindElement(By.LinkText("New user")).Click();
wait.Until(d => d.PageSource.Contains("btn btn-secondary ng-binding"));
Thread.Sleep(1000);
wait.Until(d => d.PageSource.Contains("form-control ng-pristine ng-untouched ng-valid-we-validate ng-valid-maxlength ng-valid ng-valid-required"));
Thread.Sleep(2000);
object a = ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-valid-we-validate ng-valid-maxlength ng-valid ng-valid-required", 0).GetAttribute("value");
Invoke(new MethodInvoker(delegate()
{
_lstSIChinh[i].SignIn = a.ToString();
GCSI.DataSource = null;
GCSI.DataSource = _lstSIChinh;
GVSI.ExpandAllGroups();
}));
Actions build = new Actions(driver);
Thread.Sleep(1000);
build.Click(ChromeFindElementByClassName("div", "ui-select-container ui-select-multiple ui-select-bootstrap dropdown form-control ng-valid ng-valid-ui-select-required", 0)).Build().Perform();
Thread.Sleep(1000);
wait.Until(d => d.FindElements(By.LinkText("TA")).Count > 0);
driver.FindElement(By.LinkText("TA HOLD")).Click();
if (_lstSIChinh[i].Chinh)
{
wait.Until(d => d.PageSource.Contains("base-loading-class") == false);
js.ExecuteScript("document.getElementsByClassName('ui-select-search input-xs ng-pristine ng-valid ng-touched')[0].click()");
try
{
driver.FindElement(By.LinkText("TA")).Click();
}
catch { }
}
ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-invalid ng-invalid-required", 0).SendKeys(_lstSIChinh[i].MatKhau);
ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-valid-we-validate ng-invalid ng-invalid-required", 0).SendKeys(_lstSIChinh[i].MatKhau);
ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-valid-we-validate ng-invalid ng-invalid-required ng-valid-maxlength ng-valid-email", 0).SendKeys((dl.EmailGiaoDich ?? "*****@*****.**").Replace("\r\n", "|").Split('|')[0]);
ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-valid-we-validate ng-invalid ng-invalid-required ng-valid-maxlength", 0).SendKeys(dl.DiDong ?? "0919415995");
ChromeFindElementByClassName("input", "form-control ng-pristine ng-untouched ng-invalid ng-invalid-required ng-valid-maxlength", 0).SendKeys(_lstSIChinh[i].SignIn + "-" + XuLyDuLieu.NotVietKey(dl.Ten).Replace(" ", string.Empty));
new SelectElement(ChromeFindElementByClassName("select", "form-control ng-pristine ng-untouched ng-invalid ng-invalid-required")).SelectByIndex(47);
ChromeFindElementByClassName("button", "btn btn-secondary ng-binding", 0).Submit();
Thread.Sleep(1000);
wait.Until(d => d.PageSource.Contains("base-loading-class") == false);
wait.Until(d => d.FindElements(By.LinkText("New user")).Count > 0);
_lstSIChinh[i].End = true;
break;
}
#endregion
}
driver.Close();
driver.Quit();
}
private void btnTHu_Click(object sender, EventArgs e)
{
if (XtraMessageBox.Show("Bạn muốn thêm phí ?", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int n = lstDaiLyz.CheckedItems.Count;
if (n == 0)
{
XuLyGiaoDien.Alert("Chưa chọn đại lý tìm", Form_Alert.enmType.Info);
}
else
{
if (!XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.ShowWaitForm();
}
List <long> a = new List <long>();
string daily = string.Format("{0}", lstDaiLyz.CheckedItems[0]);
a.Add(long.Parse(lstDaiLyz.CheckedItems[0].ToString()));
for (int i = 1; i < n; i++)
{
a.Add(long.Parse(lstDaiLyz.CheckedItems[i].ToString()));
daily += string.Format(",{0}", lstDaiLyz.CheckedItems[i]);
}
lst = new D_HOADON().DuLieu(string.Format("CONVERT(date, NgayThucHien) BETWEEN '{0}' AND '{1}' AND MaHD <> '0' AND ((GiaYeuCau - GiaHeThong) * PhanTram / 100) > 0 AND IDKhachHang in ({2}) ORDER BY IDKhachHang,MaHD,MaCho,GiaHeThong Desc", bdtpTu.DateTime.ToString("yyyyMMdd"), bdtpDen.DateTime.ToString("yyyyMMdd"), daily));
O_GIAODICH gdo;
O_KHOANGAY kn = new D_KHOANGAY().KiemTraNgayKhoa(bdtpTu.DateTime);
if (kn.KhoaAdmin)
{
return;
}
D_GIAODICH giaoDichD = new D_GIAODICH();
foreach (int b in a)
{
O_DAILY dl = lstDaiLy.Where(w => w.ID.Equals(b)).ToList()[0];
XuLyGiaoDien.wait.SetWaitFormDescription("Thu phí: " + dl.Ten);
gdo = new O_GIAODICH();
gdo.LoaiKhachHang = dl.LoaiKhachHang;
gdo.IDKhachHang = dl.ID;
gdo.MaCho = "HD";
gdo.NVGiaoDich = DuLieuTaoSan.NV.ID;
gdo.GiaThu = gdo.GiaHeThong = long.Parse(lst.Where(w => w.IDKhachHang.Equals(b)).Sum(w => w.CL2).ToString());
gdo.TenKhach = "Phí hóa đơn tháng " + bdtpTu.DateTime.Month;
gdo.CoDinh = true;
gdo.HTTT = 1;
gdo.LoaiGiaoDich = 5;
if (gdo.GiaHeThong > 0)
{
giaoDichD.ThemMoi(XuLyDuLieu.ConvertClassToDic(gdo));
}
}
if (XuLyGiaoDien.wait.IsSplashFormVisible)
{
XuLyGiaoDien.wait.CloseWaitForm();
}
XuLyGiaoDien.Alert("Thêm giao dịch thành công!", Form_Alert.enmType.Success);
}
}
}
public frmQuyAGS(O_DAILY _dl)
{
InitializeComponent();
dl = _dl;
_SoCT = dl.SoCT;
}
