public static void Exec(Pro_TagData_Mod info, out int resultnum) { Database db = DataConnect.GetConnect; DbCommand cmd = db.GetStoredProcCommand("PRO_TAGDATA"); db.AddInParameter(cmd, ":TagID", DbType.String, info.TagID); db.AddInParameter(cmd, ":StationID", DbType.String, info.StationID); db.AddInParameter(cmd, ":TagTime", DbType.Date, info.TagTime); db.AddInParameter(cmd, ":PlateTime", DbType.Date, info.PlateTime); db.AddInParameter(cmd, ":TagType", DbType.String, info.TagType); db.AddOutParameter(cmd, ":Ret", DbType.String, 256); db.ExecuteNonQuery(cmd); var ResultNum = db.GetParameterValue(cmd, ":Ret"); if (ResultNum != null && ResultNum.ToString() != "") { resultnum = Convert.ToInt16(ResultNum); } else { resultnum = 0; } }
public bool Execute() { try { Pro_TagData_Mod info = new Pro_TagData_Mod(); info.StationID = StationId.ToString(); info.PlateTime = PlatformTime; info.TagTime = ConverUtil.Time(_content, 0); info.TagType = ConverUtil.ByteToStr_2(_content, 7); info.TagID = ConverUtil.ByteToStr_4(_content, 9); int ResultNum; FileManagementDal.JingXie.Pro_TagData_Dal.Exec(info, out ResultNum); if (ResultNum != 1) { MyLibrary.Log.Debug(Name + "出错;原始代码:" + OriginalCode); } } catch (Exception ex) { MyLibrary.Log.Error(Name + "错误;" + ex.Message + " 原始代码:" + OriginalCode); } return(true); }