private void save_Click(object sender, RoutedEventArgs e) { String sql="update t_handplan set f_username='******'"+ ",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 static void OnCanSaveChanged(DependencyObject dp, DependencyPropertyChangedEventArgs args) { HQLAction bea = (HQLAction)dp; if (bea.CanSave) { bea.Invoke(); } bea.CanSave = false; }
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='******'"+ ",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(); }
private void ui_SaveStairButton_Click(object sender, RoutedEventArgs e) { if (count == 1) { if (ui_stairtype.Text != "" || ui_stair1amount.Text != "" || ui_stair1price.Text != "" || ui_stair2amount.Text != "" || ui_stair2price.Text != "" || ui_stair3amount.Text != "" || ui_stair3price.Text != "" || ui_stairmonths.SelectedValue != null) { ui_searchBusy.IsBusy = true; // 通过执行sql语句进行设置 string sql = "update t_stairprice set f_stairtype='" + ui_stairtype.Text + "', 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.SelectedValue + " where id=" + ui_id.Text; HQLAction action = new HQLAction(); action.HQL = sql; action.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo; action.Name = "t_stairprice"; action.Completed += action_Completed; action.Invoke(); } else { MessageBox.Show("请输入完整信息!"); return; } } else { if (ui_stairtype.Text != "" || ui_stair1amount.Text != "" || ui_stair1price.Text != "" || ui_stair2amount.Text != "" || ui_stair2price.Text != "" || ui_stair3amount.Text != "" || ui_stair3price.Text != "" || ui_stairmonths.SelectedValue != null) { ui_searchBusy.IsBusy = true; GeneralObject obj = new GeneralObject(); obj.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo; obj.EntityType = "t_stairprice"; obj.SetPropertyValue("f_stairtype", ui_stairtype.Text, false); obj.SetPropertyValue("f_stair1amount", ui_stair1amount.Text, false); obj.SetPropertyValue("f_stair1price", ui_stair1price.Text, false); obj.SetPropertyValue("f_stair2amount", ui_stair2amount.Text, false); obj.SetPropertyValue("f_stair2price", ui_stair2price.Text, false); obj.SetPropertyValue("f_stair3amount", ui_stair3amount.Text, false); obj.SetPropertyValue("f_stair3price", ui_stair3price.Text, false); obj.SetPropertyValue("f_stair4price", ui_stair4price.Text, false); obj.SetPropertyValue("f_stairmonths", ui_stairmonths.SelectedValue, false); obj.Name = "t_stairprice"; obj.Completed += obj_Completed; obj.Save(); } else { MessageBox.Show("请输入完整信息!"); return; } } }
private void Button_Click(object sender, RoutedEventArgs e) { //拿出datagrid所选数据 GeneralObject go =SellUserUnits.SelectedItem as GeneralObject; //拿出页面数据上下文 GeneralObject updatehandplan = SellUserUnit.DataContext as GeneralObject; //新建对象,往t_updatehandplan插入数据 GeneralObject obj = new GeneralObject(); try { obj.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo; obj.EntityType = "t_updatesellinggas"; obj.SetPropertyValue("f_userid", go.GetPropertyValue("f_userid")+"", false); obj.SetPropertyValue("f_newuserid", ui_userid.Text, false); obj.SetPropertyValue("f_username", go.GetPropertyValue("f_username")+"", false); obj.SetPropertyValue("f_newusername", ui_username.Text, false); obj.SetPropertyValue("f_address", go.GetPropertyValue("f_address")+"", false); obj.SetPropertyValue("f_newaddress", ui_address.Text, false); obj.SetPropertyValue("f_districtname", go.GetPropertyValue("f_districtname")+"", false); obj.SetPropertyValue("f_newdistrictname", ui_f_districtname.Text, false); obj.SetPropertyValue("f_sellid",go.GetPropertyValue("id").ToString(), false); obj.SetPropertyValue("f_usertype", ui_usertype.Text, false); if (go.GetPropertyValue("f_zhinajin") == null) { go.SetPropertyValue("f_zhinajin", 0.0m, false); } obj.SetPropertyValue("f_zhinajin", decimal.Parse(go.GetPropertyValue("f_zhinajin").ToString()), false); if (ui_f_zhinajin.Text.ToString().Equals("")) { ui_f_zhinajin.Text = "0"; } obj.SetPropertyValue("f_newzhinajin", decimal.Parse(ui_f_zhinajin.Text), false); if (go.GetPropertyValue("f_amountmaintenance") == null) { go.SetPropertyValue("f_amountmaintenance", 0.0m, false); } obj.SetPropertyValue("f_weihufei", decimal.Parse(go.GetPropertyValue("f_amountmaintenance").ToString()), false); if (ui_f_amountmaintenance.Text.ToString().Equals("")) { ui_f_amountmaintenance.Text = "0"; } obj.SetPropertyValue("f_newweihufei", decimal.Parse(ui_f_amountmaintenance.Text), false); obj.SetPropertyValue("f_shifouyouxiao", go.GetPropertyValue("f_payfeevalid").ToString(), false); obj.SetPropertyValue("f_newshifouyouxiao", ui_f_payfeevalid.Text, false); obj.SetPropertyValue("f_pregas", decimal.Parse(go.GetPropertyValue("f_pregas").ToString()), false); obj.SetPropertyValue("f_newpregas", decimal.Parse(ui_f_pregas.Text), false); obj.SetPropertyValue("f_preamount", decimal.Parse(go.GetPropertyValue("f_preamount").ToString()), false); obj.SetPropertyValue("f_newpreamount", decimal.Parse(ui_f_preamount.Text), false); obj.SetPropertyValue("f_shoukuan", decimal.Parse(go.GetPropertyValue("f_grossproceeds").ToString()), false); obj.SetPropertyValue("f_newshoukuan", decimal.Parse(ui_f_grossproceeds.Text), false); if (go.GetPropertyValue("f_benqizhye") == null) { go.SetPropertyValue("f_benqizhye", 0.0m, false); } obj.SetPropertyValue("f_zhye", decimal.Parse(go.GetPropertyValue("f_benqizhye").ToString()), false); if (ui_f_benqizhye.Text.ToString().Equals("")) { ui_f_benqizhye.Text = "0"; } obj.SetPropertyValue("f_newzhye", decimal.Parse(ui_f_benqizhye.Text), false); if (go.GetPropertyValue("f_zhye") == null) { go.SetPropertyValue("f_zhye", 0.0m, false); } obj.SetPropertyValue("f_shangqizhye", decimal.Parse(go.GetPropertyValue("f_zhye").ToString()), false); if (ui_f_zhye.Text.ToString().Equals("")) { ui_f_zhye.Text = "0"; } obj.SetPropertyValue("f_newshangqizhye", decimal.Parse(ui_f_zhye.Text), false); if (go.GetPropertyValue("lastinputgasnum") == null) { go.SetPropertyValue("lastinputgasnum", 0.0m, false); } obj.SetPropertyValue("f_lastinputgasnums", decimal.Parse(go.GetPropertyValue("lastinputgasnum").ToString()), false); if (ui_f_zhye.Text.ToString().Equals("")) { ui_f_zhye.Text = "0"; } obj.SetPropertyValue("f_newlastinputgasnums", decimal.Parse(ui_f_lastinputgasnums.Text), false); if (go.GetPropertyValue("lastrecord") == null) { go.SetPropertyValue("lastrecord", 0.0m, false); } obj.SetPropertyValue("f_lastrecord", decimal.Parse(go.GetPropertyValue("lastrecord").ToString()), false); if (ui_f_lastrecord.Text.ToString().Equals("")) { ui_f_lastrecord.Text = "0"; } obj.SetPropertyValue("f_newlastrecord", decimal.Parse(ui_f_lastrecord.Text), 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_updatesellinggas"; //obj.Completed += obj_Completed; obj.Save(); } catch (Exception a) { MessageBox.Show(a.Message); } // BatchExcuteAction save = (from p in loader.Res where p.Name.Equals("SaveAction") select p).First() as BatchExcuteAction; // save.Invoke(); string sql = "update t_sellinggas set f_zhinajin= " + decimal.Parse(ui_f_zhinajin.Text) + ",f_amountmaintenance=" + decimal.Parse(ui_f_amountmaintenance.Text) + ",f_payfeevalid='" + ui_f_payfeevalid.Text + "',f_pregas=" + decimal.Parse(ui_f_pregas.Text) + ",f_preamount=" + decimal.Parse(ui_f_preamount.Text) + ",f_grossproceeds=" + decimal.Parse(ui_f_grossproceeds.Text) + ",f_benqizhye=" + decimal.Parse(ui_f_benqizhye.Text) + ",f_zhye=" + decimal.Parse(ui_f_zhye.Text)+ ",lastinputgasnum=" + decimal.Parse(ui_f_lastinputgasnums.Text) + ",lastrecord=" + decimal.Parse(ui_f_lastrecord.Text) + ",f_userid='" + ui_userid.Text + "',f_username='******',f_address='" + ui_address.Text + "',f_districtname='" + ui_f_districtname.Text + "' 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(); 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) { //拿出datagrid所选数据 GeneralObject go = FaKaUserUnits.SelectedItem as GeneralObject; //拿出页面数据上下文 GeneralObject updatehandplan = FaKaUserUnit.DataContext as GeneralObject; //新建对象,往t_updatehandplan插入数据 GeneralObject obj = new GeneralObject(); try { obj.WebClientInfo = Application.Current.Resources["dbclient"] as WebClientInfo; obj.EntityType = "t_updatemyfaka"; 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_usertype", ui_usertype.Text, false); obj.SetPropertyValue("f_qibiaochangjia", ui_gasmetermanufacturers.Text, false); obj.SetPropertyValue("f_qibiaopinpai", ui_gaswatchbrand.Text, false); obj.SetPropertyValue("f_gaspricetype", ui_f_gaspricetype.Text, false); obj.SetPropertyValue("f_newpregas", decimal.Parse(ui_f_pregas.Text), false); obj.SetPropertyValue("f_pregas", decimal.Parse(go.GetPropertyValue("f_pregas").ToString()), false); obj.SetPropertyValue("f_cardfees", decimal.Parse(go.GetPropertyValue("f_cardfees").ToString()), false); obj.SetPropertyValue("f_newcardfees", decimal.Parse(ui_f_cardfees.Text), false); obj.SetPropertyValue("f_preamount", decimal.Parse(go.GetPropertyValue("f_preamount").ToString()), false); obj.SetPropertyValue("f_newpreamount", decimal.Parse(ui_f_preamount.Text), false); obj.SetPropertyValue("f_totalcost", decimal.Parse(go.GetPropertyValue("f_totalcost").ToString()), false); obj.SetPropertyValue("f_newtotalcost", decimal.Parse(ui_f_totalcost.Text), false); obj.SetPropertyValue("f_whethergivecard", go.GetPropertyValue("f_whethergivecard").ToString(), false); obj.SetPropertyValue("f_newwhethergivecard", ui_f_whethergivecard.Text, false); obj.SetPropertyValue("f_cardid", ui_f_cardid.Text, false); obj.SetPropertyValue("f_updatenote", ui_updatenote.Text, false); obj.SetPropertyValue("f_handplanoperator", ui_operator.Text, false); obj.SetPropertyValue("f_handplandate", ui_handplandate.SelectedDate, false); obj.Name = "t_updatemyfaka"; //obj.Completed += obj_Completed; obj.Save(); } catch (Exception a) { MessageBox.Show(a.Message); } //oughtfee shifoujiaofei f_operator f_inputtor f_zhinajindate string sql = "update t_myfaka set f_pregas= " + decimal.Parse(ui_f_pregas.Text) + ",f_cardfees=" + decimal.Parse(ui_f_cardfees.Text) + ",f_preamount=" + decimal.Parse(ui_f_preamount.Text) + ",f_totalcost=" + decimal.Parse(ui_f_totalcost.Text) + ",f_whethergivecard='" + ui_f_whethergivecard.Text + "' 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 ((userfiles.ItemsSource as PagedList).Count < 1 || CoboxStair.SelectedValue == null || "".Equals(CoboxStair.SelectedValue)) { MessageBox.Show("请选择要修改用户和阶梯气价"); return; } ui_searchBusy.IsBusy = true; search.Search(); if (!"1=1".Equals(search.Condition.Trim()) && null != search.Condition) { if (ui_stairmonths.Text != "" || ui_stair1amount.Text != "" || ui_stair1price.Text != "" || ui_stair2amount.Text != "" || ui_stair2price.Text != "" || ui_stair3amount.Text != "" || ui_stair3price.Text != "" || CoboxStair.SelectedValue != null) { //提交更改 string sql = "update t_userinfo 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(); } } else { MessageBox.Show("请先按照条件筛选出变更的用户,再确认变更!"); ui_searchBusy.IsBusy = false; } }