private void FillData() { dtDaoTaoKH = DataTool.SQLGetDataTable("HRDAOTAOKH", null, "", "Ma_Bp"); bdsDaoTaoKH.DataSource = dtDaoTaoKH; dgvDaoTaoKH.DataSource = bdsDaoTaoKH; }
public void OnLoad() { //初始化文件夹 DataTool.initFolder(); //初始化配置数据 mainData = DataTool.initConfigData(); //新建UI对象 container = new Container(); //新建一个Fiddler插件的page TabPage page = new TabPage("PlugExample"); //将page加入Fiddler的tab选项卡中 FiddlerApplication.UI.tabsViews.TabPages.Add(page); //将WinForm和WPF联系起来(在WinForm中调用WPF) ElementHost element = new ElementHost(); element.Child = container; element.Dock = DockStyle.Fill; //将WPF挂载对象添加到page中 page.Controls.Add(element); //监听请求响应之前 FiddlerApplication.BeforeRequest += delegate(Session session) { FiddlerTool.handleRequest(session); }; }
void FillData() { dtDmNhCCDC = DataTool.SQLGetDataTable("ASTSNH", null, this.strLookupKeyFilter, null); bdsDmNhCCDC.DataSource = dtDmNhCCDC; bdsDmNhCCDC.Position = 0; bdsDmNhCCDC.Filter = "Loai_Nh IN ('2')"; tlDmNhCCDC.DataSource = bdsDmNhCCDC; //Uy quyen cho lop co so tim kiem bdsSearch = bdsDmNhCCDC; ExportControl = tlDmNhCCDC; tlDmNhCCDC.ExpandAll(); if (bdsDmNhCCDC.Count >= 0) { bdsDmNhCCDC.Position = 0; } if (this.isLookup) { this.MoveToLookupValue(); } }
public override void Delete() { //Ket chuyen phan bo chi tiet 1 if (dgvKetChuyenPbCt.Focused) { this.Delete_KetChuyenPbCt(); return; } if (bdsKetChuyenPb.Position < 0) { return; } if (bdsKetChuyenPbCt.Count != 0) { Common.MsgCancel("Không xóa được khi có dữ liệu chi tiết !"); return; } DataRow drCurrent = ((DataRowView)bdsKetChuyenPb.Current).Row; if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"))) { return; } if (DataTool.SQLDelete("GLKETCHUYENPB", drCurrent)) { bdsKetChuyenPb.RemoveAt(bdsKetChuyenPb.Position); dtKetChuyenPb.AcceptChanges(); } }
private void FillData() { string strKeyFillterCt = " Stt = '" + ((string)drEdit["Stt"]).Trim() + "' "; string strSelectPh = " *, TTien0 + TTien3 AS TTien, TTien_Nt0 + TTien_Nt3 AS TTien_Nt "; string strSelectCt = enuNew_Edit == enuEdit.New ? " TOP 1 * " : "*";// enuNew_Edit == enuEdit.New lấy hàng đầu tiên dtEditPh = DataTool.SQLGetDataTable((string)drDmCt["Table_Ph"], strSelectPh, strKeyFillterCt, null); dtEditCt = DataTool.SQLGetDataTable((string)drDmCt["Table_Ct"], strSelectCt, strKeyFillterCt, null); //ThongLH: History dtEditCtOrg = dtEditCt.Copy(); drEditPhOrg = drEdit; DataColumn dc = new DataColumn("Deleted", typeof(bool)); dc.DefaultValue = false; dtEditCt.Columns.Add(dc); bdsEditCt.DataSource = dtEditCt; dgvEditCt1.DataSource = bdsEditCt; dgvEditCt1.ClearSelection(); dgvEditCt2.DataSource = bdsEditCt; dgvEditCt2.ClearSelection(); }
public void OnLoad() { //初始化配置数据 mainData = new ArrayList(); //新建UI对象 container = new Container(); //新建一个Fiddler插件的page TabPage page = new TabPage("PlugExample"); //将page加入Fiddler的tab选项卡中 FiddlerApplication.UI.tabsViews.TabPages.Add(page); //将WinForm和WPF联系起来(在WinForm中调用WPF) ElementHost element = new ElementHost(); element.Child = container; element.Dock = DockStyle.Fill; //将WPF挂载对象添加到page中 page.Controls.Add(element); //测试代码 addHostRule("127.0.0.1", "8080", "www.example.com"); addHostRule("127.0.0.1", "", "www.example.com"); addHostRule("127.0.0.1", "3366", "www.example.com"); //本地存储测试代码 DataTool.initFolder(); DataTool.writeConfigToFile(); }
public override void Delete() { if (bdsParameters.Position < 0) { return; } drCurrent = ((DataRowView)bdsParameters.Current).Row; //Kiểm tra phân quyền //Xóa if (DataTool.SQLCheckExist("SYSPARAMETER", "Parameter_ID_Parent", drCurrent["PARAMETER_ID"])) { string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Loại : {" + drCurrent["PARAMETER_ID"].ToString() + "} đang có tham số" : "Type: {" + drCurrent["PARAMETER_ID"].ToString() + "} have Parameters"; Common.MsgOk(strMsg); return; } if (Common.MsgYes_No("Bạn có chắc chắn xóa không?", "N")) { if (DataTool.SQLDelete("SYSPARAMETER", drCurrent)) { bdsParameters.RemoveAt(bdsParameters.Position); dtParameters.AcceptChanges(); } this.Refresh(); } }
void txtMa_Hd_Validating(object sender, CancelEventArgs e) { string strValue = txtMa_Hd.Text.Trim(); bool bRequire = false; //Lists.frmHopDong frmLookup = new Epoint.Lists.frmHopDong(); DataRow drLookup = Lookup.ShowLookup("Ma_Hd", strValue, bRequire, "", ""); if (bRequire && drLookup == null) { e.Cancel = true; } if (drLookup == null) { txtMa_Hd.Text = string.Empty; lbtTen_Hd.Text = string.Empty; } else { txtMa_Hd.Text = drLookup["Ma_Hd"].ToString(); lbtTen_Hd.Text = drLookup["Ten_Hd"].ToString(); if (txtMa_Hd.bTextChange) { txtMa_Dt.Text = drLookup["Ma_Dt"].ToString(); lbtTen_Dt.Text = DataTool.SQLGetNameByCode("LIDOITUONG", "Ma_Dt", "Ten_Dt", txtMa_Dt.Text); } } if ((((txtTextLookup)sender).AutoFilter != null) && ((txtTextLookup)sender).AutoFilter.Visible) { ((txtTextLookup)sender).AutoFilter.Visible = false; this.SelectNextControl(this.ActiveControl, true, true, true, true); } }
/// <summary> /// 向指定客户端发送数据 /// </summary> /// <param name="cModel">客户端</param> /// <param name="data">字节数组数据</param> public void SendData(ClientModel cModel, byte[] data) { try { if (cModel != null) { cModel.ClientSocket.Send(data); OnGetLogEnterHead(cModel, LogType.SendData, DataTool.HexByteArrayToString(data)); } } catch (SocketException ex) { if (cModel == null) { ClientSocketList.Remove(cModel); return; } cModel.IsOnline = false; cModel.ClientSocket.Shutdown(SocketShutdown.Both); OnTcpServerOfflineClientEnterHead(cModel); OnTcpServerErrorMsgEnterHead(ex.Message); OnGetLogEnterHead(cModel, LogType.SendData, ex.Message); ClientSocketList.Remove(cModel); } }
public int[] SetFanduty(int fanNo, int fanduty, bool isAuto) { try { if (isAuto) { //自动调节风扇转速 DataTool.SetFANDutyAuto(fanNo); } else { //将风扇转速设置为定值 DataTool.SetFanDuty(fanNo, fanduty); } Thread.Sleep(500); var newFanduty = _updateFanDuty(fanNo); return(newFanduty); } catch (Exception e) { Console.WriteLine(@"设置风扇转速错误,原因:" + e.Message); int[] newFanduty = { -1, -1, -1 }; return(newFanduty); } }
void XemChungTu() { string strMa_Ct = txtMa_Ct.Text.Trim(); Hashtable ht = new Hashtable(); ht["MA_CT"] = txtMa_Ct.Text; ht["NGAY_CT1"] = Library.StrToDate(dteNgay_Ct1.Text); ht["NGAY_CT2"] = Library.StrToDate(dteNgay_Ct2.Text); ht["SO_CT1"] = txtSo_Ct1.Text; ht["SO_CT2"] = txtSo_Ct2.Text; ht["MA_DT"] = txtMa_Dt.Text; ht["MA_KHO"] = txtMa_Kho.Text; ht["MA_NH_VT"] = txtMa_Nh_Vt.Text; ht["MA_VT"] = txtMa_Vt.Text; ht["GETKEY_ONLY"] = true; ht["MA_DVCS"] = Element.sysMa_DvCs; string strKey = (string)SQLExec.ExecuteReturnValue("sp_GetKeyPh", ht, CommandType.StoredProcedure); DataRow drDmCt = DataTool.SQLGetDataRowByID("SYSDMCT", "Ma_Ct", strMa_Ct_Current); string strTable_Ct = (string)drDmCt["Table_Ct"]; frmInheritVoucher_View frm = new frmInheritVoucher_View(); frm.Load(frmEditCt, strMa_Ct, strKey); }
private bool Save() { Common.GatherMemvar(this, ref drEdit); if (drEdit.Table.Columns.Contains("Ten_Vt")) { drEdit["Ten_Vt"] = lbtTen_Vt.Text; } if (drEdit.Table.Columns.Contains("Ten_Dt")) { drEdit["Ten_Dt"] = lbtTen_Dt.Text; } if (drEdit.Table.Columns.Contains("Ma_Nh_Dt") && txtMa_Nh_Dt.Visible == false) { drEdit["Ma_Nh_Dt"] = string.Empty; } //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } //Luu xuong CSDL if (!DataTool.SQLUpdate(enuNew_Edit, "ARGIABAN", ref drEdit)) { return(false); } return(true); }
public override void MergeID() { if (bdsTuyen.Count <= 0) { return; } drCurrent = ((DataRowView)bdsTuyen.Current).Row; string strOldValue = (string)drCurrent["Ma_Tuyen"]; frmMergeID frm = new frmMergeID(); frm.Load("LITUYEN", "Ma_Tuyen", "Ten_Tuyen", strOldValue, "TUYENBH"); if (frm.isAccept) { string strNewValue = frm.strNewValue; string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge {" + strOldValue + "} to {" + strNewValue + "}?" : "Bạn có muốn gộp mã {" + strOldValue + "} sang {" + strNewValue + "} không ?"; if (!Common.MsgYes_No(strMsg)) { return; } if (DataTool.SQLMergeID("Ma_Tuyen", "LITUYEN", strOldValue, strNewValue)) { bdsTuyen.RemoveCurrent(); bdsTuyen.Position = bdsTuyen.Find("Ma_Tuyen", strNewValue); } } }
public override void Delete() { if (bdsResource.Position < 0) { return; } DataRow drCurrent = ((DataRowView)bdsResource.Current).Row; if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"))) { return; } if (DataTool.SQLDelete("SYSRESOURCES_VER", drCurrent)) { //Cập nhật History htHistory["CODE"] = drCurrent[strCode]; htHistory["NAME"] = drCurrent[strName]; htHistory["UPDATE_TYPE"] = "D"; UpdateHistory(); bdsResource.RemoveAt(bdsResource.Position); dtResource.AcceptChanges(); } }
private void FillData() { //Report dtReport = DataTool.SQLGetDataTable("SYSREPORT", "*", null, "Stt"); dtReportFilter = DataTool.SQLGetDataTable("SYSREPORTFILTER", "*", null, "Report_ID,Col,Row,Filter_ID"); dtReportInfo = DataTool.SQLGetDataTable("SYSREPORTINFO", "*", null, "Report_ID,Stt,Column_ID"); dtReportDetail = DataTool.SQLGetDataTable("SYSREPORTDETAIL", "*", null, ""); bdsReport.DataSource = dtReport; tlReport.DataSource = bdsReport; bdsReport.Position = 0; //ReportFilter bdsReportFilter.DataSource = dtReportFilter; dgvReportFilter.DataSource = bdsReportFilter; //ReportInfo bdsReportInfo.DataSource = dtReportInfo; dgvReportInfo.DataSource = bdsReportInfo; //ReportDetail bdsReportDetail.DataSource = dtReportDetail; dgvReportDetail.DataSource = bdsReportDetail; //Uy quyen cho lop co so tim kiem bdsSearch = bdsReport; }
private void FillData() { dtThueTn = DataTool.SQLGetDataTable("HRTHUETN", null, "", "Bang_Thue,Muc_Tn1,Muc_Tn2"); bdsThueTn.DataSource = dtThueTn; dgvThueTn.DataSource = bdsThueTn; }
private void LoadDicName() { //txtMa_Bp if (txtMa_Bp.Text.Trim() != string.Empty) { txtTen_Bp.Text = DataTool.SQLGetNameByCode("LIBOPHAN", "Ma_Bp", "Ten_Bp", txtMa_Bp.Text.Trim()); dicName.SetValue(txtTen_Bp.Name, txtTen_Bp.Text); } else { txtTen_Bp.Text = string.Empty; } //txtMa_ViTri if (txtMa_ViTri.Text.Trim() != string.Empty) { txtTen_ViTri.Text = DataTool.SQLGetNameByCode("HRVITRI", "Ma_ViTri", "Ten_ViTri", txtMa_ViTri.Text.Trim()); dicName.SetValue(txtTen_ViTri.Name, txtTen_ViTri.Text); } else { txtTen_ViTri.Text = string.Empty; } //txtMa_Sp if (txtMa_Sp.Text.Trim() != string.Empty) { txtTen_Sp.Text = DataTool.SQLGetNameByCode("LISANPHAM", "Ma_Sp", "Ten_Sp", txtMa_Sp.Text.Trim()); dicName.SetValue(txtTen_Sp.Name, txtTen_Sp.Text); } else { txtTen_Sp.Text = string.Empty; } }
private void LoadDicName() { if (txtMa_Kho.Text.Trim() != string.Empty) { lbtTen_Kho.Text = DataTool.SQLGetNameByCode("LIKHO", "Ma_Kho", "Ten_Kho", txtMa_Kho.Text.Trim()); } else { lbtTen_Kho.Text = string.Empty; } if (txtMa_Vt.Text.Trim() != string.Empty) { DataRow drDmVt = DataTool.SQLGetDataRowByID("LIVATTU", "Ma_Vt", txtMa_Vt.Text.Trim()); if (drDmVt != null) { lbtTen_Vt.Text = (string)drDmVt["Ten_Vt"]; lbtDvt.Text = "/" + (string)drDmVt["Dvt"]; } } else { lbtTen_Vt.Text = string.Empty; lbtDvt.Text = string.Empty; } }
public override void MergeID() { if (bdsVatTu.Count <= 0) { return; } drCurrent = ((DataRowView)bdsVatTu.Current).Row; string strOldValue = (string)drCurrent["Ma_Vt"]; frmMergeID frm = new frmMergeID(); frm.Load("LIVATTU", "Ma_Vt", "Ten_Vt", strOldValue, "VatTu"); if (frm.isAccept) { string strNewValue = frm.strNewValue; string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?"; if (!Common.MsgYes_No(strMsg)) { return; } if (DataTool.SQLMergeID("Ma_Vt", "LIVATTU", strOldValue, strNewValue)) { bdsVatTu.RemoveCurrent(); bdsVatTu.Position = bdsVatTu.Find("Ma_Vt", strNewValue); } } }
private void LoadDicName() { if (txtTk.Text.Trim() != string.Empty) { lbtTen_Tk.Text = DataTool.SQLGetNameByCode("LITAIKHOAN", "Tk", "Ten_Tk", txtTk.Text.Trim()); dicName.Add(lbtTen_Tk.Name, lbtTen_Tk.Text); } else { lbtTen_Tk.Text = string.Empty; } if (txtMa_Dt.Text.Trim() != string.Empty) { lbtTen_Dt.Text = DataTool.SQLGetNameByCode("LIDOITUONG", "Ma_Dt", "Ten_Dt", txtMa_Dt.Text.Trim()); dicName.Add(lbtTen_Dt.Name, lbtTen_Dt.Text); } else { lbtTen_Dt.Text = string.Empty; } if (txtMa_Sp.Text.Trim() != string.Empty) { lbtTen_Sp.Text = DataTool.SQLGetNameByCode("LISANPHAM", "Ma_Sp", "Ten_Sp", txtMa_Sp.Text.Trim()); dicName.Add(lbtTen_Sp.Name, lbtTen_Sp.Text); } else { lbtTen_Sp.Text = string.Empty; } }
public override bool Save() { Common.GatherMemvar(this, ref drEdit); //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } //Kiem tra Valid CSDL if (!DataTool.SQLUpdate(enuNew_Edit, "LIDOITUONG", ref drEdit)) { return(false); } Common.CopyDataRow(drEdit, drCurrent); //Doi ma if (this.enuNew_Edit == enuEdit.Edit && this.strCode != txtMa_Dt.Text) { DataTool.SQLChangeID("MA_DT", drCurrent); } return(true); }
public void FillData() { string strKey = string.Empty; if (this.isLookup) { strKey = (this.strLookupKeyFilter == null ? string.Empty : this.strLookupKeyFilter); } else { strKey = (strMa_Nh_Vt == string.Empty ? string.Empty : "Ma_Nh_Vt = '" + strMa_Nh_Vt + "'"); } dtVatTu = DataTool.SQLGetDataTable("LIVATTU", null, strKey, "Ma_Vt"); bdsVatTu.DataSource = dtVatTu; dgvVatTu.DataSource = bdsVatTu; bdsVatTu.Position = 0; //Uy quyen cho lop co so tim kiem bdsSearch = bdsVatTu; ExportControl = dgvVatTu; if (this.isLookup) { this.MoveToLookupValue(); } }
public static bool Save(int Ident00, string strFile_ID, string strFile_Name, string strMa_Nhom, string strCatalog, string strFile_Type, string strFile_Tag, object objFile_Content, DateTime dteNgay_Ky, string strNguoi_Ky, bool bDuyet) { string str; Hashtable htSQLPara = new Hashtable(); htSQLPara.Add("FILE_ID", strFile_ID); htSQLPara.Add("FILE_NAME", strFile_Name); htSQLPara.Add("MA_NHOM", strMa_Nhom); htSQLPara.Add("CATALOG", strCatalog); htSQLPara.Add("FILE_TYPE", strFile_Type); htSQLPara.Add("FILE_TAG", strFile_Tag); htSQLPara.Add("FILE_CONTENT", (objFile_Content == null) ? new byte[0] : ((byte[])objFile_Content)); htSQLPara.Add("NGAY_KY", dteNgay_Ky); htSQLPara.Add("NGUOI_KY", strNguoi_Ky); htSQLPara.Add("DUYET", bDuyet); if (DataTool.SQLCheckExist(strTableName, new string[] { "Ident00" }, new object[] { Ident00 })) { str = "UPDATE " + strTableName + " SET File_Content = @File_Content WHERE Ident00 = @Ident00"; } else { str = "INSERT INTO " + strTableName + " (File_Id, File_Name, Ma_Nhom, Catalog, File_Type, File_Tag, File_Content, Ngay_Ky, Nguoi_Ky, Duyet)" + " VALUES (@File_Id, @File_Name, @Ma_Nhom, @Catalog, @File_Type,@FILE_TAG, @File_Content, @Ngay_Ky, @Nguoi_Ky, @Duyet)"; } return(SQLExec.Execute(str, htSQLPara, CommandType.Text)); }
//Save Image public static bool SaveImage(int Ident00, string strFile_ID, string strFile_Name, string strMa_Nhom, string strCatalog, string strFile_Type, string strFile_Tag, PictureBox img, DateTime dteNgay_Ky, string strNguoi_Ky, bool bDuyet) { string str; Hashtable htSQLPara = new Hashtable(); htSQLPara.Add("IDENT00", Ident00); htSQLPara.Add("FILE_ID", strFile_ID); htSQLPara.Add("FILE_NAME", strFile_Name); htSQLPara.Add("MA_NHOM", strMa_Nhom); htSQLPara.Add("CATALOG", strCatalog); htSQLPara.Add("FILE_TYPE", strFile_Type); htSQLPara.Add("FILE_TAG", strFile_Tag); htSQLPara.Add("FILE_CONTENT", (img.Image != null) ? ((byte[])TypeDescriptor.GetConverter(img.Image).ConvertTo(img.Image, typeof(byte[]))) : new byte[] { }); htSQLPara.Add("NGAY_KY", dteNgay_Ky); htSQLPara.Add("NGUOI_KY", strNguoi_Ky); htSQLPara.Add("DUYET", bDuyet); if (DataTool.SQLCheckExist(strTableName, new string[] { "Ident00" }, new object[] { Ident00 })) { str = "UPDATE " + strTableName + " SET File_Content = @File_Content WHERE File_Id = @File_Id"; } else { str = "INSERT INTO " + strTableName + " (File_Id, File_Name, Ma_Nhom, Catalog, File_Type, File_Tag, File_Content, Ngay_Ky, Nguoi_Ky, Duyet)" + " VALUES (@File_Id, @File_Name, @Ma_Nhom, @Catalog, @File_Type, @File_Tag, @File_Content, @Ngay_Ky, @Nguoi_Ky, @Duyet)"; } return(SQLExec.Execute(str, htSQLPara, CommandType.Text)); }
private bool Save() { Common.GatherMemvar(this, ref drEdit); if (drEdit.Table.Columns.Contains("Ten_Vt")) { drEdit["Ten_Vt"] = lbtTen_Vt.Text; } if (drEdit.Table.Columns.Contains("Ten_Dt")) { drEdit["Ten_Dt"] = lbtTen_Dt.Text; } //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } //Luu xuong CSDL if (!DataTool.SQLUpdate(enuNew_Edit, "APGIAMUA", ref drEdit)) { return(false); } return(true); }
public void OnLoad() { //初始化文件夹 DataTool.initFolder(); //初始化配置数据 mainData = DataTool.initConfigData(); //新建UI对象 container = new Container(); //创建委托对象 TabControlEventHandler tabSelectedEvent = null; tabSelectedEvent = delegate(object obj, TabControlEventArgs e) { if (e.TabPage == page) { //初始化UI Init(); //移除委托监听 FiddlerApplication.UI.tabsViews.Selected -= tabSelectedEvent; FiddlerApplication.Log.LogString("FiddlerExample初始化完成!"); } }; //添加委托监听 FiddlerApplication.UI.tabsViews.Selected += tabSelectedEvent; //监听请求响应之前 FiddlerApplication.BeforeRequest += delegate(Session session) { FiddlerTool.handleRequest(session); }; }
//记录其他服务器信息 public void RegisterServer(int connect_id, int server_id, int server_type, List <int> scene_id_list) { ServerInfo server_info = new ServerInfo(); server_info.ConnectId = connect_id; server_info.ServerId = server_id; server_info.ServerType = server_type; server_info.SceneIdList = scene_id_list; this.server_id_to_server_info[server_id] = server_info; this.connect_id_to_server_info[connect_id] = server_info; if (!this.server_type_to_server_list.ContainsKey(server_type)) { this.server_type_to_server_list[server_type] = new List <ServerInfo>(); } this.server_type_to_server_list[server_type].Add(server_info); foreach (int scene_id in scene_id_list) { if (!this.scene_id_to_server_list.ContainsKey(scene_id)) { this.scene_id_to_server_list[scene_id] = new List <ServerInfo>(); } this.scene_id_to_server_list[scene_id].Add(server_info); } Log.InfoFormat("RegisterServer Succ connect_id:{0} server_id:{1} server_type:{2} scene_id_list:{3}", connect_id, server_id, server_type, DataTool.SaveAsJSON <List <int> >(scene_id_list)); }
public override void Delete() { if (bdsTheoDoiXe.Position < 0) { return; } DataRow drCurrent = ((DataRowView)bdsTheoDoiXe.Current).Row; //Mau tin da Duyet thi khong cho xoa if ((Boolean)drCurrent["Duyet"] == true) { MessageBox.Show("Mẫu tin đã duyệt. Không được xóa !", "Thông báo", MessageBoxButtons.OK); return; } if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE"))) { return; } if (DataTool.SQLDelete(strTableName, drCurrent)) { //Cập nhật History htHistory["CODE"] = drCurrent[strCode]; htHistory["NAME"] = drCurrent[strName]; htHistory["UPDATE_TYPE"] = "D"; UpdateHistory(); bdsTheoDoiXe.RemoveAt(bdsTheoDoiXe.Position); dtTheoDoiXe.AcceptChanges(); } }
private void LoadDicName() { //Ten_Tk if (txtTk_CCDC.Text.Trim() != string.Empty) { lbtTen_Tk_CCDC.Text = DataTool.SQLGetNameByCode("LITAIKHOAN", "Tk", "Ten_Tk", txtTk_CCDC.Text.Trim()); dicName.Add(lbtTen_Tk_CCDC.Name, lbtTen_Tk_CCDC.Text); } else { lbtTen_Tk_CCDC.Text = string.Empty; } //Ma_Nh_Ts if (txtMa_Nh_Ts.Text.Trim() != string.Empty) { lbtTen_Nh_Ts.Text = DataTool.SQLGetNameByCode("ASTSNH", "Ma_Nh_Ts", "Ten_Nh_Ts", txtMa_Nh_Ts.Text.Trim()); dicName.Add(lbtTen_Nh_Ts.Name, lbtTen_Nh_Ts.Text); } else { lbtTen_Nh_Ts.Text = string.Empty; } //MA_CCDC if (txtMa_CCDC.Text.Trim() != string.Empty) { txtTen_CCDC.Text = DataTool.SQLGetNameByCode("ASCCDC", "MA_CCDC", "Ten_CCDC", txtMa_CCDC.Text.Trim()); dicName.Add(txtTen_CCDC.Name, txtTen_CCDC.Text); } else { txtTen_CCDC.Text = string.Empty; } }
public bool Save() { Common.GatherMemvar(this, ref drEdit); //Kiem tra Valid tren Form if (!FormCheckValid()) { return(false); } //Kiem tra xem co ton tai hop dong nao khong //if (enuNew_Edit == enuEdit.New && DataTool.SQLCheckExist("HRHOPDONGPL", new string[] { "Ma_CbNv", "Da_Cham_Dut", "Loai_Hd" }, // new object[] { drEdit["Ma_CbNv"].ToString(), false, drEdit["Loai_Hd"].ToString() })) //{ // string strTen_CbNv = DataTool.SQLGetNameByCode("LINHANVIEN", "Ma_CbNv", "Ten_CbNv", ""); // MessageBox.Show("Nhân viên " + strTen_CbNv + " có hợp đồng chưa kết thúc"); // return false; //} //Luu xuong CSDL if (!DataTool.SQLUpdate(enuNew_Edit, "HRHOPDONGPL", ref drEdit)) { return(false); } return(true); }
public BuildSqlContext( StringBuilder builder, DataTool dataTool, IList<IDataParameter> parameters, Func<QueryTable, string> resolveAlias) { _builder = builder; _dataTool = dataTool; _parameters = parameters; _resolveAlias = resolveAlias; }
internal override ParseResult Parse(DataTool dataTool) { IList<IDataParameter> parameters = new List<IDataParameter>(); var builder = new StringBuilder(); builder.Append("select "); WriteSelectedColumns(builder); builder.Append(" from "); var secondTable = false; var buildSqlContext = new BuildSqlContext(builder, dataTool, parameters, GetAlias); foreach (var table in _tables) { if (secondTable) builder.Append(", "); table.BuildSql(buildSqlContext); secondTable = true; } if (_whereClause.Active) { builder.Append(" where "); _whereClause.BuildSql(buildSqlContext); } if (_sortExpressions.Count > 0) { builder.Append(" order by "); var first = true; foreach (var sortExpression in _sortExpressions) { if (!first) builder.Append(", "); first = false; sortExpression.Field.BuildSql(buildSqlContext); } } return new ParseResult(builder.ToString(), parameters); }
internal abstract ParseResult Parse(DataTool dataTool);
public void Setup() { _dataToolMock = new Mock<DataTool>(); _dataToolMock.CallBase = true; _dataTool = _dataToolMock.Object; }