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;
            }
        }
Esempio n. 2
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);
        }