C# QueryDataRes.ExecuteNonQuery方法代码示例

 /// <summary>
 /// 定时执行业务
 /// </summary>
 /// <param name="obj"></param>
 void executeTimer(object obj)
 {
     DateTime dt = DateTime.Today.AddDays(-1);
     NameObjectList ps = new NameObjectList();
     ps.Add("开始日期", dt);
     ps.Add("结束日期", dt);
     QueryDataRes query = new QueryDataRes("基础类");
     DataTable tab = query.getTable("考勤人员列表", null);
     if (null == tab || tab.Rows.Count < 1)
     {
         isTmRunning = false;
         return;
     }
     NameValueCollection data = new NameValueCollection();
     data["服务"] = "考勤作业";
     DataColumnCollection cols = tab.Columns;
     foreach (DataRow dr in tab.Rows)
     {
         foreach (DataColumn c in cols)
             ps[c.ColumnName] = Convert.ToString(dr[c]);
         try
         {
             bool b = query.ExecuteNonQuery("考勤人员列表", ps, ps, ps);
             if (b) continue;
         }
         catch (Exception ex)
         {
             foreach (string key in ps.AllKeys)
                 data.Add(key, Convert.ToString(ps[key]));
             LogMessage(ex, data, EventLogEntryType.Error);
             continue;
         }
         foreach (string key in ps.AllKeys)
             data.Add(key, Convert.ToString(ps[key]));
         LogMessage("考勤作业失败！", data, EventLogEntryType.Warning);
     }
     isTmRunning = false;
 }

 /// <summary>
 /// 更新数据
 /// </summary>
 /// <param name="query">数据查询</param>
 /// <param name="tab">数据表,更新的数据项是数据表名称</param>
 /// <param name="ps">环境参数</param>
 /// <returns>是否执行成功</returns>
 public static bool Save(QueryDataRes query, DataTable tab, NameObjectList ps)
 {
     if (null == query || null == tab || tab.Rows.Count < 1)
         return true;
     NameObjectList[] psins = ParamManager.createParam(tab, DataRowState.Added);
     NameObjectList[] psupt = ParamManager.createParam(tab, DataRowState.Modified);
     NameObjectList[] psdel = ParamManager.createParam(tab, DataRowState.Deleted);
     foreach (NameObjectList p in psins)
         ParamManager.MergeParam(p, ps, false);
     foreach (NameObjectList p in psupt)
         ParamManager.MergeParam(p, ps, false);
     foreach (NameObjectList p in psdel)
         ParamManager.MergeParam(p, ps, false);
     if (psins.Length < 1 && psupt.Length < 1 && psdel.Length < 1)
         return true;
     bool isSuccess = query.ExecuteNonQuery(tab.TableName, psins, psupt, psdel);
     if (isSuccess)
         tab.AcceptChanges();
     return isSuccess;
 }

        /// <summary>
        /// 对同一个target循环执行数据记录关联的指令,执行成功后执行sql更新
        /// </summary>
        /// <param name="drs">指令数据数组</param>
        /// <param name="colmap">字段与指令的映射</param>
        /// <param name="tpl">指令协议类别：停车场/消费/门禁/考勤/卡务中心</param>
        /// <param name="cmd">指令命令名称</param>
        /// <param name="target">通讯目标位置</param>
        /// <param name="deviceID">设备下位机地址</param>
        /// <param name="query">数据更新执行实例</param>
        /// <param name="dbItem">执行更新的数据项</param>
        /// <returns>成功执行返回空,失败返回错误原因</returns>
        public static string ExecuteDataRows(DataRow[] drs, string[,] colmap, string tpl, string cmd, CommiTarget target, string deviceID, QueryDataRes query, string dbItem)
        {
            if (null == drs || drs.Length < 1 || null == colmap || colmap.GetLength(1) < 2 || string.IsNullOrEmpty(tpl) || string.IsNullOrEmpty(cmd))
                return "";
            if (null == target || string.IsNullOrEmpty(deviceID))
                return "";
            //声明一个集合来储存数据
            List<DataRow> drList = new List<DataRow>();
            string msg = "";

            //执行指令
            CmdProtocol cmdP = new CmdProtocol(deviceID, false);
            //循环得到传过来的数据
            foreach (DataRow dr in drs)
            {
                if (null == dr) continue;
                string tagdata = "@设备地址=" + deviceID;
                for (int c = 0; c < colmap.GetLength(0); c++)
                {
                    object val = dr[colmap[c, 1]];
                    if (true.Equals(val)) val = "1";
                    if (false.Equals(val)) val = "0";
                    tagdata = basefun.setvaltag(tagdata, colmap[c, 0], Convert.ToString(val));
                }
                //设置指令
                cmdP.setCommand(tpl, cmd, tagdata);
                cmdP.ResetState();
                //发送指令
                CommiManager.GlobalManager.SendCommand(target, cmdP);
                if (!cmdP.EventWh.WaitOne(2000, false))
                {
                    msg = basefun.setvaltag(tagdata, "{状态}", "通讯超时失败！");
                    break;
                }
                if (string.IsNullOrEmpty(cmdP.ResponseFormat))
                {
                    msg = basefun.setvaltag(tagdata, "{状态}", tagdata + "指令错误！");
                    break;
                }
                drList.Add(dr);
            }
            //更新数据库
            //判断数据源和存储过程是否为空
            if (null == query || string.IsNullOrEmpty(dbItem))
                return msg;
            //得到数据的数量
            Estar.Common.Tools.NameObjectList[] ps = new Estar.Common.Tools.NameObjectList[drList.Count];
            for (int i = 0; i < drList.Count; i++)
                ps[i] = ParamManager.createParam(drList[i]);
            //得到数据与配置的数据已经保持一致，但发现没有执行存储过程。。。
            //执行数据库操作（方法封装在query内）
            bool success = query.ExecuteNonQuery(dbItem, ps, ps, ps);
            
            if (!success)
                msg = basefun.setvaltag(msg, "{状态}", basefun.valtag(msg, "{状态}") + "更新数据库失败！");
            return msg;
        }

    protected void Page_Load(object sender, EventArgs e)
    {
        string strResult = "";
        if (null == this.Session["userid"])
        {
            strResult = leofun.setvaltag("", "成功", "false");
            strResult = leofun.setvaltag(strResult, "提示", "无效用户,请重新登录!");
            this.Response.Write(leofun.Escape(strResult));
            return;
        }
        //User userInfo = new User(this.Session["userid"].ToString());

        XmlDocument xmldoc = new XmlDocument();
        //读取用户参数
        StreamReader streamreader = new StreamReader(this.Request.InputStream, Encoding.UTF8);
        xmldoc.LoadXml(streamreader.ReadToEnd());
        NameObjectList paramlist = BuildParamList.BuildParams(xmldoc);

        string[] dataItems = BuildParamList.getValue(xmldoc, "workdataitems").Split(',');
        string datasrcFile = BuildParamList.getValue(xmldoc, "DataSrcFile");
        QueryDataRes query = new QueryDataRes(datasrcFile);
        //QueryDataRes query = new QueryDataRes(unitItem.DataSrcFile);
        try
        {
            query.BeginTransaction();
            for (int i = 0; i < dataItems.Length; i++)
            {
                //WorkItem workItem = this.unitItem.WorkItemList[i];
                //检测一
                //强行置入ip地址做为参数
                BuildParamList.setValue(xmldoc, "ip", HttpContext.Current.Request.UserHostAddress);

                //NameObjectList[] paramInsList = this.CreateParamLists("new", xmldoc, paramlist, workItem);
                NameObjectList[] paramInsList = this.CreateParamLists("new", xmldoc, paramlist, dataItems[i]);
                NameObjectList[] paramUptList = this.CreateParamLists("modify", xmldoc, paramlist, dataItems[i]);
                NameObjectList[] paramDelList = this.CreateParamLists("delete", xmldoc, paramlist, dataItems[i]);
                bool bSuccess = query.ExecuteNonQuery(dataItems[i], paramInsList, paramUptList, paramDelList);
                if (false == bSuccess)
                    throw (new Exception("保存项目失败：请检查配置和错误日志!"));
                if ("系统数据源" == Path.GetFileName(datasrcFile).ToLower() && "系统信息配置" == dataItems[i])
                {
                    this.ConfigSystem(paramInsList);
                    this.ConfigSystem(paramUptList);
                }
            }
            query.Commit();
            strResult = leofun.setvaltag("", "成功", "true");
            strResult = leofun.setvaltag(strResult, "提示", "保存成功!");
            this.Response.Write(leofun.Escape(strResult));
        }
        catch (Exception ex)
        {
            query.RollbackAndClose();
            strResult = leofun.setvaltag("", "成功", "false");
            strResult = leofun.setvaltag(strResult, "提示", ex.Message);
            this.Response.Write(leofun.Escape(strResult));
        }
        finally
        {
            query.Close();
        }
    }

        /// <summary>
        /// 初始化硬件设备
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void InitBtn_Click(object sender, EventArgs e)
        {
            int[] indexlist = this.getCheckedList();
            if (indexlist.Length < 1)
            {
                MessageBox.Show("请选择一个设备", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            if (DialogResult.Yes != MessageBox.Show("初始化设备会清空设备存储的数据，是否确认需要初始化！", "设备初始化", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
                return;
            string strdevIDs = "", msg = "", strdevNames = "";
            string tpl = "停车场", cmd = "格式化";
            DataTable tab = this.dbGrid.DataSource as DataTable;
            foreach (int i in indexlist)
            {
                DataRow dr = tab.Rows[i];
                CommiTarget target = this.getTarget(dr);
                CmdProtocol cmdP = new CmdProtocol(Convert.ToString(dr["名称"]), false);
                string devid = Convert.ToString(dr["站址"]);
                string tagdata = "@设备地址=" + devid;
                cmdP.setCommand(tpl, cmd, tagdata);
                CommiManager.GlobalManager.SendCommand(target, cmdP);

                if (!cmdP.EventWh.WaitOne(2000, false))
                    msg = cmdP.CmdId + "：通讯失败,请检查设备连接或通讯参数后重试！";
                string rpmsg = basefun.valtag(cmdP.ResponseFormat, "{状态}");
                if (string.IsNullOrEmpty(msg) && !string.IsNullOrEmpty(rpmsg) && "操作成功！" != rpmsg)
                    msg = cmdP.CmdId + "：" + rpmsg;
                if (!string.IsNullOrEmpty(msg))
                    break;
                strdevIDs += "," + devid;
                strdevNames += cmdP.CmdId + ",";
            }
            //形成参数
            string[] devids = strdevIDs.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
            NameObjectList[] psList = new NameObjectList[devids.Length];
            for (int i = 0; i < devids.Length; i++)
            {
                psList[i] = new NameObjectList();
                psList[i]["devID"] = devids[i];
            }
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            if (psList.Length > 0)
                query.ExecuteNonQuery("删除设备白名单", psList, psList, psList);

            if (string.IsNullOrEmpty(msg))
                MessageBox.Show("设备初始化成功！", "设备初始化", MessageBoxButtons.OK, MessageBoxIcon.Information);
            else
            {
                msg = string.IsNullOrEmpty(strdevNames) ? msg : strdevNames + "成功执行初始化，\r\n" + msg;
                MessageBox.Show(msg, "设备初始化", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

        /// <summary>
        /// 确定交班
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tbOK_Click(object sender, EventArgs e)
        {
            bool isNotExist = false;
            string user = Convert.ToString(this.ccbNextUser.Text);
            string pws = this.tbPassword.Text;
            if (string.IsNullOrEmpty(user) || string.IsNullOrEmpty(pws))
            {
                MessageBox.Show("请选择接班人和输入接班人密码！", "接班提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            this.paramwin["交班人"] = BindManager.getUser().UserAccounts;
            this.paramwin["密码"] = pws;

            User user1 = new User(user, ref isNotExist);
            if (!isNotExist)
                isNotExist = !user1.login(tbUserName.Text, pws);
            if (isNotExist)
            {
                MessageBox.Show("密码不正确！", "系统提示");
                return;
            }
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            this.paramwin["操作员"] = BindManager.getUser().UserName;
            this.paramwin["值班人"] = ccbNextUser.Text;
            IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
            string myip = IpEntry.AddressList[0].ToString();
            this.paramwin["电脑IP"] = myip;
            bool isSuccess = query.ExecuteNonQuery("交接班", this.paramwin, this.paramwin, this.paramwin);
            if (!isSuccess)
            {
                MessageBox.Show("执行交接班时失败请与管理员联系！", "接班提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            BindManager.setUser(user);
            string operName = this.ccbNextUser.Text.Trim();
            string workStartTime = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            string ip = this.paramwin.AllValues.GetValue(2).ToString();
            string tag = string.Empty;
            tag = basefun.setvaltag(tag, "值班人", operName);
            tag = basefun.setvaltag(tag, "接班时间", workStartTime);
            tag = basefun.setvaltag(tag, "电脑IP", ip);
            NameObjectList ps = ParamManager.createParam(tag);
            ParamManager.MergeParam(ps, this.paramwin, false);
            query.ExecuteNonQuery("当班状态", ps, ps, ps);
            MessageBox.Show("已经成功执行交接班！\r\n" + this.ccbNextUser.Text + " 开始工作！", "接班提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            this.DialogResult = DialogResult.Yes;
            this.Close();
        }

 /// <summary>
 /// ��������
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnReset_Click(object sender, EventArgs e)
 {
     if (this.dbUserView.RowCount < 1)
         return;
     DataRow dr = this.dbUserView.GetDataRow(this.dbUserView.FocusedRowHandle);
     NameObjectList ps = ParamManager.createParam(dr);
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     if (!query.ExecuteNonQuery("�û������ʼ��", ps, ps, ps))
         MessageBox.Show("��������ʧ�ܣ�", "��������", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     else
         MessageBox.Show("�ɹ���������Ϊ��abc123\r\n�뼰ʱ�޸�����ȷ����ȫ", "��������", MessageBoxButtons.OK, MessageBoxIcon.Information);
 }

 /// <summary>
 /// ��ʧ
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void simpleButton4_Click(object sender, EventArgs e)
 {
     getNewDataByCardNo(txtCardRealNo.Text);
     if (string.IsNullOrEmpty(txtCardRealNo.Text))
     {
         XtraMessageBox.Show("�������", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (dsUnit.Tables["selectCard"].Rows.Count < 1)
     {
         XtraMessageBox.Show("�˿�δ���У�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (status == "�˿�")
     {
         XtraMessageBox.Show("�˿���״̬Ϊ�˿������ܹ�ʧ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
     string myip = IpEntry.AddressList[0].ToString();
     NameObjectList ps = this.buildParam(this, null);
     ps["�豸"] = DevIdS;
     ps["LocalIP"] = myip;
     ps["Localhost"] = System.Net.Dns.GetHostName();
     ps["UserAccounts"] = BindManager.getUser().UserName;
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     NameObjectList psnull = new NameObjectList();
     if (query.ExecuteNonQuery("��ʧ", ps, ps, psnull))
         XtraMessageBox.Show("��ʧ�ɹ�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     else XtraMessageBox.Show("��ʧʧ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     //ˢ�¼�¼
     this.dsUnit.Tables["�û�ѡ��"].Clear();
     this.Query.FillDataSet("�û�ѡ��", new NameObjectList(), this.dsUnit);
     this.dsUnit.Tables["��־"].Clear();
     this.Query.FillDataSet("��־", new NameObjectList(), this.dsUnit);
 }

 /// <summary>
 /// �˿�
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnCardQuit_Click(object sender, EventArgs e)
 {
     getNewDataByCardNo(cardno);
     if (string.IsNullOrEmpty(cardno))
     {
         XtraMessageBox.Show("�������", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (dsUnit.Tables["selectCard"].Rows.Count < 1)
     {
         XtraMessageBox.Show("�˿�δ���У�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (status == "��ʧ")
     {
         XtraMessageBox.Show("�˿���״̬Ϊ��ʧ�������˿���", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     #region Ic����������˿�
     if (radic.Checked)
     {
         string CardStatus = "";
         //����
         if (Etime.Enabled)
         {
             CardStatus = cmdCard.ClearData(CardArea.Eatery);
             CardStatus = basefun.valtag(CardStatus, "{״̬}");
             if (CardStatus != "�����ɹ���")
             {
                 MessageBox.Show(CardStatus, "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 return;
             }
         }
         //ͣ����
         if (Ptime.Enabled)
         {
             CardStatus = cmdCard.ClearData(CardArea.Park);
             CardStatus = basefun.valtag(CardStatus, "{״̬}");
             if (CardStatus != "�����ɹ���")
             {
                 MessageBox.Show(CardStatus, "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 return;
             }
         }
         //������ʾ
         cmdCard.Buzz(true);
     }
     #endregion
     IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
     string myip = IpEntry.AddressList[0].ToString();
     NameObjectList ps = this.buildParam(this, null);
     if (this.radYou.Checked)
     {
         ps["�Ƿ��п�"] = 0;
     }
     else if (this.radWu.Checked)
     {
         ps["�Ƿ��п�"] = 1;
     }
     ps["UserAccounts"] = BindManager.getUser().UserName;
     ps["�豸"] = DevIdS;
     ps["LocalIP"] = myip;
     ps["Localhost"] = System.Net.Dns.GetHostName();
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     NameObjectList psnull = new NameObjectList();
     if (query.ExecuteNonQuery("�˿�", ps, ps, ps))
         XtraMessageBox.Show("�˿��ɹ�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     else XtraMessageBox.Show("�˿�ʧ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     //ˢ�¼�¼
     this.dsUnit.Tables["�û�ѡ��"].Clear();
     this.Query.FillDataSet("�û�ѡ��", new NameObjectList(), this.dsUnit);
     this.dsUnit.Tables["��־"].Clear();
     this.Query.FillDataSet("��־", new NameObjectList(), this.dsUnit);
 }

 /// <summary>
 /// ��ֵ����
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnCardPay_Click(object sender, EventArgs e)
 {
     getNewDataByCardNo(txtCardRealNo.Text);
     if (string.IsNullOrEmpty(txtCardRealNo.Text))
     {
         XtraMessageBox.Show("�������", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (dsUnit.Tables["selectCard"].Rows.Count < 1)
     {
         XtraMessageBox.Show("�˿�δ���У�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (status == "�˿�")
     {
         XtraMessageBox.Show("�˿���״̬Ϊ�˿������ܳ�ֵ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (status == "��ʧ")
     {
         XtraMessageBox.Show("�˿���״̬Ϊ��ʧ�����ܳ�ֵ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
         return;
     }
     if (radic.Checked)
     {
         if (WriteInfo("��ֵ") == false) return;
     }
     IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName());
     string myip = IpEntry.AddressList[0].ToString();
     NameObjectList ps = this.buildParam(this, null);
     if (this.radYou.Checked)
     {
         ps["�Ƿ��п�"] = 0;
     }
     else if (this.radWu.Checked)
     {
         ps["�Ƿ��п�"] = 1;
     }
     if (!this.Etime.Enabled) ps["����"] = ""; else ps["����"] = "����";
     if (!this.Dtime.Enabled) ps["�Ž�"] = ""; else ps["�Ž�"] = "�Ž�";
     if (!this.Ptime.Enabled) ps["ͣ����"] = ""; else ps["ͣ����"] = "ͣ����";
     if (dtime1 == DateTime.Now.ToString("yyyy-MM-dd")) dtime1 = this.txtdtime.Text;
     if (etime1 == DateTime.Now.ToString("yyyy-MM-dd")) etime1 = this.txtEtime.Text;
     if (ptime1 == DateTime.Now.ToString("yyyy-MM-dd")) ptime1 = this.txtptime.Text;
     if (string.IsNullOrEmpty(dtime1)) dtime1 = DateTime.Now.ToString("yyyy-MM-dd");
     if (string.IsNullOrEmpty(etime1)) etime1 = DateTime.Now.ToString("yyyy-MM-dd");
     if (string.IsNullOrEmpty(ptime1)) ptime1 = DateTime.Now.ToString("yyyy-MM-dd");
     ps["�Ž�����"] = dtime1;
     ps["��������"] = etime1;
     ps["ͣ��������"] = ptime1;
     ps["�ֽ��ֵ"] = txtXJmoney.Text;
     ps["������ֵ"] = txtBZmoney.Text;
     ps["�����ۼ�"] = IsaddBZMoney;
     ps["UserAccounts"] = BindManager.getUser().UserName;
     ps["�豸"] = DevIdS;
     ps["LocalIP"] = myip;
     ps["Localhost"] = System.Net.Dns.GetHostName();
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     NameObjectList psnull = new NameObjectList();
     if (query.ExecuteNonQuery("��ֵ", ps, ps, ps))
         XtraMessageBox.Show("��ֵ�ɹ�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     else XtraMessageBox.Show("��ֵʧ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     //ˢ�¼�¼
     this.dsUnit.Tables["�û�ѡ��"].Clear();
     this.Query.FillDataSet("�û�ѡ��", new NameObjectList(), this.dsUnit);
     this.dsUnit.Tables["��־"].Clear();
     this.Query.FillDataSet("��־", new NameObjectList(), this.dsUnit);
     getNewDataByCardNo(txtCardRealNo.Text);
 }