示例#1
0
        private void FillData()
        {
            dtDaoTaoKH = DataTool.SQLGetDataTable("HRDAOTAOKH", null, "", "Ma_Bp");

            bdsDaoTaoKH.DataSource = dtDaoTaoKH;
            dgvDaoTaoKH.DataSource = bdsDaoTaoKH;
        }
示例#2
0
        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);
            };
        }
示例#3
0
        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();
            }
        }
示例#4
0
        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();
            }
        }
示例#5
0
        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();
        }
示例#6
0
        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();
        }
示例#7
0
        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();
            }
        }
示例#8
0
        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);
            }
        }
示例#9
0
 /// <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);
     }
 }
示例#10
0
 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);
     }
 }
示例#11
0
        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);
        }
示例#12
0
        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);
        }
示例#13
0
        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);
                }
            }
        }
示例#14
0
        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();
            }
        }
示例#15
0
        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;
        }
示例#16
0
        private void FillData()
        {
            dtThueTn = DataTool.SQLGetDataTable("HRTHUETN", null, "", "Bang_Thue,Muc_Tn1,Muc_Tn2");

            bdsThueTn.DataSource = dtThueTn;
            dgvThueTn.DataSource = bdsThueTn;
        }
示例#17
0
        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;
            }
        }
示例#18
0
        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;
            }
        }
示例#19
0
        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);
                }
            }
        }
示例#20
0
        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;
            }
        }
示例#21
0
        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);
        }
示例#22
0
        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();
            }
        }
示例#23
0
        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));
        }
示例#24
0
        //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));
        }
示例#25
0
        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);
        }
示例#26
0
        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);
            };
        }
示例#27
0
    //记录其他服务器信息
    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));
    }
示例#28
0
        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();
            }
        }
示例#29
0
        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;
            }
        }
示例#30
0
        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);
 }
示例#33
0
 internal abstract ParseResult Parse(DataTool dataTool);
 public void Setup()
 {
     _dataToolMock = new Mock<DataTool>();
     _dataToolMock.CallBase = true;
     _dataTool = _dataToolMock.Object;
 }