C# Behaviors.HQLAction类代码示例

 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 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 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 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 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 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();

        }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E6%8A%84%E8%A1%A8%E4%BB%BB%E5%8A%A1%E6%89%93%E5%8D%B0.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.DeleteAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("DeleteAction")));
     this.SubmitAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("SubmitAction")));
     this.applysearch = ((System.Windows.Controls.DockPanel)(this.FindName("applysearch")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.applys = ((System.Windows.Controls.DataGrid)(this.FindName("applys")));
     this.applyslist = ((Com.Aote.ObjectTools.ObjectList)(this.FindName("applyslist")));
     this.print = ((Com.Aote.Controls.PrintObj)(this.FindName("print")));
 }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E6%97%A5%E6%9C%9F%E6%97%B6%E9%97%B4.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.DeleteAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("DeleteAction")));
     this.personsearch = ((System.Windows.Controls.StackPanel)(this.FindName("personsearch")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.persons = ((System.Windows.Controls.DataGrid)(this.FindName("persons")));
     this.personslist = ((Com.Aote.ObjectTools.ObjectList)(this.FindName("personslist")));
     this.person = ((System.Windows.Controls.DockPanel)(this.FindName("person")));
     this.persongo = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("persongo")));
     this.save = ((System.Windows.Controls.Button)(this.FindName("save")));
     this.deletettip = ((Com.Aote.Controls.MessageTipObj)(this.FindName("deletettip")));
 }

        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();
            }
        }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E6%A1%A3%E6%A1%88%E4%BF%AE%E6%94%B9%E5%AD%97%E6%AE%B5.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.DeleteAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("DeleteAction")));
     this.SubmitAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("SubmitAction")));
     this.userfilesearch = ((System.Windows.Controls.DockPanel)(this.FindName("userfilesearch")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.userfiles = ((System.Windows.Controls.DataGrid)(this.FindName("userfiles")));
     this.userfileslist = ((Com.Aote.ObjectTools.ObjectList)(this.FindName("userfileslist")));
     this.save = ((System.Windows.Controls.Button)(this.FindName("save")));
     this.userfile = ((System.Windows.Controls.Grid)(this.FindName("userfile")));
     this.userfilego = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("userfilego")));
 }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E5%AE%89%E6%A3%80%E8%AE%A1%E5%88%92%E7%94%9F%E6%88%90.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.ybuserfilego = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("ybuserfilego")));
     this.userfileslist = ((Com.Aote.ObjectTools.PagedObjectList)(this.FindName("userfileslist")));
     this.MakeCheck = ((Com.Aote.Behaviors.HQLAction)(this.FindName("MakeCheck")));
     this.SaveAction = ((Com.Aote.Behaviors.BatchExcuteAction)(this.FindName("SaveAction")));
     this.userfilesearch = ((System.Windows.Controls.DockPanel)(this.FindName("userfilesearch")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.userfiles = ((System.Windows.Controls.DataGrid)(this.FindName("userfiles")));
     this.ybuserfile = ((System.Windows.Controls.Grid)(this.FindName("ybuserfile")));
     this.save = ((System.Windows.Controls.Button)(this.FindName("save")));
     this.pager = ((System.Windows.Controls.DataPager)(this.FindName("pager")));
 }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E7%BB%B4%E7%AE%A1%E8%B4%B9%E4%BB%B7%E6%A0%BC%E7%BB%B4%E6%8A%A4.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.scbdw = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("scbdw")));
     this.SaveAction = ((Com.Aote.Behaviors.BatchExcuteAction)(this.FindName("SaveAction")));
     this.deleteaction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("deleteaction")));
     this.searchHandUserUnit = ((System.Windows.Controls.StackPanel)(this.FindName("searchHandUserUnit")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.handUserUnits = ((System.Windows.Controls.DataGrid)(this.FindName("handUserUnits")));
     this.personlist = ((Com.Aote.ObjectTools.PagedObjectList)(this.FindName("personlist")));
     this.pager = ((System.Windows.Controls.DataPager)(this.FindName("pager")));
     this.handUserUnit = ((System.Windows.Controls.Grid)(this.FindName("handUserUnit")));
     this.deletettip = ((Com.Aote.Controls.MessageTipObj)(this.FindName("deletettip")));
 }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E6%A0%A1%E8%A1%A8.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.rect = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("rect")));
     this.SaveAction = ((Com.Aote.Behaviors.BatchExcuteAction)(this.FindName("SaveAction")));
     this.DeleteAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("DeleteAction")));
     this.pager = ((System.Windows.Controls.DataPager)(this.FindName("pager")));
     this.rectifysearch = ((System.Windows.Controls.Grid)(this.FindName("rectifysearch")));
     this.searchbutton = ((System.Windows.Controls.Button)(this.FindName("searchbutton")));
     this.rectifies = ((System.Windows.Controls.DataGrid)(this.FindName("rectifies")));
     this.rectifieslist = ((Com.Aote.ObjectTools.PagedObjectList)(this.FindName("rectifieslist")));
     this.rectifyinfo = ((System.Windows.Controls.DockPanel)(this.FindName("rectifyinfo")));
     this.rectifyItem = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("rectifyItem")));
 }

 public void InitializeComponent() {
     if (_contentLoaded) {
         return;
     }
     _contentLoaded = true;
     System.Windows.Application.LoadComponent(this, new System.Uri("/%E5%A5%A5%E6%9E%AB%E7%87%83%E6%B0%94%E8%90%A5%E6%94%B6%E7%B3%BB%E7%BB%9FV3;compo" +
                 "nent/Pages/%E7%A8%BD%E6%9F%A5%E6%9C%AA%E4%BD%8F%E7%BD%AE%E7%A9%BA.xaml", System.UriKind.Relative));
     this.LayoutRoot = ((System.Windows.Controls.Grid)(this.FindName("LayoutRoot")));
     this.fgslist = ((Com.Aote.ObjectTools.ObjectList)(this.FindName("fgslist")));
     this.zonggongsi = ((Com.Aote.ObjectTools.GeneralObject)(this.FindName("zonggongsi")));
     this.jicha = ((Com.Aote.ObjectTools.ObjectList)(this.FindName("jicha")));
     this.jichalist = ((Com.Aote.ObjectTools.PagedObjectList)(this.FindName("jichalist")));
     this.UpdateAction = ((Com.Aote.Behaviors.HQLAction)(this.FindName("UpdateAction")));
     this.daninfosearch = ((System.Windows.Controls.Grid)(this.FindName("daninfosearch")));
     this.dansearchbutton = ((System.Windows.Controls.Button)(this.FindName("dansearchbutton")));
     this.jichatj = ((System.Windows.Controls.DataGrid)(this.FindName("jichatj")));
     this.pager2 = ((System.Windows.Controls.DataPager)(this.FindName("pager2")));
     this.daninfos = ((System.Windows.Controls.DataGrid)(this.FindName("daninfos")));
 }