private void ReportResult(string name, string idcardType, string cardID, string receipt, string result) { string outstring; string strsql = ""; AccessOperator Accor = new AccessOperator(); //01身份证 MsgPutOut("数据回盘", "正在回盘数据,请耐心等待..."); string recode = TCPinterface.ReportResult(name, idcardType, cardID, receipt, result, out outstring); if (recode.Equals("0000")) { strsql = "UPDATE ProductData SET [Status01]='4' WHERE [SHBZHM28]='" + cardID + "'"; ucFlowChart1.SetStepStatus(4, true); MsgPutOut("数据回盘", "回盘成功"); } else { strsql = "UPDATE ProductData SET [Status01]='3' WHERE [SHBZHM28]='" + cardID + "'"; ucFlowChart1.SetStepStatus(4, false); MsgPutOut("数据回盘", "回盘失败:" + outstring); } int count = Accor.ExecuteNonQuery(strsql); if (count <= 0) { MsgPutOut("数据回盘", "更新本地数据库失败"); } }
public void btnSearchPersonInfo_Click(object sender, EventArgs e) { //查询制卡数据 if (String.Equals(txtIDNo.Text.Trim(), "身份证号") || String.Equals(tbName.Text.Trim(), "姓名")) { MessageBox.Show("【身份证号】【姓名】不能为空!"); return; } if (2 != cbChangeType.SelectedIndex && String.Equals(tbBankNo.Text.Trim(), "原银行卡号")) { MessageBox.Show("【原银行卡号】不能为空!"); return; } int ret; string recode = ""; string receipt = ""; string carddata = ""; string photodata = ""; AccessOperator Accor = new AccessOperator(); MsgPutOut("查询数据", "正在查询数据,请耐心等待..."); //查询业务单据号 recode = TCPinterface.CheckCardFees(tbName.Text.Trim(), strCertificateType, txtIDNo.Text.Trim(), changeType, tbBankNo.Text.Trim(), out receipt); if (!recode.Equals("0000")) { MsgPutOut("查询数据", "查询业务单据号失败:" + receipt); return; } recode = TCPinterface.SearchPersonInfo(tbName.Text.Trim(), strCertificateType, txtIDNo.Text.Trim(), changeType, tbBankNo.Text.Trim(), receipt, out carddata, out photodata); if (recode.Equals("0000")) { string[] data = carddata.Split('|'); ret = SaveData(data[20], carddata, strCertificateType, receipt); if (ret < 0) { MsgPutOut("查询数据", "保存个人数据失败"); return; } SavePhoto(photodata, data[20] + "_" + data[19]); RefreshTree(); MsgPutOut("查询数据", "查询成功"); } else { MsgPutOut("查询数据", carddata); } }
private void ProductCard(string name, string idcardType, string idNo, string receipt) { string ICdata = ""; string reportStr = ""; string strsql = ""; ICdata = TCPinterface.WriteICBaseData(name, idcardType, idNo, receipt) + "#" + GlobalClass.fulldata; AccessOperator Accor = new AccessOperator(); PrintParameter pp = new PrintParameter(); tvCardInit.Enabled = false; int ret = ProductExecute(pp, ICdata, out reportStr); if (ret != 0) { MsgPutOut("制作卡片", "制卡失败。错误:" + ret); strsql = "UPDATE ProductData SET [Status01]='2' WHERE [SHBZHM28]='" + idNo + "'"; int count = Accor.ExecuteNonQuery(strsql); if (count <= 0) { MsgPutOut("制作卡片", "更新本地数据库失败"); } } else { MsgPutOut("制作卡片", "制卡成功!"); string[] strrep = reportStr.Split('|'); strsql = "UPDATE ProductData SET [Status01]='3',[CGBZ02]='1',[SBYY03]='',[KSDM04]='" + strrep[0] + "',[YHKH05]='" + strrep[1] + "',[KSBM06]='" + strrep[2] + "',[ATR07]='" + strrep[3] + "' WHERE [SHBZHM28]='" + idNo + "'"; int count = Accor.ExecuteNonQuery(strsql); if (count <= 0) { MsgPutOut("制作卡片", "更新本地数据库失败"); } ReportResult(name, idcardType, idNo, receipt, reportStr); } RefreshTree(); tvCardInit.Enabled = true; }