public static void Exec(Pro_ShipDevice_Card_New_Mod info, out UInt16 resultNum, out string reason) { Database db = DataConnect.GetConnect; DbCommand cmd = db.GetStoredProcCommand("PRO_SHIPDEVICE_CARD_NEW"); db.AddInParameter(cmd, ":pi_devid", DbType.String, info.Pi_DevId); db.AddInParameter(cmd, ":pi_devtime", DbType.Date, info.Pi_DevTime); db.AddInParameter(cmd, ":pi_sfzh", DbType.String, info.Pi_SFZH); db.AddInParameter(cmd, ":pi_name", DbType.String, info.Pi_Name); db.AddOutParameter(cmd, ":po_ret", DbType.String, 256); db.AddOutParameter(cmd, ":po_content", DbType.String, 256); db.ExecuteNonQuery(cmd); string Result = db.GetParameterValue(cmd, ":po_ret").ToString(); if (string.IsNullOrEmpty(Result)) { resultNum = 1; } else { resultNum = Convert.ToUInt16(Result); } reason = db.GetParameterValue(cmd, ":po_content").ToString(); }
/// <summary> /// 56字节处理程序。 /// </summary> /// <param name="content"></param> private void Single_56(byte[] content) { Pro_ShipDevice_Card_New_Mod info = new Pro_ShipDevice_Card_New_Mod(); info.Pi_DevId = StationId.ToString(); info.Pi_DevTime = ConverUtil.Time(content, 0); //设备时间 info.Pi_Name = Encoding.Default.GetString(ConverUtil.Byte_Q(content, 6, 30)).Replace("\0", ""); //姓名 info.Pi_SFZH = Encoding.ASCII.GetString(ConverUtil.Byte_Q(content, 36, 18)); //身份证好。 UInt16 ResultNum; string Reason; Pro_ShipDevice_Card_New_Dal.Exec(info, out ResultNum, out Reason); if (ResultNum != 0) { MyLibrary.Log.Debug(Name + "出错;" + Reason + " 原始代码:" + OriginalCode); } }