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("数据回盘", "更新本地数据库失败");
}
}
private int SaveData(string idcard, string carddata, string idcardType, string receipt)
{
//Status01,CGBZ02,SBYY03,KSDM04,YHKH05,KSBM06,ATR07,ShJPCH08,SJPCH09,CSMC10,
//CJJGZKPCH11,CJJGMC12,XZQHDM13,XZQHMC14,DWBH15,DWMC16,YXBJ17,KDLB18,GFBB19,
//CSHJGBM20,FKRQ21,KYXQ22,KH23,SGDBBH24,ZKZL25,RYCCSLDBM26,XM27,SHBZHM28,YHBM29,XB30,
//MZ31,CSRQ32,XMKZ33,CSD34,BHKBZ35,CSKSBM36,SGRSBH37,ZZMM38,CZDZ39,HKXZ40,
//HKSZD41,XL42,GRSF43,ZJLX44,ZJHM45,ZJYXQ46,ZJZZRQ47,LXDH48,GJ49,ZY50,
//HYLB51,JHRXM52,JHRXB53,JHRZJLX54,JHRZJHM55,JHRDZ56,JHRLXDH57,JYHKH58,YL1,YL2
AccessOperator Accor = new AccessOperator();
string sql = "SELECT [SHBZHM28] FROM ProductData WHERE [SHBZHM28]='" + idcard + "'";
DataTable dtread = Accor.ExecuteDataTable(sql);
if (dtread.Rows.Count > 0)
{
return(0);
}
string tableFields = "Status01,CGBZ02,SBYY03,KSDM04,YHKH05,KSBM06,ATR07,ShJPCH08,SJPCH09,CSMC10,CJJGZKPCH11,CJJGMC12,XZQHDM13,XZQHMC14,DWBH15,DWMC16,YXBJ17,KDLB18,GFBB19,CSHJGBM20,FKRQ21,KYXQ22,KH23,SGDBBH24,ZKZL25,RYCCSLDBM26,XM27,SHBZHM28,YHBM29,XB30,MZ31,CSRQ32,XMKZ33,CSD34,BHKBZ35,CSKSBM36,SGRSBH37,ZZMM38,CZDZ39,HKXZ40,HKSZD41,XL42,GRSF43,ZJLX44,ZJHM45,ZJYXQ46,ZJZZRQ47,LXDH48,GJ49,ZY50,HYLB51,JHRXM52,JHRXB53,JHRZJLX54,JHRZJHM55,JHRDZ56,JHRLXDH57,JYHKH58,YL1,YL2,FullDATA59,BY60,BY61,BY62";
string[] tabledata = tableFields.Split(',');
string[] data = carddata.Split('|');
string insertvalue = "'1','','','','','','','" + carddata.Replace("|", "','") + "','" + carddata + "','" + idcardType + "','" + receipt + "',''";
string strsql = "insert into ProductData (" + tableFields + ") values (" + insertvalue + ")";
int count = Accor.ExecuteNonQuery(strsql);
int ret = count > 0 ? 0 : -1; //插入成功或失败
return(ret);
}
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;
}