using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DBUtility; namespace BaseSet { public partial class Gy_ICCard : Form { private int HItemIDCol = 0; private int HNumberCol = 0; private int HCardFlagCol = 0; public int icdev; // 通讯设备标识符 public short st; //函数返回值 public bool Beep = true; public DBUtility.frm_B_BillQueryCondition_New frmCondition; public const string ViewName = "h_v_Gy_ICCardList"; public string CheckProcName = "h_p_Gy_ICCard"; //20141020 public string ModName = "班组"; public const string BillName = "Gy_ICCard"; public const string ModRightNameEdit = BillName + "_Edit"; public const string ModRightNameDelete = BillName + "_Delete"; public DBUtility.ClsPub.Enum_InputMode InputMode; //录入状态标志(0-非录入状态 1-增加 2-修改) public long HItemID;//项目ID public string sCondition; //过滤条件 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DAL.ClsGy_ICCard_Ctl oICCard = new DAL.ClsGy_ICCard_Ctl(); DAL.ClsGy_ICCard_View oICCardHlp = new DAL.ClsGy_ICCard_View(); TreeNode CurNode = new TreeNode(); public Gy_ICCard() { InitializeComponent(); } //以下代码基本不需要修改 #region 固定代码 //保存GRID列宽 private void Gy_ICCard_FormClosing(object sender, FormClosingEventArgs e) { DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); } //窗体加载 private void Gy_ICCard_Load(object sender, EventArgs e) { frmCondition = new DBUtility.frm_B_BillQueryCondition_New(); //LoadTree(); initGrid(); InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } private void LoadAllNodes(TreeNode sNode) //Lock { DBUtility.Gy_BaseFun.LoadAllNodes(sNode, BillName); } private void LoadTree()//Lock { DBUtility.Gy_BaseFun.LoadTree(tv, imageList1, this.Text, BillName); } //新增 private void AddNew() { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew; Init(); } //退出模块 private void tc_Click(object sender, EventArgs e) { this.Close(); } //刷新 private void xs_Click(object sender, EventArgs e) { Display(); } //查询 private void cx_Click(object sender, EventArgs e) { frmCondition = new DBUtility.frm_B_BillQueryCondition_New(); DBUtility.Gy_BaseFun.SetCondition(frmCondition ,ViewName, this.Name ); frmCondition.ShowDialog(); if (frmCondition.Tag.ToString() == "OK") { Display(); } } private Int32 Fun_GetCol(string sCol)//Lock { return DBUtility.Gy_BaseFun.Fun_GetCol(sCol, grdMain); } //刷新TOOLBAR private void RefreshTool()//Lock { if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View) { stTab.SelectedIndex = 0; stTab.TabPages.Remove(this.tabPage2); stTab.TabPages.Remove(this.tabPage1); stTab.TabPages.Add(this.tabPage1); grdMain.Enabled = true; tc.Enabled = true; yl.Enabled = true; xz.Enabled = true; xg.Enabled = true; sc.Enabled = true; xs.Enabled = true; cx.Enabled = true; fz.Enabled = false; xk.Enabled = true; } else { stTab.SelectedIndex = 1; stTab.TabPages.Remove(this.tabPage1); stTab.TabPages.Remove(this.tabPage2); stTab.TabPages.Add(this.tabPage2); stTab.TabPages[0].Hide(); grdMain.Enabled = false; tc.Enabled = true; yl.Enabled = false; xz.Enabled = false; xg.Enabled = false; sc.Enabled = false; xs.Enabled = false; cx.Enabled = false; fz.Enabled = true; xk.Enabled = false; } } //禁用 public void Sub_Stop() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { if (MessageBox.Show("确定要禁用当前项目?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //得到HITEMID long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //判断存在性 if (oICCardHlp.GetInfoByID(sItemID)) { if (oICCardHlp.omodel.HStopflag == true) { MessageBox.Show("此项目已禁用,不能禁用!", "提示"); return; } // if (oICCard.StopByID(sItemID)) { //写入日志 ClsPub.Add_Log("", "禁用项目,代码:" + oICCardHlp.omodel.HNumber + ",名称:" + oICCardHlp.omodel.HName, ClsPub.CurUserName); //更新上级为 末级 MessageBox.Show("禁用项目成功!", "提示"); Display(); } else MessageBox.Show("禁用项目失败!" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } } } } //恢复 public void Sub_UnStop() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { if (MessageBox.Show("确定要反禁用当前项目?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //得到HITEMID long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //判断存在性 if (oICCardHlp.GetInfoByID(sItemID)) { if (oICCardHlp.omodel.HStopflag== false ) { MessageBox.Show("此项目未禁用,不能反禁用!", "提示"); return; } // if (oICCard.UnStopByID(sItemID)) { //写入日志 ClsPub.Add_Log("", "反禁用项目,代码:" + oICCardHlp.omodel.HNumber + ",名称:" + oICCardHlp.omodel.HName, ClsPub.CurUserName); //更新上级为 末级 MessageBox.Show("反禁用项目成功!", "提示"); Display(); } else MessageBox.Show("反禁用项目失败!" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } } } } //删除项目 public void Delete() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { if (MessageBox.Show("确定要删除当前项目?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //得到HITEMID long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //判断存在性 if (oICCardHlp.GetInfoByID(sItemID)) { //if (oICCard.HavChildCodes(sItemID)) //{ // MessageBox.Show("此项目存在子项目,不能删除!", "提示"); // return; //} //删除前判断是否 已使用 20141020 if (oICCardHlp.omodel.HUseFlag != "未使用") { MessageBox.Show("此项目已使用或者未检测,不能删除!请重新检测再删除!", "提示"); return; } // if (oICCard.DeleteByID(sItemID)) { //写入日志 ClsPub.Add_Log("", "删除项目,代码:" + oICCardHlp.omodel.HNumber + ",名称:" + oICCardHlp.omodel.HName, ClsPub.CurUserName); //更新上级为 末级 MessageBox.Show("删除项目成功!", "提示"); Display(); } else MessageBox.Show("删除项目失败!" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } } } } //取消按钮 private void cmdCancel_Click(object sender, EventArgs e) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } //保存按钮 private void cmdOK_Click(object sender, EventArgs e) { if (!WriteClass()) return; if (Save()) { MessageBox.Show("保存完毕!", "提示"); } else { MessageBox.Show("保存失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_Modify) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } } //树型 单击 private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { CurNode = e.Node; if (CurNode != null) { if (CurNode.Nodes.Count == 0) LoadAllNodes(CurNode); //找到选中结点 FindRow(CurNode.Text); } } //过滤资料 private void FindRow(string sCode)//Lock { DBUtility.Gy_BaseFun.FindRow(sCode, ModName, ref sCondition); Display(); } //删除 private void sc_Click(object sender, EventArgs e) { Delete(); } //新增按钮 private void xz_Click(object sender, EventArgs e) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew; Init(); } //修改 private void Modify() { if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_Modify; RefreshTool(); Init(); } } //修改按钮 private void xg_Click(object sender, EventArgs e) { Modify(); } // private void Sub_Copy() { //txtHNumber.Text = ""; //txtHHelpCode.Text = ""; HItemID = 0; InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew; } //初始化界面 private bool Init() { long sItemID; if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew) { Sub_Clear(); RefreshTool(); return true; } else { //得到HITEMID sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //检查是否存在 if (oICCardHlp.GetInfoByID(sItemID)) { ShowData(sItemID); //txtHNumber.Focus(); return true; } else { MessageBox.Show("您选择的项目已经不存在!" + DBUtility.ClsPub.sExeReturnInfo, "提示"); return false; } } } //保存 private bool Save() { //判断权限 if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) { return false; } // if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew) { if (oICCard.AddNew()) { Init(); } else { return false; } Display(); } if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_Modify) { if (!oICCard.ModifyByID(HItemID)) { return false; } Display(); } return true; } //保存列宽 private void bclk_Click(object sender, EventArgs e) { DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); } //默认列宽 private void mrlk_Click(object sender, EventArgs e)//Lock { DBUtility.ClsPub.DefaultGridView(grdMain); //参数解释 开始列 ,结束列,是否以最大列宽为准,最小列宽 DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); } //时间控件 private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; Display(); } //双击GRID private void grdMain_DblClick(object sender, EventArgs e) { Modify(); } //初始化GRID private void initGrid() { DBUtility.Gy_BaseFun.initGrid(grdMain); } //显示列表 private void Display() // 幻心 { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); DataSet DSet; string sSql = ""; string sWhere = ""; //刷新树形 //LoadTree(); //过滤条件 if (DBUtility.ClsPub.isStrNull(sCondition) == "" && frmCondition.SqlStr.Trim().Length != 0) { sSql = frmCondition.SqlStr + sWhere + " order by 卡号"; } else if (DBUtility.ClsPub.isStrNull(sCondition) != "") { sSql = "Select * from " + ViewName + sCondition + sWhere + " order by 卡号"; } else { sSql = "Select * from " + ViewName + " order by 卡号"; } //执行SQL DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); // if (DSet == null) { MessageBox.Show("显示失败!原因:" + DBUtility.ClsPub.sExeReturnInfo); return; } grdMain.DataSource = DSet.Tables[0].DefaultView; //禁用 红色显示 20141020 Sub_ShowStopFlag(); //加载列宽 DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name); // HItemIDCol = Fun_GetCol("HItemID"); HNumberCol = Fun_GetCol("卡号"); HCardFlagCol = Fun_GetCol("写卡标记"); sCondition = ""; } //复制按钮 private void fz_Click(object sender, EventArgs e) { Sub_Copy(); } //新增时清空信息 private void Sub_Clear() //Lock { DBUtility.Gy_BaseFun.Sub_Clear(tabPage2, ref HItemID, txtHCardNo); } private void grdMain_DoubleClick(object sender, EventArgs e) { Modify(); } private void cmdLoadTree_Click(object sender, EventArgs e) { LoadTree(); } #endregion #region 类的读写 private bool AllowSave() { if (txtHCardNo.Text.Trim() == "") { MessageBox.Show("卡号不能为空!", "提示"); return false; } if (DBUtility.ClsPub.isLong(txtHEmpID.Tag) == 0) { MessageBox.Show("领卡人不能为空!", "提示"); return false; } //审核代码是否合理 //if (!DBUtility.ClsPub.AllowNumber(txtHNumber.Text.Trim())) //{ // MessageBox.Show("代码中不能出现连续‘.’并且首位末位不能为‘.’!", "提示"); // return false; //} //是否重复代码 //if (oICCard.HavSameNumber(HItemID, txtHNumber.Text.Trim())) //{ // MessageBox.Show("代码重复!", "提示"); // return false; //} DataSet DS; DS = oCn.RunProcReturn("Select HItemID from Gy_ICCard Where HItemID<>" + HItemID + " and HCardNo='" + txtHCardNo.Text.Trim() + "'", "Gy_ICCard"); if (DS.Tables[0].Rows.Count != 0) { MessageBox.Show("卡号重复!", "提示"); return false; } return true; } //读取类 到 控件 private void ShowData(long sItemID) { DAL.ClsIF_Employee_View oEmp = new DAL.ClsIF_Employee_View(); DAL.ClsK3_User_View oUser = new DAL.ClsK3_User_View(); if (oICCardHlp.GetInfoByID(sItemID)) { txtHEmpID.Tag = Convert.ToInt64(oICCardHlp.omodel.HEmpID.ToString()); if (oEmp.GetInfoByID(oICCardHlp.omodel.HEmpID)) { txtHEmpID.Text = oEmp.omodel.HName; txtHEmpID.Tag = oEmp.omodel.HItemID.ToString(); } else { txtHEmpID.Text = ""; } //---- txtK3User.Tag = Convert.ToInt64(oICCardHlp.omodel.HK3UserID.ToString()); if (oUser.GetInfoByID(oICCardHlp.omodel.HK3UserID)) { txtK3User.Text = oUser.omodel.HName; txtK3User.Tag = oUser.omodel.HItemID.ToString(); } else { txtK3User.Text = ""; } //------------------- txtHCardNo.Text = oICCardHlp.omodel.HCardNo.ToString(); txtHCardID.Text = oICCardHlp.omodel.HCardID.ToString(); txtHRemark.Text = oICCardHlp.omodel.HRemark.ToString(); txtHMaker.Text = oICCardHlp.omodel.HMaker; txtHMakeDate.Text = oICCardHlp.omodel.HMakeDate.ToShortDateString(); cmbHCardType.Text = oICCardHlp.omodel.HCardType.ToString(); if (oICCardHlp.omodel.HStopflag) chkHStopflag.Checked = true; else chkHStopflag.Checked = false; HItemID = oICCardHlp.omodel.HItemID; } } //写入类 从控件 private bool WriteClass() { //判断是否允许 保存 if (!AllowSave()) { return false; } ////检查父级是否存在 //string sParent; //sParent = DBUtility.ClsPub.GetParentCode(txtHNumber.Text.Trim()); //if (sParent.Trim() == "") //{ // oICCard.oModel.HParentID = 0; //} //else //{ // if (oICCard.HavParentCode(sParent.Trim(), HItemID)) // { // oICCard.oModel.HParentID = oICCard.oModel.HItemID; // } // else // { // MessageBox.Show("上级代码不存在或被禁用!", "提示"); // return false; // } //} ////得到短代码 //string sShortNumber; //sShortNumber = DBUtility.ClsPub.GetShortNumber(txtHNumber.Text.Trim()); //if (sShortNumber.Trim() == "") //{ // return false; //} ////保存原代码 //if (oICCardHlp.GetInfoByID(HItemID)) //{ // oICCard.HOldNumber = oICCardHlp.omodel.HNumber; // //是否新代码是自己子项目的 子项目 // if (sParent.Length >= oICCard.HOldNumber.Length) // { // if (sParent.Substring(0, oICCard.HOldNumber.ToString().Length) == oICCard.HOldNumber.Trim()) // { // MessageBox.Show("新代码不能是自己的下级的子项目!", "提示"); // return false; // } // } //} //else //{ // oICCard.HOldNumber = ""; //} //写入信息 //oICCard.oModel.HShortNumber = sShortNumber; //oICCard.oModel.HEndFlag = true; //oICCard.oModel.HLevel = DBUtility.ClsPub.GetLevel(txtHNumber.Text.Trim()); //oICCard.oModel.HNumber = txtHNumber.Text.Trim(); //oICCard.oModel.HHelpCode = txtHHelpCode.Text.Trim(); oICCard.oModel.HCardNo = txtHCardNo.Text.Trim(); oICCard.oModel.HCardID = DBUtility.ClsPub.isLong(txtHCardID.Text.ToString()); oICCard.oModel.HEmpID = DBUtility.ClsPub.isLong(txtHEmpID.Tag.ToString()); oICCard.oModel.HK3UserID = DBUtility.ClsPub.isLong(txtK3User.Tag.ToString()); oICCard.oModel.HRemark = txtHRemark.Text.Trim(); oICCard.oModel.HStopflag = chkHStopflag.Checked; oICCard.oModel.HMaker = DBUtility.ClsPub.CurUserName; oICCard.oModel.HMakeDate = DateTime.Now; oICCard.oModel.HCardType = cmbHCardType.Text; return true; } #endregion #region 界面控件处理 private void cmdHEmpID_Click(object sender, EventArgs e) { DAL.ClsIF_Employee_View oEmp = new DAL.ClsIF_Employee_View(); if (oEmp.RefreshView()) { this.txtHEmpID.Text = oEmp.oModel.HName; this.txtHEmpID.Tag = oEmp.oModel.HItemID.ToString(); } else { this.txtHEmpID.Text = ""; } } private void txtHEmpID_TextChanged(object sender, EventArgs e) { if (txtHEmpID.Text.Length == 0) { txtHEmpID.Tag = "0"; } } #endregion //检测按钮 20141020 private void jc_Click(object sender, EventArgs e) { BLL.ClsPub_BLL.Sub_CheckUseStatus(grdMain, HItemIDCol, CheckProcName); Display(); } //禁用项目 红色字体 20141020 public void Sub_ShowStopFlag() { BLL.ClsPub_BLL.Sub_ShowStopFlag(grdMain, Fun_GetCol("禁用标记")); } private void xk_Click(object sender, EventArgs e) { long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); string sCardNo; sCardNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HNumberCol].Value); string sCardFlag; sCardFlag = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HCardFlagCol].Value); if (sCardFlag == "Y") { MessageBox.Show("此项目已写卡,不能再次写卡!", "提示"); return; } //--------------连接设备 icdev = DBUtility.mwxrf32dll.rf_init(0, 115200); if (icdev < 0) { MessageBox.Show("连接失败!"); return; } byte[] WriteData1 = Encoding.ASCII.GetBytes(sCardNo); byte[] datarecv = new byte[1000]; byte[] key = new byte[10]; st = mwxrf32dll.rf_request(icdev, 1, datarecv); if (st != 0) { MessageBox.Show("M1卡寻卡失败!"); //---------------------断开设备连接 rf_exis(); return; } key[0] = 0xff; key[1] = 0xff; key[2] = 0xff; key[3] = 0xff; key[4] = 0xff; key[5] = 0xff; st = mwxrf32dll.rf_authentication_key(icdev, 0, 1, key); if (st != 0) { MessageBox.Show("M1卡密码认证失败!"); //---------------------断开设备连接 rf_exis(); return; } //---------------------- byte[] sRecData = new byte[20]; st = DBUtility.mwxrf32dll.rf_read(icdev, 1, sRecData); if (st != 0) { MessageBox.Show("M1卡读数据失败!"); rf_exis(); return; } string CardNo = Encoding.ASCII.GetString(sRecData);//------------CardNo 卡号 CardNo = CardNo.Substring(0, CardNo.IndexOf('\0')); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; Ds = oCn.RunProcReturn("select * from Gy_ICCard where hcardno='" + CardNo + "'", "Gy_ICCard"); if (Ds.Tables[0].Rows.Count == 0) { st = mwxrf32dll.rf_write(icdev, 1, WriteData1); if (st != 0) { MessageBox.Show("M1卡写数据失败!"); //---------------------断开设备连接 rf_exis(); return; } else { MessageBox.Show("M1卡写数据成功!"); oCn.RunProc("update Gy_ICCard set HCardFlag=1 where hitemid=" + sItemID); Display(); rf_exis(); } } else { if (MessageBox.Show("此IC卡已存在卡号,确定覆盖?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //----------------------- st = mwxrf32dll.rf_write(icdev, 1, WriteData1); if (st != 0) { MessageBox.Show("M1卡写数据失败!"); //---------------------断开设备连接 rf_exis(); return; } else { MessageBox.Show("M1卡写数据成功!"); oCn.RunProc("update Gy_ICCard set HCardFlag=0 where hcardno='" + CardNo+"'"); oCn.RunProc("update Gy_ICCard set HCardFlag=1 where hitemid=" + sItemID); Display(); } } //---------------------断开设备连接 rf_exis(); } } private void rf_exis() { //---------------------断开设备连接 st = DBUtility.mwxrf32dll.rf_exit(icdev); if (st != 0) { MessageBox.Show("断开连接失败!"); } else { icdev = 0; //MessageBox.Show("断开连接成功!"); } } private void cmdK3User_Click(object sender, EventArgs e) { DAL.ClsK3_User_View oUser = new DAL.ClsK3_User_View(); if (oUser.RefreshView()) { this.txtK3User.Text = oUser.oModel.HName; this.txtK3User.Tag = oUser.oModel.HItemID.ToString(); } else { this.txtK3User.Text = ""; } } private void txtK3User_TextChanged(object sender, EventArgs e) { if (txtK3User.Text.Length == 0) { txtK3User.Tag = "0"; } } private void jy_Click(object sender, EventArgs e) { Sub_Stop(); } private void hf_Click(object sender, EventArgs e) { Sub_UnStop(); } private void qk_Click(object sender, EventArgs e) { Sub_ClearCard(); } public void Sub_ClearCard() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { if (MessageBox.Show("确定要清卡内信息?此操作不可逆!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //得到HITEMID long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //判断存在性 if (oICCardHlp.GetInfoByID(sItemID)) { // if (oICCard.Sub_ClearCard(sItemID)) { //更新上级为 末级 MessageBox.Show("清卡项目成功!", "提示"); Display(); } else MessageBox.Show("清卡项目失败!" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } } } } } }