C# HQLAction.Invoke方法代码示例

 private void save_Click(object sender, RoutedEventArgs e)
 {
     if (ui_id.Text == null)
     {
         MessageBox.Show("无收费记录");
         return;
     }
     try
     {
         String sql = "update t_apply set f_actualfee=f_actualfee-(select f_fee from t_paydetail where id=" + ui_id.Text + ") where f_code='" + ui_code.Text + "'";
         HQLAction action = new HQLAction();
         action.HQL = sql;
         action.Type = "sql";
         action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
         action.Name = "abc";
         action.Invoke();
         String sql1 = "update t_paydetail set f_state='无效' where id=" + ui_id.Text;
         HQLAction action1 = new HQLAction();
         action1.HQL = sql1;
         action1.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
         action1.Name = "abc1";
         action1.Invoke();
         //GeneralObject go1=(from p in loader.Res where p.Name.Equals("reversalmx") select p).First() as GeneralObject;
         //go1.SetValue("id",null);
         SyncActionFactory save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as SyncActionFactory;
         save.Invoke();
         ((from p in loader.Res where p.Name.Equals("paydetails") select p).First() as GeneralObject).IsInit = true;
         //go1.IsInit = true;
         (reversalmxgrid.DataContext as GeneralObject).IsInit = true;
     }
     catch (Exception ex)
     {
         MessageBox.Show("请记录用户情况，联系管理员");
     }
 }

 private void save_Click(object sender, RoutedEventArgs e)
 {
     String sql="update t_handplan set f_username='"+ui_usernamechange.Text+"'"+
         ",lastinputdate='"+ui_lastinputdatechange.Text+"'"+
         ",lastinputgasnum='"+ui_lastinputgasnumchange.Text+"'"+
         ",f_inputtor='"+ui_inputtorchange.SelectedValue+"'"+
         ",f_phone='"+ui_phonechange.Text+"'"+
         ",f_address='"+ui_addresschange.Text+"'"+
         ",f_usertype='"+ui_usertypechange.Text+"'"+
         ",f_weizhi='"+ui_weizhichange.Text+"'"+
         ",f_gasproperties='" + CoboxGasPro.SelectedValue + "'" +
         ",f_gaspricetype='" + CoboxGas.SelectedValue + "'" +
         ",f_gasprice='"+ui_gaspricechange.Text+"'"+
         ",f_metertype='" + ui_metertypechange.SelectedValue + "'" +
         ",f_gasmetermanufacturers='"+ui_gasmetermanufacturerschange.Text+"'"+
         ",f_gasmeterstyle='"+ui_gasmeterstylechange.Text+"'"+
         ",f_meternumber='"+ui_meternumberchange.Text+"'"+
         ",f_aliasname='"+ui_aliasnamechange.Text+"' where f_state='未抄表' and f_userid='"+ui_userid.Text+"'";
     HQLAction action = new HQLAction();
     action.HQL = sql;
     action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
     action.Name = "abc";
     action.Invoke();
     //如果数据有误，页面提示
     //回调页面保存按钮功能
     SyncActionFactory save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as SyncActionFactory;
     save.Invoke();
     //updatehandplan.New();
 }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            //拿出datagrid所选数据
            GeneralObject go = OtherUserUnits.SelectedItem as GeneralObject;
            //拿出页面数据上下文
            GeneralObject updatehandplan = OtherUserUnit.DataContext as GeneralObject;
            //新建对象，往t_updatehandplan插入数据
            GeneralObject obj = new GeneralObject();
            try
            {
                obj.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                obj.EntityType = "t_updateotherfee";
                obj.SetPropertyValue("f_userid", ui_userid.Text, false);
                obj.SetPropertyValue("f_username", ui_username.Text, false);
                obj.SetPropertyValue("f_address", ui_address.Text, false);
                obj.SetPropertyValue("f_sellid", go.GetPropertyValue("id").ToString(), false);


                obj.SetPropertyValue("f_feetype", go.GetPropertyValue("f_feetype").ToString(), false);
                obj.SetPropertyValue("f_newfeetype", ui_f_feetype.Text, false);
                obj.SetPropertyValue("f_fee", decimal.Parse(go.GetPropertyValue("f_fee").ToString()), false);
                obj.SetPropertyValue("f_newfee", decimal.Parse(ui_f_fee.Text), false);
                obj.SetPropertyValue("f_payfeevalid", go.GetPropertyValue("f_payfeevalid").ToString(), false);
                obj.SetPropertyValue("f_newpayfeevalid", ui_payfeevalid.SelectedValue, false);

                obj.SetPropertyValue("f_sellinggasoperator", ui_handplanoperator.Text, false);
                obj.SetPropertyValue("f_sellinggasdate", ui_handplandate.SelectedDate, false);
                obj.SetPropertyValue("f_updatenote", ui_updatenote.Text, false);
                obj.Name = "t_updateotherfee";
                //obj.Completed += obj_Completed;
                obj.Save();
            }
            catch (Exception a)
            {
                MessageBox.Show(a.Message);
            }
            //MessageBox.Show(go.GetPropertyValue("id").ToString());
           //  MessageBox.Show(ui_handplandate.SelectedDate.ToString());
            //oughtfee shifoujiaofei f_operator f_inputtor f_zhinajindate
            string sql = "update t_otherfee set f_feetype= '" + ui_f_feetype.Text +
              "',f_fee=" + decimal.Parse(ui_f_fee.Text) + ",f_payfeevalid='" + ui_payfeevalid.SelectedValue +
                 "' where id = " + go.GetPropertyValue("id");
           HQLAction action = new HQLAction();
           action.HQL = sql;
            action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
            action.Name = "abc";
           action.Invoke();
            
            //如果数据有误，页面提示
            //回调页面保存按钮功能
            BatchExcuteAction save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as BatchExcuteAction;
            save.State = State.End;
            PagedObjectList save1 = (from p in loader.Res where p.Name.Equals("personlist") select p).First() as PagedObjectList;
            save1.IsOld = true;
            updatehandplan.New();
            
        }

 private void onlySave_Click(object sender, RoutedEventArgs e)
 {
     ui_meterBusy.IsBusy = true;
     string sql = "update t_changmeter set f_cancelnote='" + ui_f_cancelnote.Text + "',f_canceldate='" + ui_f_canceldate.SelectedDate + "',f_cxoperation='"+ ui_f_cxoperation.Text +"',f_payfeevalid='无效' where id=" + ui_id.Text;
     HQLAction action = new HQLAction();
     action.HQL = sql;
     action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
     action.Name = "t_changmeter";
     action.Completed += action_Completed;
     action.Invoke();
 }

 private void save_Click(object sender, RoutedEventArgs e)
 {
     ui_userBusy1.IsBusy = true;
     string sql = "update t_otherfee set f_conclenote='" + ui_f_conclenote.Text + "',f_payfeevalid='无效' where id=" + ui_id.Text;
     HQLAction action = new HQLAction();
     action.HQL = sql;
     action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
     action.Name = "t_otherfee";
     action.Completed += action_Completed;
     action.Invoke();
 }

 private void action_Completed(object sender, System.ComponentModel.AsyncCompletedEventArgs e)
 {
     string sql = "update t_userfiles set f_initcardsellgas = null,f_gasmeterstyle='"
     + f_newgasmeterstyle.Text + "',f_gasmetermanufacturers='" + f_newgasmetermanufacturers.Text +
     "',f_metertype='" + f_qbnumber.Text + "',f_gaswatchbrand='" + CoboxPinpai.Text +
     "' where id=" + ui_id.Text;
     HQLAction action1 = new HQLAction();
     action1.HQL = sql;
     action1.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
     action1.Name = "t_changmeter";
     action1.Completed += action_Completed1;
     action1.Invoke();
 }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            ui_searchBusy.IsBusy = true;
            search.Search();

            string sql = "update t_repairsys set f_downloadstatus=NULL,f_accepter='" + f_accepter.SelectedValue + "' where " + search.Condition + "";
            HQLAction action = new HQLAction();
            action.HQL = sql;
            action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
            action.Name = "t_repairsys";
            action.Completed += action_Completed;
            action.Invoke();

        }

        private void start_Click(object sender, RoutedEventArgs e)
        {
            String flagName = name.Text.ToString();
            String state = value.Text.ToString();

            if (flagName == "短信功能开关")
            {
                //执行sql开关 状态 改为 开启 短信表里所有待发改为 未发
                String sql = "update t_smstemplate set f_state='开启' where f_name='短信功能开关'";
                HQLAction action = new HQLAction();
                action.Name = "abc";
                action.HQL = sql;
                action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                action.Invoke();

                sql = "update t_sms set f_state = '未发' where f_state = '待发'";
                action.HQL = sql;
                action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                action.Invoke();
            }
            else
            {
                //开关状态改为开启， 短信表里 此类 待发短信 状态改为 未发
                String sql = "update t_smstemplate set f_state='开启' where f_name='" + flagName + "'";
                HQLAction action = new HQLAction();
                action.Name = "abc";
                action.HQL = sql;
                action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                action.Invoke();

                sql = "update t_sms set f_state = '未发' where f_state = '待发' and f_templatename='"+ flagName +"'";
                action.HQL = sql;
                action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                action.Invoke();
            }
            value.Text = "开启";
        }

        private void allSend_Click(object sender, RoutedEventArgs e)
        {
            BaseObjectList list = daninfos.ItemsSource as BaseObjectList;

            //对于每一条记录
            foreach (GeneralObject go in list)
            {
                // id
                String smsId = go.GetPropertyValue("id").ToString();

                String sql = "update t_sms set f_state='未发' where id="+ smsId +"";
                HQLAction action = new HQLAction();
                action.Name = "abc";
                action.HQL = sql;
                action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                action.Invoke();
            }
        }

 private void save2_Click(object sender, RoutedEventArgs e)
 {
     ObjectList ol = dataGrid1.ItemsSource as ObjectList;
     foreach (GeneralObject item in ol)
     {
         if (item.IsChecked)
         {
             string f_zhinajin = item.GetPropertyValue("f_zhinajin").ToString();
             string id =  item.GetPropertyValue("id").ToString();
             HQLAction hql = new HQLAction();
             hql.Name = "hql";
             hql.WebClientInfo = ol.WebClientInfo;
             hql.HQL = "update t_handplan set f_jmzhinajin=" + f_zhinajin +" where id="+id;
             hql.Invoke();
         }
     }
     BatchExcuteAction SaveAction = FrameworkElementExtension.FindResource(this.save2, "SaveAction") as BatchExcuteAction;
     SaveAction.Invoke();
 }

        private void save_Click(object sender, RoutedEventArgs e)
        {
            ui_userfileschange.IsBusy = true;

            String sql="update t_handplan set f_username='"+ui_usernamechange.Text+"'"+
                ",lastinputdate='"+ui_lastinputdatechange.Text+"'"+
                ",lastinputgasnum='"+ui_lastinputgasnumchange.Text+"'"+
                ",f_inputtor='"+ui_inputtorchange.SelectedValue+"'"+
                ",f_phone='"+ui_phonechange.Text+"'"+
                ",f_address='"+ui_addresschange.Text+"'"+
                ",f_usertype='"+ui_usertypechange.Text+"'"+
                ",f_weizhi='"+ui_weizhichange.Text+"'"+
                ",f_gasproperties='" + CoboxGasPro.SelectedValue + "'" +
                ",f_gaspricetype='" + CoboxGas.SelectedValue + "'" +
                ",f_gasprice='"+ui_gaspricechange.Text+"'"+
                ",f_metertype='" + ui_metertypechange.SelectedValue + "'" +
                ",f_gasmetermanufacturers='"+ui_gasmetermanufacturerschange.Text+"'"+
                ",f_gasmeterstyle='"+ui_gasmeterstylechange.Text+"'"+
                ",f_meternumber='"+ui_meternumberchange.Text+"'"+
                 ",f_stairtype='" + CoboxStair.SelectedValue.ToString() + "'" +
                ",f_aliasname='"+ui_aliasnamechange.Text+"' where f_state='未抄表' and f_userid='"+ui_userid.Text+"'";
            HQLAction action = new HQLAction();
            action.HQL = sql;
            action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
            action.Name = "abc";
            action.Invoke();

            GeneralObject obj = userfileschange.DataContext as GeneralObject;
            userid = obj.GetPropertyValue("f_userid")+"";
            if ((obj.GetPropertyValue("f_meternumber") + "").Equals(obj.GetPropertyValue("f_meternumberchange") + "") && (obj.GetPropertyValue("terminal_name") + "").Equals(obj.GetPropertyValue("terminal_namechange") + "") && (obj.GetPropertyValue("meter_phone") + "").Equals(obj.GetPropertyValue("meter_phonechange") + ""))
                ui_refreshCachechange.Text = "0";
            else
            //{
                //if ("物联网表".Equals(ui_gasmeterstylechange.Text))
                    ui_refreshCachechange.Text = "1";
                //else
                    //ui_refreshCachechange.Text = "0";
            //}
            BatchExcuteAction save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as BatchExcuteAction;
            save.Completed += save_Completed;
            save.Invoke();
        }

 private void Button_Click(object sender, RoutedEventArgs e)
 {
     try {
         GeneralObject go = daninfos.SelectedItem as GeneralObject;
         if (go != null)
         {
             f_userid = go.GetPropertyValue("f_userid") + "";
             string sql = "update t_userfiles set f_operate_zl='欠费', f_returnvalueoperate=" + "'1' " +
                          " where f_gasmeterstyle in ('物联网表','物联表','积成远传气表','远传表','短信表') and f_userid='" + f_userid + "'";
             HQLAction action = new HQLAction();
             action.HQL = sql;
             action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
             action.Name = "t_userfiles";
             action.Completed += action_Completed;
             action.Invoke();
         }
     }
     catch(Exception ex){
     }
 }

 private void Button_Click(object sender, RoutedEventArgs e)
 {
     ui_searchBusy.IsBusy = true;
     search.Search();
     if (!"1=1".Equals(search.Condition.Trim()) && null != search.Condition)
     {
         //提交更改
         string sql = "update t_userfiles set f_operate_zl='" + f_operate_zl_zl.SelectedValue + "', f_returnvalueoperate=" + "'1' " +
                          " where f_gasmeterstyle in ('物联网表','物联表','积成远传气表','远传表','短信表') and " + search.Condition + "";
         HQLAction action = new HQLAction();
         action.HQL = sql;
         action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
         action.Name = "t_userfiles";
         action.Completed += action_Completed;
         action.Invoke();
     }
     else {
         MessageBox.Show("请先按照条件筛选出进行阀门操作的用户，再确认执行！");
         ui_searchBusy.IsBusy = false;
     }
 }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            //拿出datagrid所选数据
            GeneralObject go = handUserUnits.SelectedItem as GeneralObject;
            //拿出页面数据上下文
            GeneralObject updatehandplan = handUserUnit.DataContext as GeneralObject;
            //新建对象，往t_updatehandplan插入数据
            GeneralObject obj = new GeneralObject();
            try
            {
                obj.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
                obj.EntityType = "t_updatehandplan";
                obj.SetPropertyValue("f_userid", ui_userid.Text, false);
                obj.SetPropertyValue("f_username", ui_username.Text, false);
                obj.SetPropertyValue("f_address", ui_address.Text, false);
                obj.SetPropertyValue("oughtfee", decimal.Parse(go.GetPropertyValue("oughtfee").ToString()), false);
                obj.SetPropertyValue("newoughtfee", decimal.Parse(ui_oughtfee.Text), false);
                if (go.GetPropertyValue("lastinputgasnum") != null)
                {
                    obj.SetPropertyValue("lastinputgasnum", decimal.Parse(go.GetPropertyValue("lastinputgasnum").ToString()), false);
                }
                //修改后上期指数
                if (updatehandplan.GetPropertyValue("lastinputgasnum") != null)
                {
                    obj.SetPropertyValue("newlastinputgasnum", decimal.Parse(updatehandplan.GetPropertyValue("lastinputgasnum").ToString()), false);
                }

                obj.SetPropertyValue("lastrecord", decimal.Parse(go.GetPropertyValue("lastrecord").ToString()), false);
                obj.SetPropertyValue("newlastrecord", decimal.Parse(ui_lastrecord.Text), false);
                obj.SetPropertyValue("shifoujiaofei", go.GetPropertyValue("shifoujiaofei").ToString(), false);
                obj.SetPropertyValue("f_newzhinajindate", ui_zhinajindate.SelectedDate.Value, false);
                //obj.SetPropertyValue("f_zhinajindate", go.GetPropertyValue("f_zhinajindate").ToString(), false);
                obj.SetPropertyValue("newshifoujiaofei", ui_shifoujiaofei.Text, false);
                obj.SetPropertyValue("f_updatenote", ui_updatenote.Text, false);
                obj.SetPropertyValue("lastinputdate", go.GetPropertyValue("lastinputdate"), false);
                obj.SetPropertyValue("newlastinputdate", ui_lastinputdate.SelectedDate, false);
                if (go.GetPropertyValue("f_inputtor") == null)
                {
                    go.SetPropertyValue("f_inputtor", "无", false);
                }
                obj.SetPropertyValue("f_inputtor", go.GetPropertyValue("f_inputtor").ToString(), false);
                obj.SetPropertyValue("f_newinputtor", ui_inputtor.Text, false);
                obj.SetPropertyValue("oughtamount", decimal.Parse(go.GetPropertyValue("oughtamount").ToString()), false);
                obj.SetPropertyValue("newoughtamount", decimal.Parse(ui_oughtamount.Text), false);
                obj.SetPropertyValue("f_handplanoperator", ui_handplanoperator.Text, false);
                obj.SetPropertyValue("f_handplandate", ui_handplandate.SelectedDate, false);
                obj.Name = "t_updatehandplan";
                //obj.Completed += obj_Completed;
                obj.Save();
            }
            catch (Exception a)
            {
                MessageBox.Show(a.Message);
            }

            //oughtfee shifoujiaofei f_operator f_inputtor f_zhinajindate
            //拼接更新sql
            
            string sql = "update t_handplan set lastrecord= " + decimal.Parse(ui_lastrecord.Text) +
                ",oughtfee=" + decimal.Parse(ui_oughtfee.Text) +
                ",shifoujiaofei='" + ui_shifoujiaofei.Text +
                "',f_operator='" + ui_operator.Text +
                "',f_inputtor='" + ui_inputtor.Text +
                "',f_zhinajindate='" + ui_zhinajindate.SelectedDate.ToString().Substring(0, 10) +
                "',f_meterstate='" + meterstate.SelectedValue.ToString() +
                "',oughtamount=" + decimal.Parse(ui_oughtamount.Text);
            if (updatehandplan.GetPropertyValue("lastinputgasnum") != null)
            {
                sql += ",lastinputgasnum=" + updatehandplan.GetPropertyValue("lastinputgasnum").ToString();
            }
            sql += "  where id = " + go.GetPropertyValue("id");
            HQLAction action = new HQLAction();
            action.HQL = sql;
            action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
            action.Name = "abc";
            action.Invoke();
            //如果数据有误，页面提示
            //回调页面保存按钮功能
            //BatchExcuteAction save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as BatchExcuteAction;
            // save.Invoke();
            PagedObjectList save1 = (from p in loader.Res where p.Name.Equals("personlist") select p).First() as PagedObjectList;
            save1.IsOld = true;
            updatehandplan.New();
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            if (ui_SearchUserList.Count < 1 || CoboxStair.SelectedValue == null || "".Equals(CoboxStair.SelectedValue))
            {
                MessageBox.Show("请选择要修改用户和阶梯气价");
                return;
            }
            ui_searchBusy.IsBusy = true;
            search.Search();

            string sql = "update t_userfiles set f_stairtype='" + CoboxStair.SelectedValue + "', f_stair1amount=" + ui_stair1amount.Text + " , " +
                        "f_stair1price=" + ui_stair1price.Text + " , f_stair2amount='" + ui_stair2amount.Text + "', f_stair2price=" + ui_stair2price.Text + ",f_stair3amount='" + ui_stair3amount.Text + "', f_stair3price=" + ui_stair3price.Text + ", f_stair4price=" + ui_stair4price.Text + " ,f_stairmonths=" + ui_stairmonths.Text + " where " + search.Condition + "";
            HQLAction action = new HQLAction();
            action.HQL = sql;
            action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo;
            action.Name = "t_userfiles";
            action.Completed += action_Completed;
            action.Invoke();
        }