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); }
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(); }