Esempio n. 1
0
        private void Single(byte[] content)
        {
            try
            {
                Pro_CrewregistDevice_Card_Mod info = new Pro_CrewregistDevice_Card_Mod();
                info.Pi_DevId     = StationId.ToString();
                info.Pi_DevTime   = ConverUtil.Time(content, 0);                                    //设备时间
                info.Pi_CardId    = ConverUtil.ByteToStr_Q(content, 6, 8);                          //身份证卡号
                info.Pi_Identity  = ConverUtil.ASI_To_Str(ConverUtil.ByteToStr_Q(Content, 14, 18)); //身份证号
                info.Pi_Name      = Address(ConverUtil.ByteToStr_Q(Content, 32, 30));               //姓名
                info.Pi_Sex       = IsSex(ConverUtil.ByteToStr_Q(Content, 62, 1));                  //性别。
                info.Pi_Nation    = ConverUtil.MinZu(ConverUtil.ByteToStr_Q(Content, 63, 2));       //民族。
                info.Pi_Birthday  = TimeStr(ConverUtil.ByteToStr_Q(Content, 65, 8));                //出生年月日。
                info.Pi_Address   = Address(ConverUtil.ByteToStr_Q(Content, 73, 70));               //住址。
                info.Pi_SignUnit  = Address(ConverUtil.ByteToStr_Q(Content, 143, 30));              //签发机关。
                info.Pi_StartTime = TimeStr(ConverUtil.ByteToStr_Q(Content, 173, 8));               //起始日期。
                info.Pi_EndTime   = TimeStr(ConverUtil.ByteToStr_Q(Content, 181, 8));               //结束日期。

                UInt16 ResultNum;
                string Reason;
                Pro_CrewregistDevice_Card_Dal.Exec(info, out ResultNum, out Reason);
                if (ResultNum != 0)
                {
                    MyLibrary.Log.Debug(Name + "出错;" + Reason + " 原始代码:" + OriginalCode);
                }
            }
            catch (Exception ex)
            {
                MyLibrary.Log.Error(Name + "错误:" + ex.Message + " 原始代码:" + OriginalCode);
            }
        }
        public static void Exec(Pro_CrewregistDevice_Card_Mod info, out UInt16 resultNum, out string reason)
        {
            Database  db  = DataConnect.GetConnect;
            DbCommand cmd = db.GetStoredProcCommand("PRO_CREWREGISTDEVICE_CARD");

            db.AddInParameter(cmd, ":pi_devid", DbType.String, info.Pi_DevId);
            db.AddInParameter(cmd, ":pi_devtime", DbType.Date, info.Pi_DevTime);
            db.AddInParameter(cmd, ":pi_identity", DbType.String, info.Pi_Identity);
            db.AddInParameter(cmd, ":pi_cardid", DbType.String, info.Pi_CardId);
            db.AddInParameter(cmd, ":pi_name", DbType.String, info.Pi_Name);
            db.AddInParameter(cmd, ":pi_sex", DbType.String, info.Pi_Sex);
            db.AddInParameter(cmd, ":pi_nation", DbType.String, info.Pi_Nation);
            db.AddInParameter(cmd, ":pi_birthday", DbType.Date, info.Pi_Birthday);
            db.AddInParameter(cmd, ":pi_address", DbType.String, info.Pi_Address);
            db.AddInParameter(cmd, ":pi_signunit", DbType.String, info.Pi_SignUnit);
            db.AddInParameter(cmd, ":pi_starttime", DbType.Date, info.Pi_StartTime);
            db.AddInParameter(cmd, ":pi_endtime", DbType.Date, info.Pi_EndTime);
            db.AddOutParameter(cmd, ":po_ret", DbType.String, 256);
            db.AddOutParameter(cmd, ":po_content", DbType.String, 256);
            db.ExecuteNonQuery(cmd);
            resultNum = Convert.ToUInt16(db.GetParameterValue(cmd, ":po_ret"));
            reason    = db.GetParameterValue(cmd, ":po_content").ToString();
        }