public bool Execute()
        {
            Pro_CrewregistDevice_Photo_Mod info = new Pro_CrewregistDevice_Photo_Mod();

            try
            {
                string[] array = Content.Split('|');
                info.Pi_DevId   = StationId.ToString();
                info.Pi_DevTime = PlatformTime;
                info.Pi_Index   = array[0];
                info.Pi_Photo   = Convert.FromBase64String(array[1]);

                UInt16 ResultNum;
                string Reason;
                Pro_CrewregistDevice_Photo_Dal.Exec(info, out ResultNum, out Reason);
                if (ResultNum != 0)
                {
                    MyLibrary.Log.Debug(Name + "出错;" + Reason + " 设备编号:" + info.Pi_DevId + " 照片时间:" + info.Pi_DevTime + " 照片编号:" + info.Pi_Index);
                }
            }
            catch (Exception ex)
            {
                MyLibrary.Log.Error(Name + "错误;" + ex.Message + " 设备编号:" + info.Pi_DevId + " 照片时间:" + info.Pi_DevTime + " 照片编号:" + info.Pi_Index);
            }

            return(true);
        }
示例#2
0
        public static void Exec(Pro_CrewregistDevice_Photo_Mod info, out UInt16 resultNum, out string reason)
        {
            Database  db  = DataConnect.GetConnect;
            DbCommand cmd = db.GetStoredProcCommand("PRO_CREWREGISTDEVICE_PHOTO");

            db.AddInParameter(cmd, ":pi_devid", DbType.String, info.Pi_DevId);
            db.AddInParameter(cmd, ":pi_devtime", DbType.Date, info.Pi_DevTime);
            db.AddInParameter(cmd, ":pi_index", DbType.String, info.Pi_Index);
            db.AddInParameter(cmd, ":pi_photo", DbType.Binary, info.Pi_Photo);
            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();
        }