| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918 |
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using com.hnshituo.pur.vo;
- using Core.Mes.Client.Comm.Control;
- using Core.Mes.Client.Comm.Tool;
- using Pur.Entity;
- using Pur.PublicTools;
- namespace Pur.require_plan
- {
- public partial class FrmPurOilCardMaintain : FrmPmsBase
- {
- public FrmPurOilCardMaintain()
- {
- InitializeComponent();
- this.IsLoadUserView = true;
- }
- private void FrmPurOilCardMaintain_Load(object sender, EventArgs e)
- {
- GridHelper.SetExcludeColumnsActive(ultraGrid1.DisplayLayout.Bands[0], new string[] {});
- GridHelper.SetExcludeColumnsActive(ultraGrid2.DisplayLayout.Bands[0], new string[] {});
- ultraExpandableGroupBox1.Expanded = false;
- ultraExpandableGroupBox2.Expanded = false;
- txt_type1_M.SelectedIndex = 0;
- ck_ctime.Checked = true;
- txtCreateTimeStart.Value = DateTime.Now.AddMonths(-2);
- txtCreateTimeEnd.Value = DateTime.Now.AddDays(2);
- txtCreateTimeStart.Enabled = true;
- txtCreateTimeEnd.Enabled = true;
- txt_status.SelectedIndex = 0;
- ultraExpandableGroupBox1.Expanded = true;
- ultraExpandableGroupBox4.Expanded = false;
- ultraExpandableGroupBox3.Expanded = false;
- ultraTabControl1.SelectedTab=ultraTabControl1.Tabs[0];
- ck_is_all.Checked = false;
- }
- private void FrmPurOilCardMaintain_Shown(object sender, EventArgs e)
- {
- this.ToolBarItemEnable(this, "Query", true);
- this.ToolBarItemEnable(this, "Add", true);
- this.ToolBarItemEnable(this, "Delete", true);
- this.ToolBarItemEnable(this, "Update", true);
- this.ToolBarItemEnable(this, "doExcel", true);
- this.ToolBarItemEnable(this, "Close", true);
- }
- #region toolbar工具栏
- //菜单按钮事件
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- switch (ToolbarKey)
- {
- case "Query":
- doQuery("");
- break;
- case "Add"://新增
- doAdd();
- break;
- case "Delete"://删除
- doDelete();
- break;
- case "Update"://更新
- doUpdate();
- break;
- case "doExcel"://导出Excel
- doExcel();
- break;
- case "Close":
- if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
- {
- this.Close();
- }
- break;
- }
- }
- /// <summary>
- /// 查询
- /// </summary>
- private void doQuery(string Mid)
- {
- if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
- {
- card.Clear();
- OilCardM cardM = new OilCardM();
- cardM.OilCardMId = txt_Card_No_M.Text.Trim();
- cardM.UserOrgName = txt_org_name.Text.Trim();
- if(txt_type1_M.SelectedIndex!=-1)
- {
- cardM.Type = txt_type1_M.Value.ToString().Trim();
- }
- cardM.DeleteUserid = txt_cardMD_no.Text.Trim();
- cardM.UpdateUserid = txt_User_name1.Text.Trim();
- DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardMService", "find_CardM", new object[] { cardM });
- if (dt != null)
- {
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
- GridHelper.RefreshAndAutoSize(ultraGrid1);
- if (String.IsNullOrEmpty(Mid))
- {
- publicPms.doActiveSelRow(ultraGrid1, "OILCARDMID", Mid);
- }
- }
- }
- else
- {
- changeRecord.Clear();
- OilCardChange change = new OilCardChange();
- change.CardId = txt_card_change_d.Text;
- if (ck_ctime.Checked && String.IsNullOrEmpty(txtCreateTimeStart.Text))
- {
- change.CreateTime = Convert.ToDateTime(txtCreateTimeStart.Value);
- }
- if (ck_ctime.Checked && String.IsNullOrEmpty(txtCreateTimeEnd.Text))
- {
- change.DeleteTime = Convert.ToDateTime(txtCreateTimeEnd.Value);
- }
- DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardChangeService", "find_Change", new object[] { change });
- if (dt != null)
- {
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
- GridHelper.RefreshAndAutoSize(ultraGrid4);
- }
- }
- }
- /// <summary>
- /// 新增
- /// </summary>
- private void doAdd()
- {
- if (testMInput() == false)
- {
- return;
- }
- String OilCardMNo = txt_card_m_add.Text.Trim();
- String OrgName = txt_org_add.Text.Trim();
- String strType1 = txt_type1_add.Value.ToString().Trim();
- OilCardM cardM = new OilCardM();
- cardM.OilCardMId = OilCardMNo;
- cardM.Validflag = "1";
- cardM.UserOrgName = OrgName;
- cardM.CreateName = UserInfo.GetUserName();
- cardM.CreateUserid = UserInfo.GetUserName();
- cardM.CreateTime = DateTime.Now;
- cardM.Type = strType1;
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "insert_CardM", new object[] { cardM });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("新增失败:" + crt.Resultmsg.ToString());
- }
- else
- {
- MessageUtil.ShowTips("新增成功,新增油卡:"+OilCardMNo);
- doQuery(OilCardMNo);
-
- }
-
- }
- /// <summary>
- /// 删除
- /// </summary>
- private void doDelete()
- {
- if (ultraGrid1.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择主卡行信息");
- return;
- }
- String strMid = ultraGrid1.ActiveRow.GetCellValue("id").ToString().Trim();
- if (String.IsNullOrEmpty(strMid))
- {
- MessageUtil.ShowTips("主卡编号为空");
- return;
- }
- OilCardM cardM = new OilCardM();
- cardM.Id = strMid;
- cardM.DeleteName = UserInfo.GetUserName();
- cardM.DeleteUserid = UserInfo.GetUserName();
- cardM.DeleteTime = DateTime.Now;
- cardM.Validflag = "1";
- if (testMStatus(strMid) == false)
- {
- return;
- }
- OilCardD cardD = new OilCardD();
- cardD.MId = strMid;
- cardM.Validflag = "1";
- int count = this.execute<int>("com.hnshituo.pur.requireplan.service.OilCardDService", "count", new object[] { cardD });
- if (count > 0)
- {
- if (MessageUtil.ShowYesNoAndQuestion("该主卡已绑定副卡,若删除,则主卡和该主卡绑定的副卡将一起删除?") != DialogResult.Yes)
- {
- return;
- }
- }
- else
- {
- if (MessageUtil.ShowYesNoAndQuestion("确定删除编号为:" + strMid + "的主卡?") != DialogResult.Yes)
- {
- return;
- }
- }
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "delete_CardM", new object[] { cardM });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("新增失败:" + crt.Resultmsg.ToString());
- }
- else
- {
- MessageUtil.ShowTips("操作成功");
- doQuery("");
- }
- }
- /// <summary>
- /// 更新
- /// </summary>
- private void doUpdate()
- {
- if (ultraGrid1.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择主卡");
- return;
- }
- String strMid = ultraGrid1.ActiveRow.GetCellValue("id").ToString().Trim();
- if (String.IsNullOrEmpty(strMid))
- {
- MessageUtil.ShowTips("主卡编号为空");
- return;
- }
- if (testMStatus(strMid) == false)
- {
- return;
- }
- if (testMInput() == false)
- {
- return;
- }
- String OilCardMNoNew = txt_card_m_add.Text.Trim();
- String OrgNameNew = txt_org_add.Text.Trim();
- String strType1 = txt_type1_add.Value.ToString().Trim();
- OilCardM cardM = new OilCardM();
- cardM.Id = strMid;
- cardM.OilCardMId = OilCardMNoNew;
- cardM.UserOrgName = OrgNameNew;
- cardM.UpdateName = UserInfo.GetUserName();
- cardM.UpdateUserid = UserInfo.GetUserName();
- cardM.UpdateTime = DateTime.Now;
- cardM.Validflag = "1";
- cardM.Type = strType1;
- if (MessageUtil.ShowYesNoAndQuestion("确定修改主卡:" + strMid + "?") != DialogResult.Yes)
- {
- return;
- }
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardMService", "update_CardM", new object[] { cardM });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("修改失败:" + crt.Resultmsg.ToString());
- }
- else
- {
- MessageUtil.ShowTips("修改成功");
- doQuery(OilCardMNoNew);
- }
- }
- /// <summary>
- /// 导出Excel
- /// </summary>
- private void doExcel()
- {
- try
- {
- this.Cursor = Cursors.Default;
- if (ultraTabControl1.SelectedTab == ultraTabControl1.Tabs[0])
- {
- if (ultraGrid1.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择需导出油卡!");
- return;
- }
- ArrayList alUltraGrid = new ArrayList();
- alUltraGrid.Add(ultraGrid1);
- alUltraGrid.Add(ultraGrid2);
- ArrayList alSheeft = new ArrayList();
- alSheeft.Add("主油卡");
- alSheeft.Add("副油卡");
- GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "油卡明细表");
- }
- else
- {
- if (ultraGrid4.Rows.Count<=0)
- {
- MessageUtil.ShowTips("无可导出变更明细!");
- return;
- }
- ArrayList alUltraGrid = new ArrayList();
- alUltraGrid.Add(ultraGrid4);
- ArrayList alSheeft = new ArrayList();
- alSheeft.Add("变更记录");
- GridHelper.ulGridToExcel(alUltraGrid, alSheeft, "变更记录");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowTips("导出失败" + e.Message);
- }
- finally
- {
- this.Cursor = Cursors.Default;
- }
- }
- #endregion
- #region 行按钮
- private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
- {
- switch (e.Tool.Key)
- {
- case "doEdit": // ButtonTool
- doEditD();
- break;
- case "doAdd": // ButtonTool
- doAddD();
- break;
- case "doSuspend": // ButtonTool
- doSuspendD();
- break;
- case "cancelSuspend":// ButtonTool
- cancelSuspendD();
- break;
- case "doCancel": // ButtonTool
- doCancelD();
- break;
- }
- }
- /// <summary>
- /// 查询
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void btn_query_d_Click(object sender, EventArgs e)
- {
- doQuery_d("");
- }
- /// <summary>
- /// 注销
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void doCancelD()
- {
- if (ultraGrid2.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择副卡行信息");
- return;
- }
- String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
- String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
- if (String.IsNullOrEmpty(strDid))
- {
- MessageUtil.ShowTips("副卡编号为空");
- return;
- }
- OilCardD a = new OilCardD();
- if (testDStatus(strDid, out a, 4) == false)
- {
- return;
- }
- if (MessageUtil.ShowYesNoAndQuestion("确定注销副卡:" + strCARDNo + "?") != DialogResult.Yes)
- {
- return;
- }
- a.UpdateName = UserInfo.GetUserName();
- a.UpdateUserid = UserInfo.GetUserID();
- a.UpdateTime = DateTime.Now;
- a.Status = "3";
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("注销失败:" + crt.Resultmsg);
- }
- else
- {
- MessageUtil.ShowTips("注销成功");
- doQuery_d(strDid);
- }
- }
- /// <summary>
- /// 取消暂停
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void cancelSuspendD()
- {
- if (ultraGrid2.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择副卡行信息");
- return;
- }
- String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
- String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
- if (String.IsNullOrEmpty(strDid))
- {
- MessageUtil.ShowTips("副卡编号为空");
- return;
- }
- OilCardD a = new OilCardD();
- if (testDStatus(strDid, out a, 3) == false)
- {
- return;
- }
- if (MessageUtil.ShowYesNoAndQuestion("确定取消暂停副卡:" + strCARDNo + "?") != DialogResult.Yes)
- {
- return;
- }
- a.UpdateName = UserInfo.GetUserName();
- a.UpdateUserid = UserInfo.GetUserID();
- a.UpdateTime = DateTime.Now;
- a.Status = "1";
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("暂停失败:" + crt.Resultmsg);
- }
- else
- {
- MessageUtil.ShowTips("暂停成功");
- doQuery_d(strDid);
- }
- }
- /// <summary>
- /// 暂停
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void doSuspendD()
- {
- if (ultraGrid2.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择副卡行信息");
- return;
- }
- String strDid = ultraGrid2.ActiveRow.GetCellValue("id").ToString().Trim();
- String strCARDNo = ultraGrid2.ActiveRow.GetCellValue("OILCARDID").ToString().Trim();
- if (String.IsNullOrEmpty(strDid))
- {
- MessageUtil.ShowTips("副卡编号为空");
- return;
- }
- OilCardD a = new OilCardD();
- if (testDStatus(strDid, out a, 2) == false)
- {
- return;
- }
- if (MessageUtil.ShowYesNoAndQuestion("确定暂停副卡:" + strCARDNo + "?") != DialogResult.Yes)
- {
- return;
- }
- a.UpdateName = UserInfo.GetUserName();
- a.UpdateUserid = UserInfo.GetUserID();
- a.UpdateTime = DateTime.Now;
- a.Status = "2";
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "suspend_CardD", new object[] { a });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("暂停失败:" + crt.Resultmsg);
- }
- else
- {
- MessageUtil.ShowTips("暂停成功");
- doQuery_d(strDid);
- }
- }
- /// <summary>
- /// 添加
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void doAddD()
- {
- String strMid = ultraGrid1.ActiveRow.GetCellValue("Id").ToString().Trim();
- if (String.IsNullOrEmpty(strMid))
- {
- MessageUtil.ShowTips("主卡编号为空");
- return;
- }
- if (testDInput() == false)
- {
- return;
- }
- String strDid = txt_card_no_add.Text.Trim();
- String strUseName = txt_use_name_add.Text.Trim();
-
- String strType2 = txt_type2_add.Value.ToString().Trim();
- String remark = txt_remark.Text.Trim();
- String strCar = txt_car_add.Text.Trim();
- OilCardD cardD = new OilCardD();
- cardD.MId = strMid;
- cardD.OilCardId = txt_card_d_no.Text.Trim();
- cardD.UserName = strUseName;
- cardD.Remark = remark;
- cardD.Type = strType2;
- cardD.OilCardId = strDid;
- cardD.Validflag = "1";
- cardD.Car = strCar;
- cardD.CreateName = UserInfo.GetUserName();
- cardD.CreateUserid = UserInfo.GetUserName();
- cardD.CreateTime = DateTime.Now;
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "insert_CardD", new object[] { cardD });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("添加失败:" + crt.Resultmsg);
- }
- else
- {
- MessageUtil.ShowTips("添加成功");
- doQuery_d(strDid);
- }
- }
- /// <summary>
- /// 修改
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void doEditD()
- {
- if (ultraGrid2.ActiveRow == null)
- {
- MessageUtil.ShowTips("请选择副卡行信息");
- return;
- }
- String strDid = ultraGrid2.ActiveRow.GetCellValue("Id").ToString().Trim();
- if (String.IsNullOrEmpty(strDid))
- {
- MessageUtil.ShowTips("副卡编号为空");
- return;
- }
- OilCardD a = new OilCardD();
- if (testDStatus(strDid, out a, 1) == false)
- {
- return;
- }
- if (testDInput() == false)
- {
- return;
- }
- String strCardDNew = txt_card_no_add.Text.Trim();
- String strUseName = txt_use_name_add.Text.Trim();
- String strType2 = txt_type2_add.Value.ToString().Trim();
- String remark = txt_remark.Text.Trim();
- String strCar = txt_car_add.Text.Trim();
- OilCardD cardD = new OilCardD();
- cardD.Id = strDid;
- cardD.OilCardId = strCardDNew;
- cardD.UserName = strUseName;
- cardD.Type = strType2;
- cardD.Car = strCar;
- cardD.Validflag = "1";
- cardD.Remark = remark;
- cardD.UpdateName = UserInfo.GetUserName();
- cardD.UpdateUserid = UserInfo.GetUserName();
- cardD.UpdateTime = DateTime.Now;
- if (MessageUtil.ShowYesNoAndQuestion("确定修改编号为:" + strDid + "的副卡?") != DialogResult.Yes)
- {
- return;
- }
- CoreResult crt = this.execute<CoreResult>("com.hnshituo.pur.requireplan.service.OilCardDService", "update_CardD", new object[] { cardD });
- if (crt.Resultcode != 0)
- {
- MessageUtil.ShowTips("修改失败:" + crt.Resultmsg);
- }
- else
- {
- MessageUtil.ShowTips("修改成功");
- doQuery_d(strDid);
- }
- }
-
- #endregion
- #region 界面事件
- private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
- {
- clearCardM();
- clearCardD();
- doQuery_d("");
- String strMid = ultraGrid1.ActiveRow.GetCellValue("Id").ToString().Trim();
- OilCardM cm = this.execute<OilCardM>("com.hnshituo.pur.requireplan.service.OilCardMService", "findById", new object[] { strMid });
- txt_org_add.Text = cm.UserOrgName;
- txt_card_m_add.Text = cm.OilCardMId;
- txt_type1_add.Value = cm.Type;
- }
- private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
- {
- clearCardD();
- String strDid = ultraGrid2.ActiveRow.GetCellValue("Id").ToString().Trim();
- OilCardD cd = this.execute<OilCardD>("com.hnshituo.pur.requireplan.service.OilCardDService", "findById", new object[] { strDid });
- txt_car_add.Text = cd.Car;
- txt_card_no_add.Text = cd.OilCardId;
- txt_remark.Text = cd.Remark;
- txt_type2_add.Value = cd.Type;
- txt_use_name_add.Text = cd.UserName;
- }
- private void ck_ctime_CheckedChanged(object sender, EventArgs e)
- {
- txtCreateTimeEnd.Enabled = ck_ctime.Checked;
- txtCreateTimeStart.Enabled = ck_ctime.Checked;
- }
- /// <summary>
- /// 标识颜色
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ultraGrid2_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
- {
- if (e.Row.Cells["status"].Value.ToString().Equals("暂停"))
- {
- e.Row.Appearance.ForeColor = Color.Red;
- }
- else if (e.Row.Cells["status"].Value.ToString().Equals("注销"))
- {
- e.Row.Appearance.ForeColor = Color.Gray;
- }
- else
- {
- e.Row.Appearance.ForeColor = Color.Black;
- }
- }
- /// <summary>
- /// 界面切换
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- if (e.Tab == ultraTabControl1.Tabs[0])
- {
- this.ToolBarItemEnable(this, "Query", true);
- this.ToolBarItemEnable(this, "Add", true);
- this.ToolBarItemEnable(this, "Delete", true);
- this.ToolBarItemEnable(this, "Update", true);
- this.ToolBarItemEnable(this, "doExcel", true);
- this.ToolBarItemEnable(this, "Close", true);
- }
- else
- {
- this.ToolBarItemEnable(this, "Query", true);
- this.ToolBarItemEnable(this, "Add", false);
- this.ToolBarItemEnable(this, "Delete", false);
- this.ToolBarItemEnable(this, "Update", false);
- this.ToolBarItemEnable(this, "doExcel", true);
- this.ToolBarItemEnable(this, "Close", true);
- }
- }
- #endregion
- #region 公共函数
- /// <summary>
- /// 查询行
- /// </summary>
- private void doQuery_d(String CardNo)
- {
- dataTable2.Clear();
- if (ultraGrid1.ActiveRow == null)
- {
- return;
- }
- String strMid = ultraGrid1.ActiveRow.GetCellValue("ID").ToString().Trim();
- if (String.IsNullOrEmpty(strMid))
- {
- MessageUtil.ShowTips("主卡卡号为空");
- return;
- }
- OilCardD cardD = new OilCardD();
- if (!ck_is_all.Checked)
- {
- cardD.MId = strMid;
- }
- cardD.OilCardId = String.IsNullOrEmpty(txt_card_d_no.Text.Trim()) ? txt_cardMD_no.Text.Trim() : txt_card_d_no.Text.Trim();
- cardD.UserName = String.IsNullOrEmpty(txt_useName.Text.Trim())?txt_User_name1.Text.Trim():txt_useName.Text.Trim();
- if (txt_status.SelectedIndex != -1)
- {
- cardD.Status = txt_status.Value.ToString().Trim();
- }
- DataTable dt = this.execute<DataTable>("com.hnshituo.pur.requireplan.service.OilCardDService", "find_CardD", new object[] { cardD });
- if (dt != null)
- {
- GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
- GridHelper.RefreshAndAutoSize(ultraGrid2);
- if (String.IsNullOrEmpty(CardNo))
- {
- publicPms.doActiveSelRow(ultraGrid2, "OILCARDID", CardNo);
- }
- }
- }
- /// <summary>
- /// 校验主卡编辑区数据
- /// </summary>
- /// <returns></returns>
- private bool testMInput()
- {
- if (String.IsNullOrEmpty(txt_card_m_add.Text.Trim()))
- {
- MessageUtil.ShowTips("主卡卡号不能为空");
- txt_card_m_add.Focus();
- return false;
- }
- if (txt_card_m_add.Text.Trim().Length > 100)
- {
- MessageBox.Show("请输入卡号最多100位", "提示");
- txt_card_m_add.Focus();
- return false;
- }
- if (!StringUtil.IsOnlyLetterAndDigit(txt_card_m_add.Text.Trim()))
- {
- MessageBox.Show("卡号只能包含字母与数字", "提示");
- txt_card_m_add.Focus();
- return false;
- }
-
- if (String.IsNullOrEmpty(txt_org_add.Text.Trim()))
- {
- MessageUtil.ShowTips("所属部门为空");
- txt_org_add.Focus();
- return false;
- }
- if (txt_type1_add.SelectedIndex == -1)
- {
- MessageUtil.ShowTips("副卡类型1不能为空");
- txt_type1_add.Focus();
- return false;
- }
- return true;
- }
- /// <summary>
- /// 校验主卡编辑区数据
- /// </summary>
- /// <returns></returns>
- private bool testDInput()
- {
- if (String.IsNullOrEmpty(txt_card_no_add.Text.Trim()))
- {
- MessageUtil.ShowTips("副卡卡号不能为空");
- txt_card_no_add.Focus();
- return false;
- }
- if (txt_card_no_add.Text.Trim().Length > 100)
- {
- MessageBox.Show("请输入卡号最多100位", "提示");
- txt_card_no_add.Focus();
- return false;
- }
- if (!StringUtil.IsOnlyLetterAndDigit(txt_card_no_add.Text.Trim()))
- {
- MessageBox.Show("卡号只能包含字母与数字", "提示");
- txt_card_no_add.Focus();
- return false;
- }
- if (String.IsNullOrEmpty(txt_use_name_add.Text.Trim()))
- {
- MessageUtil.ShowTips("用户名不能为空");
- txt_use_name_add.Focus();
- return false;
- }
- if (txt_type2_add.SelectedIndex == -1)
- {
- MessageUtil.ShowTips("副卡类型不能为空");
- txt_type2_add.Focus();
- return false;
- }
- if (txt_remark.Text.Trim().Length > 1000)
- {
- MessageBox.Show("备注内容太多", "提示");
- txt_card_no_add.Focus();
- return false;
- }
- return true;
- }
- /// <summary>
- /// 验证主卡状态
- /// </summary>
- /// <param name="StrCardNo"></param>
- /// <returns></returns>
- private bool testMStatus(String StrCardMNo)
- {
- if (String.IsNullOrEmpty(StrCardMNo))
- {
- MessageUtil.ShowTips("主卡编号为空");
- return false;
- }
- OilCardM a = this.execute<OilCardM>("com.hnshituo.pur.requireplan.service.OilCardMService", "findById", new object[] { StrCardMNo });
- if (a == null)
- {
- MessageUtil.ShowTips("未发现编号:" + StrCardMNo + "的主卡信息记录");
- return false;
- }
- if (a.Validflag != "1")
- {
- MessageUtil.ShowTips("编号:" + StrCardMNo + "的主卡信息记录已作废");
- return false;
- }
- return true;
- }
- /// <summary>
- /// 验证副卡状态
- /// </summary>
- /// <param name="StrCardNo"></param>
- /// <returns></returns>
- private bool testDStatus(String StrDid,out OilCardD a,int p)
- {
- a = new OilCardD();
- if (String.IsNullOrEmpty(StrDid))
- {
- MessageUtil.ShowTips("副卡编号为空");
- return false;
- }
- a = this.execute<OilCardD>("com.hnshituo.pur.requireplan.service.OilCardDService", "findById", new object[] { StrDid });
- if (a == null)
- {
- MessageUtil.ShowTips("未发现编号:" + StrDid + "的副卡信息记录");
- return false;
- }
- if (a.Validflag!="1")
- {
- MessageUtil.ShowTips("编号:" + StrDid + "的副卡信息记录已作废");
- return false;
- }
- //修改
- if (p == 1)
- {
- if (a.Status != "1")
- {
- MessageUtil.ShowTips("非正常状态,无法修改");
- return false;
- }
- }
- //暂挂
- else if (p == 2)
- {
- if (a.Status != "1")
- {
- MessageUtil.ShowTips("非正常状态,无法暂停");
- return false;
- }
- }
- //恢复
- else if (p ==3)
- {
- if (a.Status != "2")
- {
- MessageUtil.ShowTips("不在暂停,无法恢复");
- return false;
- }
- }
- //注销
- else if (p == 4)
- {
- if (a.Status== "3")
- {
- MessageUtil.ShowTips("已注销,重复操作");
- return false;
- }
- }
- else
- {
- MessageUtil.ShowTips("未知参数,无效操作");
- return false;
- }
- return true;
- }
- /// <summary>
- /// 清空主主卡编辑区
- /// </summary>
- private void clearCardM()
- {
- txt_org_add.Clear();
- txt_card_m_add.Clear();
- txt_type1_add.SelectedIndex = -1;
- }
- /// <summary>
- /// 清空副卡编辑区
- /// </summary>
- private void clearCardD()
- {
- txt_car_add.Clear();
- txt_card_no_add.Clear();
- txt_remark.Clear(); ;
-
- txt_type2_add.SelectedIndex = -1; ;
- txt_use_name_add.Clear();
- }
- #endregion
- }
- }
|