private void button_CheckCard_Click(object sender, EventArgs e) { string szInf = ""; string sCardID = ""; DataSet odt = null; string sErrMsg = ""; if (!frm_Main.bHaveRd) { if (textBox_CardID.Text.Trim() != "") { sCardID = textBox_CardID.Text; } else { MessageBox.Show("没有连接读写器,也没有输入卡号,不能执行查询余额功能!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { if (!myRdr.ComOpen(frm_Main.sRdPort)) { myRdr.ComClose(); if (textBox_CardID.Text.Trim() != "") { sCardID = textBox_CardID.Text; } else { MessageBox.Show("打开串口失败!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } else { if (!myRdr.ReadCardInf(out szInf)) { if (textBox_CardID.Text.Trim() != "") { sCardID = textBox_CardID.Text; } else { MessageBox.Show("读卡失败!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); myRdr.ComClose(); goto Eend; } } else { sCardID = szInf.Substring(0, 16); } } myRdr.ComClose(); } textBox_CardID.Text = sCardID; if (sCardID.Substring(0, 1) == MyStart.gszCardFirmFirst) { MessageBox.Show("不接受商户卡查询余额,请换卡!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); goto Eend; } try { string sSql = ""; if (mszFlag.ToUpper() == "FIRM_CARD") { sSql = "SELECT * FROM mng_card WHERE STORE_CARD = '" + sCardID + "' AND card_type = 3"; } else // if (mszFlag.ToUpper() == "USER_CARD") { sSql = "SELECT * FROM base_ucard WHERE user_card = '" + sCardID + "'"; } int iRst = MyStart.oMyDb.ReadData(sSql, "TableA", ref odt, ref sErrMsg); if (iRst != 0) { MessageBox.Show("后台查询卡余额失败( " + sErrMsg + " )", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); goto Eend; } if (odt.Tables[0].Rows.Count <= 0) { if (mszFlag.ToUpper() == "FIRM_CARD") { MessageBox.Show("这是错误的商户结算卡,请更换。", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else // if (mszFlag.ToUpper() == "USER_CARD") { MessageBox.Show("没有此用户卡的信息,请更换。", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } goto Eend; } if (mszFlag.ToUpper() == "FIRM_CARD") { sUserName = odt.Tables[0].Rows[0]["STORE_PERSON"].ToString().Trim(); } else // if (mszFlag.ToUpper() == "USER_CARD") { sUserName = odt.Tables[0].Rows[0]["user_name"].ToString().Trim(); } //银石后台 objHttp = new EbHttpClass(); string szErr = ""; int iValue = 0; int iTrade = 0; int CardBalance = 0; float fi = 0.00f; if (mszFlag.ToUpper() == "FIRM_CARD") { iTrade = 1; } else { iTrade = 0; } bool bRst = objHttp.QryCard(sCardID, ref iValue, ref iTrade, ref szErr); if (!bRst) { MessageBox.Show("后台查询卡余额失败( " + szErr + " )", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //return; } else { if (mszFlag.ToUpper() == "FIRM_CARD") { fi = iValue; fi = fi / 100; textBox_FinishBalance.Text = fi.ToString("0.00"); if (iTrade > 0) { fi = iTrade; } else { fi = 0; } fi = fi / 100; textBox_UnFinishBalance.Text = fi.ToString("0.00"); CardBalance = iValue + iTrade; fi = CardBalance; fi = fi / 100; textBox_OldBalance.Text = fi.ToString("0.00"); MyFunc.WriteToDbLog("卖方资金-余额查询", " ", "MSG", MyStart.giUserID); } else { textBox_FinishBalance.Text = ""; textBox_UnFinishBalance.Text = ""; fi = iValue; fi = fi / 100; textBox_OldBalance.Text = fi.ToString("0.00"); MyFunc.WriteToDbLog("买方资金-余额查询", " ", "MSG", MyStart.giUserID); } if (checkBox1.Checked) { int i = 0; // 打印票据 MyTools.sPrintTopic = "余额查询票据"; MyTools.sPrintID = ""; MyTools.oPrintData = new string[10]; MyTools.oPrintData[i++] = "卡片号码:" + textBox_CardID.Text; MyTools.oPrintData[i++] = "持卡人名:" + sUserName; MyTools.oPrintData[i++] = "--------------------------------------"; MyTools.oPrintData[i++] = "可取金额:" + textBox_FinishBalance.Text; MyTools.oPrintData[i++] = "未结余额:" + textBox_UnFinishBalance.Text; MyTools.oPrintData[i++] = "合计余额:" + textBox_OldBalance.Text; MyTools.iPrintData = i; MyTools.PrintTicket(); } } } catch (Exception ex) { MessageBox.Show("查询失败 = " + ex.Message, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } Eend: if (odt != null) { odt.Clear(); } MyStart.oMyDb.Close(); button_CheckCard.Focus(); }
private void button_Save_Click(object sender, EventArgs e) { if (DialogResult.No == MessageBox.Show("请确认要保存该工作人员信息", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information)) { MessageBox.Show("取消当前保存操作", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string szNewPwd = MyTools.OpenString_To_HideString((textBox_pwd.Text + " ").Substring(0, 8), MyStart.gszPwdKey); string szSql; string szTitle; string szErr = ""; int iRst; string[] szItem = comboBox_Cert.Text.Split(','); try { if (textBox_login.Enabled)//add { szTitle = "工作人员基本信息-新增"; szSql = "select * from sys_users where USER_LOGIN='******'"; DataSet ds = new DataSet(); iRst = MyStart.oMyDb.ReadData(szSql, "tableA", ref ds, ref szErr); if (iRst < 0) { MessageBox.Show("查询信息出错(错误原因:" + szErr + ")", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); MyIniFile.WriteLog(szTitle, "SQL=" + szSql + ",Err=" + szErr); goto Eend; } if (ds.Tables[0].Rows.Count == 1) { MessageBox.Show("登录帐号不能重复,请重新输入", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); MyIniFile.WriteLog(szTitle, "SQL=" + szSql + ",Err=登录帐号不能重复,请重新输入"); textBox_login.SelectAll(); textBox_login.Focus(); goto Eend; } szSql = "INSERT INTO sys_users(USER_LOGIN,USER_PWD,USER_TYPE,USER_NAME,USER_SEX,USER_BIRTH,CERT_TYPE,CERT_ID," + "USER_ADDR,USER_DPT,USER_POS,USER_TEL,USER_MOBILE,CITY,RMRK,USER_STAT,ADD_DT,USER_APP) VALUES " + "('" + textBox_login.Text.Trim() + "','" + szNewPwd + "',2,'" + textBox_Name.Text.Trim() + "','" + comboBox_Sex.Text.Trim() + "','" + dateTimePicker_birth.Value + "'," + Convert.ToInt16(szItem[0]) + ",'" + textBox_Cert.Text.Trim() + "','" + textBox_Addr.Text.Trim() + "','" + textBox_Dpt.Text.Trim() + "','" + textBox_Position.Text.Trim() + "','" + textBox_Tel.Text.Trim() + "','" + textBox_Cell.Text.Trim() + "','ZHONGSHAN','" + textBox_Desc.Text.Trim() + "','USED',curtime(),'000000000000000000000000000000001')"; } else//edit { szTitle = "工作人员基本信息-修改"; szSql = "UPDATE sys_users SET USER_PWD = '" + szNewPwd + "',USER_SEX = '" + comboBox_Sex.Text.Trim() + "',USER_BIRTH = '" + dateTimePicker_birth.Value + "',CERT_TYPE = " + Convert.ToInt16(szItem[0]) + ",CERT_ID = '" + textBox_Cert.Text.Trim() + "',USER_ADDR = '" + textBox_Addr.Text.Trim() + "',USER_DPT = '" + textBox_Dpt.Text.Trim() + "',USER_POS = '" + textBox_Position.Text.Trim() + "',USER_TEL = '" + textBox_Tel.Text.Trim() + "',USER_MOBILE = '" + textBox_Cell.Text.Trim() + "',RMRK = '" + textBox_Desc.Text.Trim() + "' WHERE USER_ID=" + textBox_Code.Text.Trim(); } iRst = MyStart.oMyDb.WriteData(szSql, ref szErr); if (iRst < 1) { MessageBox.Show("保存出错(错误原因:" + szErr + ")", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); MyIniFile.WriteLog(szTitle, "SQL=" + szSql + ",Err=" + szErr); } else { szSql = "编号" + mszCode + "-姓名" + mszName; MyFunc.WriteToDbLog(szTitle, szSql, "MSG", MyStart.giUserID); MessageBox.Show("保存成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); GridDataRefresh(); //dataGridView1.Refresh(); MyIniFile.WriteLog(szTitle, "SQL=" + szSql + ",OK"); } groupBoxInf.Enabled = false; groupBoxList.Enabled = true; textBox_Code.Text = mszCode; textBox_Name.Text = mszName; textBox_Desc.Text = mszInf; } catch (Exception ex) { MessageBox.Show("保存失败( " + ex.Message + " )", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } Eend: MyStart.oMyDb.Close(); }