public CardEventArgsRegist() { _value = new CardData(); }
public CardEventArgsRegist(CardData value) { this._value = value; }
void HandleCardData(CardData data) { tbValue.Text = data.CarNo; tbID.Text = data.ID; }
public CardEventArgs() { _value = new CardData(); }
private void ReadCard(CardData cardData) { if (!_isReadCard) return; _isReadCard = false; txtCardNo.Text = cardData.CardNo; this._dischargeflag = cardData.UnloadFlag; if (!string.IsNullOrEmpty(txtCardNo.Text.Trim())) { //由卡号带出绑定的车号 string sql = "select t.fs_sequenceno,t.FS_BINDCARNO from BT_CARDMANAGE t where t.fs_sequenceno='" + cardData.CardNo + "'"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.dbComm.DBComm"; ccp.MethodName = "queryBySql"; ccp.ServerParams = new object[] { sql, new ArrayList() }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); if (dt.Rows.Count == 0) { MessageBox.Show("该卡还未注册,不能使用!"); return; } else { txtCardNo.Text = cardData.CardNo; //查找进厂记录 string sql2 = "select t.fs_carno from dt_enterfacrecord t where t.fs_cardnumber = '"+cardData.CardNo+"' and nvl(t.fn_enterfacflag,1) = 1"; DataTable dt2 = new DataTable(); CoreClientParam ccp2 = new CoreClientParam(); ccp2.ServerName = "com.dbComm.DBComm"; ccp2.MethodName = "queryBySql"; ccp2.ServerParams = new object[] { sql2, new ArrayList() }; ccp2.SourceDataTable = dt2; this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal); if (dt2.Rows.Count > 0) { string carNo = dt2.Rows[0]["FS_CARNO"].ToString(); if (!string.IsNullOrEmpty(carNo) && carNo.Length > 1) { if (carNo.Length == 7) { this.cbCH.Text = carNo.Substring(0, 2); this.tbCarNo.Text = carNo.Substring(2); } else if (carNo.Length == 8) { this.cbCH.Text = carNo.Substring(0, 3); this.tbCarNo.Text = carNo.Substring(3); } else { this.cbCH.Text = carNo.Substring(0, 1); this.tbCarNo.Text = carNo.Substring(1); } //自动出厂 /* if (ultraCheckEditor2.Checked) { LetGo(); }*/ } //return; } string text = dt.Rows[0]["FS_BINDCARNO"].ToString(); if (!string.IsNullOrEmpty(text) && text.Length > 1) { if (text.Length == 7) { this.cbCH.Text = text.Substring(0, 2); this.tbCarNo.Text = text.Substring(2); } else if (text.Length == 8) { this.cbCH.Text = text.Substring(0, 3); this.tbCarNo.Text = text.Substring(3); } else { this.cbCH.Text = text.Substring(0, 1); this.tbCarNo.Text = text.Substring(1); } } /* else { this.cbCH.Text = ""; this.tbCarNo.Text = ""; }*/ if (checkBox1.Checked) { LetGo(); } } } System.Threading.Thread th = new System.Threading.Thread(resetReadStatus); th.Start(); }
private void button4_Click(object sender, EventArgs e) { if (_measApp != null && _measApp.Card != null) { DataTable dt = new DataTable(); _carWeightDatamanage.GetCardData(weighEditorControl1.CardNo, weighEditorControl1.CarNo, dt); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; _cardData = new CardData(); _cardData.CarNo = dr["FS_CARNO"].ToString(); ; _cardData.MateriaName = dr["FS_MATERIALNAME"].ToString(); _cardData.Receiver = dr["FS_SHDW"].ToString(); _cardData.Sender = dr["FS_FHDW"].ToString(); _cardData.PlanLoc = dr["FS_RECEIVERFACTORY"].ToString(); _cardData.UnloadFlag = " "; _cardData.UnloadKZ = " "; _cardData.WgtOpCd = dr["FS_WEIGHTNO"].ToString(); _cardData.FirLocNo = dr["FS_POUND"].ToString(); _cardData.FirWeight = dr["FN_WEIGHT"].ToString() + "t"; _cardData.SecLocNo = " "; _cardData.SecWeight = " "; if (_measApp.Card.WriteCard(_cardData)) { MessageBox.Show("补写成功!"); weighEditorControl1.lblStatus.ForeColor = Color.Black; weighEditorControl1.WeighStatus = ""; } else { MessageBox.Show("补写失败!"); } } else { _measApp.Card.ClearCard(); } } }
public void Save() { try { if (weighEditorControl1.CheckInput()) { this.Cursor = Cursors.WaitCursor; //meterControl1.Weight = 15; double weight = meterControl1.Weight; if (_measApp != null && _measApp.Weight != null) { _measApp.Weight._receiveFlag = false; } string message = ""; bool isAffirm = true; bool isNeedDischarge = weighEditorControl1.IsNeedDischarge; if (weighEditorControl1.Flow.Equals("001")) { isNeedDischarge = true; } if (!_carWeightDatamanage.CheckWeighHistory(weighEditorControl1.CarNo, weight, weighEditorControl1.Flow, isNeedDischarge, weighEditorControl1.DischargeFlag,weighEditorControl1.AlowTareWeight, out message,out isAffirm)) { if (!isAffirm) { MessageBox.Show(message, "提示"); Cursor = Cursors.Default; if (_measApp != null && _measApp.Weight != null) { _measApp.Weight._receiveFlag = true; } return; } if (MessageBox.Show(message, "提示", MessageBoxButtons.YesNo) == DialogResult.No) { Cursor = Cursors.Default; if (_measApp != null && _measApp.Weight != null) { _measApp.Weight._receiveFlag = true; } return; } } button1.Enabled = false; messForm.SetMessage("正在计量,请稍候!"); //期限皮重更新上次扣渣量 if (weighEditorControl1.CardWeightNo.EndsWith("H") && weighEditorControl1.DischargeFlag.Equals("1")) { Hashtable ht = new Hashtable(); ht.Add("I1", weighEditorControl1.DischargeFlag); ht.Add("I2", weighEditorControl1.Discharger); ht.Add("I3", weighEditorControl1.DischargeTime); ht.Add("I4", weighEditorControl1.CardDedution); ht.Add("I5", weighEditorControl1.CardWeightNo); ht.Add("I6", "");//预留 ht.Add("I7", "");//预留 ht.Add("O8", ""); ht.Add("O9", ""); string[] res = _carWeightDatamanage.SaveCardDischarge(ht); } Hashtable param = new Hashtable(); param.Add("I1", weighEditorControl1.CardNo); param.Add("I2", weighEditorControl1.CarNo); param.Add("I3", weighEditorControl1.StoveNo1); param.Add("I4", weighEditorControl1.StoveNo2); param.Add("I5", weighEditorControl1.StoveNo3); param.Add("I6", weighEditorControl1.OrderNo); param.Add("I7", weighEditorControl1.OrderSeq); param.Add("I8", weighEditorControl1.IsTermTare ? "1" : "0"); param.Add("I9", weighEditorControl1.StoveCount1); param.Add("I10", weighEditorControl1.StoveCount2); param.Add("I11", weighEditorControl1.StoveCount3); param.Add("I12", weighEditorControl1.Material); param.Add("I13", weighEditorControl1.MaterialName); param.Add("I14", weighEditorControl1.Flow); param.Add("I15", weighEditorControl1.TransCompany); param.Add("I16", weighEditorControl1.SendCompany); param.Add("I17", weighEditorControl1.ReceiveCompany); param.Add("I18", weighEditorControl1.SendPlace); param.Add("I19", weighEditorControl1.DischargePlace); param.Add("I20", weighEditorControl1.WeightType); param.Add("I21", weighEditorControl1.Cost); param.Add("I22", weighEditorControl1.Deduction); param.Add("I23", weighEditorControl1.BillNo); param.Add("I24", weighEditorControl1.IsMultiMaterials ? "1" : "0"); param.Add("I25", weighEditorControl1.SenderWeight); param.Add("I26", UserInfo.GetUserID()); param.Add("I27", UserInfo.GetUserOrder()); param.Add("I28", UserInfo.GetUserGroup()); param.Add("I29", weighEditorControl1.PointCode); param.Add("I30", weighEditorControl1.PointName); param.Add("I31", weighEditorControl1.Remark); param.Add("I32", weight.ToString()); param.Add("I33", weighEditorControl1.TransPlanNo); param.Add("I34", weighEditorControl1.DischargeFlag); param.Add("I35", !string.IsNullOrEmpty(weighEditorControl1.DischargeFlag) ? weighEditorControl1.Discharger : ""); if (!string.IsNullOrEmpty(weighEditorControl1.DischargeFlag)) { try { DateTime.ParseExact(weighEditorControl1.DischargeTime, "yyyyMMddHHmmss", null).ToString("yyyyMMddHHmmss"); param.Add("I36", !string.IsNullOrEmpty(weighEditorControl1.DischargeFlag) ? weighEditorControl1.DischargeTime : ""); } catch(Exception ee) { param.Add("I36", !string.IsNullOrEmpty(weighEditorControl1.DischargeFlag) ? System.DateTime.Now.ToString("yyyyMMddHHmmss") : ""); string p_UPDATER = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(); string strDate = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); string strIP = _baseInfo.getIPAddress(); string strMAC = _baseInfo.getMACAddress(); //string p_UPDATER = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName(); _baseInfo.insertLog(strDate, "汽车", p_UPDATER, strIP, strMAC, "", weighEditorControl1.CarNo, weighEditorControl1.TareWeight.ToString(), weighEditorControl1.DischargeTime, "", "", "DT_CARWEIGHT_WEIGHT", "汽车衡过磅/手持时间错误"); } } if(string.IsNullOrEmpty(weighEditorControl1.DischargeFlag)) { param.Add("I36",""); } ////param.Add("I36", !string.IsNullOrEmpty(weighEditorControl1.DischargeFlag) ? weighEditorControl1.DischargeTime : ""); param.Add("I37", !string.IsNullOrEmpty(weighEditorControl1.DischargeFlag) ? weighEditorControl1.DischargeDepart : ""); param.Add("I38", (int)weighEditorControl1.TermTareType); param.Add("I39", weighEditorControl1.SenderGrosssWeight); param.Add("I40", weighEditorControl1.SenderTareWeight); param.Add("O41", ""); param.Add("O42", ""); param.Add("O43", ""); string[] result = _carWeightDatamanage.SaveWeightData(param); //string debugInfo = ""; //for (int i = 1; i != 40;i++ ) //{ // debugInfo += "I" + i + "=" + param["I" + i].ToString() + ","; //} //Log.Debug("SaveWeightData: point:"+weighEditorControl1.PointName+ ",params:" + debugInfo); if (string.IsNullOrEmpty(result[0]) || result[0].Trim().Equals("0")) { _preWeightNo = result[1]; //MessageBox.Show("计量完成!"); //语音电铃截图LCD显示 if (_measApp != null) { if (_measApp.Rtu != null) { _measApp.Rtu.OpenRing(); Log.Debug("carweight.save() : RTU End!"); } if (_measApp.Card != null && !string.IsNullOrEmpty(weighEditorControl1.CardNo)) { _cardData = new CardData(); _cardData.CarNo = weighEditorControl1.CarNo; _cardData.MateriaName = weighEditorControl1.MaterialName; _cardData.Receiver = weighEditorControl1.ReceiveCompanyName; _cardData.Sender = weighEditorControl1.SendCompanyName; _cardData.PlanLoc = weighEditorControl1.DischargePlace; _cardData.UnloadFlag = " "; _cardData.UnloadKZ = " "; _cardData.WgtOpCd = result[1]; if (!string.IsNullOrEmpty(result[1]) && result[1].EndsWith("H")) { //_cardData.SecLocNo = weighEditorControl1.PointName; //_cardData.SecWeight = weight.ToString()+"t"; _cardData.FirLocNo = " "; _cardData.FirWeight = " "; _cardData.CarNo = " "; _cardData.MateriaName = " "; _cardData.Receiver = " "; _cardData.Sender = " "; _cardData.PlanLoc = " "; } else { _cardData.FirLocNo = weighEditorControl1.PointName; _cardData.FirWeight = weight.ToString() + "t"; _cardData.SecLocNo = " "; _cardData.SecWeight = " "; } //Thread th = new Thread(ThreadWrite); //th.Start(); try { ThreadWrite(); } catch (Exception e) { } Log.Debug("carweight.save() : IcCard End!"); } if (_measApp.Lcd != null) { ShowLcd(); Log.Debug("carweight.save() : Lcd End!"); } if (_measApp.Dvr != null) { bool talked = false; if (_isTalk) { talked = true; _measApp.Dvr.StopTalk(); _isTalk = false; ultraToolbarsManager1.Toolbars[0].Tools["YYDJ"].SharedProps.Caption = "打开对讲"; } if (_isReWriteCard) { _measApp.Dvr.SendVoiceData(_curPath + "\\sound\\刷卡失败 请重新刷卡.wav"); weighEditorControl1.lblStatus.ForeColor = Color.Red; weighEditorControl1.WeighStatus = "写卡失败,请让司机插卡,然后点击界面上的“补写”按钮!"; } else _measApp.Dvr.SendVoiceData(_curPath + "\\qcsound\\计量完成.wav"); Log.Debug("carweight.save() : DVR Send Voice End!"); //if (talked) //{ // Thread.Sleep(200); // _isTalk = _measApp.Dvr.StartTalk(); // if (_isTalk) // { // ultraToolbarsManager1.Toolbars[0].Tools["YYDJ"].SharedProps.Caption = "关闭对讲"; // } //} Capture(weighEditorControl1.PointCode, result[1], weight); Log.Debug("carweight.save() : DVR Capture End!"); } } //采购进厂或二次计量自动打印 if (ultraCheckEditor1.Checked && (weighEditorControl1.Flow.Equals("001") || _preWeightNo.EndsWith("H"))) { Log.Debug("carweight.save() : Printer Begin!"); Print(); Log.Debug("carweight.save() : Printer End!"); } string strStatus = weighEditorControl1.WeighStatus; weighEditorControl1.Clear(); if (strStatus.Contains("补写")) { weighEditorControl1.WeighStatus = strStatus; } weighEditorControl1.CardNo = ""; weighEditorControl1.CarNo = ""; //_series[m_iSelectedPound].Points.Clear(); //NumericDataPoint np = new NumericDataPoint(); //np.Value = 0; //_series[m_iSelectedPound].Points.Add(np); //加载一次计量数据 _carWeightDatamanage.GetFirstWeighData(this.dataTable11, "", ""); _dtFirstWeighData = dataTable11.Copy(); ultraGrid3.DataSource = _dtFirstWeighData; SetFirstPicVisible(false); _measApp.IsSaved = true;//保存标识 button1.Enabled = false; messForm.Visible = false; } if (!string.IsNullOrEmpty(result[2])) { MessageBox.Show(_isReWriteCard ? (result[2] + " 请补写卡!") : result[2]); } weighEditorControl1.Focus(); Cursor = Cursors.Default; } } catch (Exception ex) { Log.Error("carweigh.save() : " + ex.Message); } catch { Log.Error("carweigh.save() Error!"); } finally { if (_measApp != null && _measApp.Weight != null) { _measApp.Weight._receiveFlag = true; ; } } }
private void HandleCardChange(CardData data) { weighEditorControl1.CardNo = data.CardNo.Trim(); //weighEditorControl1.CarNo = data.CarNo.Trim(); weighEditorControl1.DischargeFlag = data.UnloadFlag.Trim(); if (!string.IsNullOrEmpty(weighEditorControl1.DischargeFlag)) { weighEditorControl1.CardWeightNo = data.WgtOpCd.Trim(); weighEditorControl1.Discharger = data.UnloadName.Trim(); weighEditorControl1.DischargeTime = data.UnloadTime.Trim(); weighEditorControl1.DischargeDepart = data.UnloadDepart.Trim(); if (weighEditorControl1.DischargeFlag.Equals("1")) { //历史记录不显示扣渣量 if (!weighEditorControl1.CardWeightNo.EndsWith("H")) { double kz = 0; double.TryParse(data.UnloadKZ.Trim(), out kz); weighEditorControl1.Deduction = kz; } else { weighEditorControl1.CardDedution = data.UnloadKZ.Trim(); } } } weighEditorControl1.CardWeightNo = data.WgtOpCd.Trim(); _carWeightDatamanage.GetTransPlan(weighEditorControl1.DT_TransPlan, weighEditorControl1.CardNo, "", weighEditorControl1.IFYBFirst); weighEditorControl1.BandTransPlan(); //DataRow dr = weighEditorControl1.DT_TransPlan.Rows.Count > 0 ? weighEditorControl1.DT_TransPlan.Rows[0] : null; //if (dr != null && !string.IsNullOrEmpty(dr["FS_CARNO"].ToString()) && string.IsNullOrEmpty(weighEditorControl1.CarNo)) //{ // weighEditorControl1.CarNo = dr["FS_CARNO"].ToString(); //} //显示车辆过磅信息 weighEditorControl1.WeighStatus = _carWeightDatamanage.GetWeightStatus(weighEditorControl1.CarNo, (!string.IsNullOrEmpty(weighEditorControl1.DischargeFlag)) && weighEditorControl1.DischargeFlag.Equals("1")); SetFirstPicVisible(true); Log.Debug("CardInfo = cardNo:" + weighEditorControl1.CardNo + ",carNo:" + weighEditorControl1.CarNo + ",cardWeightNo:" + weighEditorControl1.CardWeightNo + ",dischargeFlag:" + weighEditorControl1.DischargeFlag + ",discharger:" + weighEditorControl1.Discharger + ",dischargeTime:" + weighEditorControl1.DischargeTime); }
private void RegistCard() { String czkh = textCZKH.Text; //车证卡芯片号 String czkxlh = textCZKXLH.Text;//车证卡编号 String fpr = textFPR.Text; //分配人(分配给谁用) String fpdw = comboFPDW.Text; //分配单位(对卸货身份卡而言,就是卸货点所属单位) //String yt = textYT.Text; String jb = ""; //车证卡级别(卸货卡,身份卡,临时卡) String strXb = comboSex.Text.Trim(); String strGwei = comboGwei.Text.Trim();//岗位(对卸货身份卡而言,就是权限 卸货员/管理员) String strBmen = comboBmen.Text.Trim(); String strSfzh = textSFZH.Text.Trim();//身份证号 String strLxdh = textLXDH.Text.Trim();//联系电话 try { jb = comboJB.SelectedValue.ToString();//车证卡级别 } catch (Exception ee1) { } String jbname = comboJB.Text.ToString(); String yt = ""; //用途 String bz = textBZ.Text;//备注 //卡号不可编辑 //以下为注册车证卡确认时更新相关信息代码 rowno = -1;//防止应该注册的操作,去操作其他按钮 if (!textCZKXLH.Enabled) { MessageBox.Show("还未读卡,请先读卡!");//车证卡芯片序列号 return; } czkh = textCZKH.Text.Trim(); czkxlh = textCZKXLH.Text.Trim(); if (czkh == null || czkh.Equals("")) { MessageBox.Show("没有车证卡芯片信息,请刷卡!"); return; } if (czkxlh == null || czkxlh.Equals("")) { MessageBox.Show("请输入车证卡号!"); return; } if (czkxlh.Length != 5) { MessageBox.Show("车证卡号必须为5位数字编号!"); return; } try { int.Parse(czkxlh); } catch (Exception ee2) { MessageBox.Show("车证卡号必须为5位数字编号!"); return; } if (!checkInputValue()) { return; } DateTime zzsj = System.DateTime.Now; String sxbz_str = "1";//生效标志位 DataTable testdatatable = new DataTable();//测试输入的卡号和芯片号是否已经存在 String isExistsql = "select t.FS_SEQUENCENO from BT_CARDMANAGE t where t.FS_SEQUENCENO='" + czkxlh + "'"; CoreClientParam selectccp = new CoreClientParam(); selectccp.ServerName = "ygjzjl.carcard.CarCard"; selectccp.MethodName = "queryByClientSql"; selectccp.ServerParams = new object[] { isExistsql }; selectccp.SourceDataTable = testdatatable; this.ExecuteQueryToDataTable(selectccp, CoreInvokeType.Internal); if (testdatatable.Rows.Count > 0) { MessageBox.Show("该序列号已经存在,不能注册!"); return; } testdatatable.Clear();//若该卡号不存在,则清空临时表testdatatable,并继续用其验证芯片号是否存在 isExistsql = "select t.FS_CARDNUMBER from BT_CARDMANAGE t where t.FS_CARDNUMBER='" + czkh + "'"; //CoreClientParam selectccp = new CoreClientParam(); selectccp.ServerName = "ygjzjl.carcard.CarCard"; selectccp.MethodName = "queryByClientSql"; selectccp.ServerParams = new object[] { isExistsql }; selectccp.SourceDataTable = testdatatable; this.ExecuteQueryToDataTable(selectccp, CoreInvokeType.Internal); if (testdatatable.Rows.Count > 0) { if (DialogResult.No == MessageBox.Show("芯片号:" + czkh + "的车证卡已经注册,要更新吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Information)) { textCZKXLH.Text = ""; textCZKH.Text = ""; textCZKXLH.Enabled = false;//设置为不可编辑 return; } else //如果确定要更新已经注册的车证卡(芯片号已经存在,允许修改车证卡编号) { CardData cardData = new CardData(); cardData.CardNo = czkxlh; if (checkBox1.Checked && _icCard.CardThread.ThreadState == System.Threading.ThreadState.Running) { _icCard.CardThread.Suspend(); } switch (comboJB.Text.Trim()) { case "身份卡": cardData.CardType = "0"; if (string.IsNullOrEmpty(fpr.Trim())) { MessageBox.Show("请选择分配人!"); return; } cardData.FirLocNo = fpr.Trim(); if (string.IsNullOrEmpty(strGwei.Trim())) { MessageBox.Show("请选择岗位!"); return; } cardData.FirWeight = strGwei.Trim(); if (string.IsNullOrEmpty(fpdw.Trim())) { MessageBox.Show("请选择分配单位!"); return; } cardData.MateriaName = fpdw.Trim(); break; case "计量卡": cardData.CardType = "1"; break; case "临时卡": cardData.CardType = "2"; break; default: MessageBox.Show("请选择车证卡类型!"); return; } bool flag = _icCard.WriteCard(cardData);//写卡操作 if (checkBox1.Checked && _icCard.CardThread.ThreadState == System.Threading.ThreadState.Suspended) { _icCard.CardThread.Resume(); } if (!flag) { MessageBox.Show("车证卡号没有成功写入卡内扇区,请确认卡放置正确!"); textCZKXLH.Text = ""; textCZKH.Text = ""; textCZKXLH.Enabled = false; return; } //String manageinsertsql = "update BT_CARDMANAGE t set t.FS_SEQUENCENO='" + czkxlh + "',t.FS_INITDEPART='" + departmentcode + "',t.FS_INITUSER='******',t.FD_INITTIME=TO_DATE('" + zzsj + "','YYYY-MM-DD HH24:MI:SS'),t.FS_USEPURPOSE='" + yt + "',t.FS_MEMO='" + bz + "',t.FS_CARDLEVEL='" + jb + "',t.FS_ISVALID='" + sxbz_str + "' where t.FS_CARDNUMBER='" + czkh + "'"; String manageinsertsql = @"update BT_CARDMANAGE t set t.FS_SEQUENCENO='" + czkxlh + @"', t.FS_INITDEPART='" + departmentcode + @"', t.FS_INITUSER='******', t.FD_INITTIME=TO_DATE('" + zzsj + @"','YYYY-MM-DD HH24:MI:SS'), t.FS_USEPURPOSE='" + yt + @"', t.FS_MEMO='" + bz + @"', t.FS_CARDLEVEL='" + jb + @"', t.FS_ISVALID='" + sxbz_str + @"' , t.FS_ASSIGNDEPART ='" + fpdw + @"', t.FS_ASSIGNUSER ='******' where t.FS_CARDNUMBER='" + czkh + @"'"; CoreClientParam reccp = new CoreClientParam(); reccp.ServerName = "ygjzjl.carcard.CarCard"; reccp.MethodName = "updateByClientSql"; reccp.ServerParams = new object[] { manageinsertsql }; this.ExecuteNonQuery(reccp, CoreInvokeType.Internal); if (reccp.ReturnCode == 0) //更新成功 { MessageBox.Show("车证卡更新成功!"); DataRow newczkrow = this.dataSet1.Tables["车证卡基础表"].NewRow(); newczkrow["FS_CARDNUMBER"] = czkh; newczkrow["FS_SEQUENCENO"] = czkxlh; newczkrow["FS_INITDEPART"] = departmentcode; newczkrow["FS_INITUSER"] = username; newczkrow["FD_INITTIME"] = zzsj.ToString(); newczkrow["FS_USEPURPOSE"] = yt; newczkrow["FS_MEMO"] = bz; newczkrow["FS_CARDLEVEL"] = jb; newczkrow["FS_CARDLEVELNAME"] = jbname; newczkrow["FS_ISVALID"] = sxbz_str; newczkrow["FS_ISVALIDNAME"] = "注册"; this.dataSet1.Tables["车证卡基础表"].Rows.Add(newczkrow); dataSet1.AcceptChanges(); //以上为注册车证卡确认时更新相关信息代码 //车证卡操作表(车证卡操作日志) String operationNO = Guid.NewGuid().ToString(); String insertsql = "insert into DT_CARDOPERATION(FS_OPERATENO,FS_SEQUENCENO,FS_CARDNO,FS_APPLYDEPART,FS_APPLYUSER,FS_OPERATIONTYPE,FS_OPERATEDEPART,FS_OPERATOR,FD_OPERATIONTIME) values ('" + operationNO + "','" + czkxlh + "','" + czkh + "','','','更新','" + departmentcode + "','" + username + "',TO_DATE('" + zzsj + "','YYYY-MM-DD HH24:MI:SS'))"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.carcard.CarCard"; ccp.MethodName = "insertByClientSql"; ccp.ServerParams = new object[] { insertsql }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //车证卡操作表 } textCZKXLH.Enabled = false;//注册完后,设置为不可编辑 } } else//不存在,则插入(卡号和芯片号均不存在) { CardData cardData = new CardData(); cardData.CardNo = czkxlh; //车证卡编号 if (checkBox1.Checked && _icCard.CardThread.ThreadState == System.Threading.ThreadState.Running) { _icCard.CardThread.Suspend(); //如果(自动读卡&&线程正在运行)则挂起ic卡线程,等待写卡操作 } switch (comboJB.Text.Trim()) { case "身份卡": cardData.CardType = "0"; if (string.IsNullOrEmpty(fpr.Trim())) { MessageBox.Show("请填写分配人!"); return; } cardData.FirLocNo = fpr.Trim(); if (string.IsNullOrEmpty(strGwei.Trim())) { MessageBox.Show("请选择岗位!"); return; } cardData.FirWeight = strGwei.Trim(); //在此处添加分配单位(卸货身份卡:卸货地点) if (string.IsNullOrEmpty(fpdw.Trim())) { MessageBox.Show("请选择分配单位!"); return; } cardData.MateriaName = fpdw.Trim();//写卡到 Scetor2 扇区 break; case "计量卡": cardData.CardType = "1"; break; case "临时卡": cardData.CardType = "2"; break; default: MessageBox.Show("请选择车证卡类型!"); return; } bool flag = _icCard.WriteCard(cardData);//执行写卡操作,并返回写卡成功true(失败false)标志 if (checkBox1.Checked && _icCard.CardThread.ThreadState == System.Threading.ThreadState.Suspended) { _icCard.CardThread.Resume(); //继续已挂起的线程 } if (!flag) { MessageBox.Show("车证卡号没有成功写入卡内扇区,请确认卡放置正确或者是否同一张卡!"); textCZKXLH.Text = ""; textCZKH.Text = ""; textCZKXLH.Enabled = false; return; } //String manageinsertsql = "insert into BT_CARDMANAGE t(t.FS_CARDNUMBER,t.FS_SEQUENCENO,t.FS_INITDEPART,t.FS_INITUSER,t.FD_INITTIME,t.FS_USEPURPOSE,t.FS_MEMO,t.FS_CARDLEVEL,t.FS_ISVALID) values ('" + czkh + "','" + czkxlh + "','" + departmentcode + "','" + username + "',TO_DATE('" + zzsj + "','YYYY-MM-DD HH24:MI:SS'),'" + yt + "','" + bz + "','" + jb + "','" + sxbz_str + "')"; String manageinsertsql = @"insert into BT_CARDMANAGE t ( t.FS_CARDNUMBER, t.FS_SEQUENCENO, t.FS_INITDEPART, t.FS_INITUSER, t.FD_INITTIME, t.FS_USEPURPOSE, t.FS_MEMO, t.FS_CARDLEVEL, t.FS_ISVALID, t.FS_ASSIGNDEPART, t.FS_ASSIGNUSER ) values ( '" + czkh + @"', '" + czkxlh + @"', '" + departmentcode + @"', '" + username + @"', TO_DATE('" + zzsj + @"','YYYY-MM-DD HH24:MI:SS'), '" + yt + @"', '" + bz + @"', '" + jb + @"', '" + sxbz_str + @"', '" + fpdw + @"', '" + fpr + @"' )"; CoreClientParam reccp = new CoreClientParam(); reccp.ServerName = "ygjzjl.carcard.CarCard"; reccp.MethodName = "insertByClientSql"; reccp.ServerParams = new object[] { manageinsertsql }; this.ExecuteNonQuery(reccp, CoreInvokeType.Internal); if (reccp.ReturnCode == 0) //插入成功 { MessageBox.Show("车证卡注册成功!"); DataRow newczkrow = this.dataSet1.Tables["车证卡基础表"].NewRow(); newczkrow["FS_CARDNUMBER"] = czkh; newczkrow["FS_SEQUENCENO"] = czkxlh; newczkrow["FS_INITDEPART"] = departmentcode; newczkrow["FS_INITUSER"] = username; newczkrow["FD_INITTIME"] = zzsj.ToString(); newczkrow["FS_USEPURPOSE"] = yt; newczkrow["FS_MEMO"] = bz; newczkrow["FS_CARDLEVEL"] = jb; newczkrow["FS_CARDLEVELNAME"] = jbname; newczkrow["FS_ISVALID"] = sxbz_str; newczkrow["FS_ISVALIDNAME"] = "注册"; //Ksh增加对分配人和分配单位字段的刷新 newczkrow["FS_ASSIGNDEPART"] = fpdw; newczkrow["FS_ASSIGNUSER"] = fpr; this.dataSet1.Tables["车证卡基础表"].Rows.Add(newczkrow); dataSet1.AcceptChanges(); //以上为注册车证卡确认时更新相关信息代码 //车证卡操作表(车证卡操作日志) String operationNO = Guid.NewGuid().ToString(); String insertsql = "insert into DT_CARDOPERATION(FS_OPERATENO,FS_SEQUENCENO,FS_CARDNO,FS_APPLYDEPART,FS_APPLYUSER,FS_OPERATIONTYPE,FS_OPERATEDEPART,FS_OPERATOR,FD_OPERATIONTIME) values ('" + operationNO + "','" + czkxlh + "','" + czkh + "','','','注册','" + departmentcode + "','" + username + "',TO_DATE('" + zzsj + "','YYYY-MM-DD HH24:MI:SS'))"; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "ygjzjl.carcard.CarCard"; ccp.MethodName = "insertByClientSql"; ccp.ServerParams = new object[] { insertsql }; this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); //车证卡操作表 } textCZKXLH.Enabled = false;//注册完后,设置为不可编辑 } }