예제 #1
0
 /// <summary>
 /// 重置打印状态
 /// </summary>
 /// <param name="processCardNumber">流转卡号</param>
 /// <param name="id">打印ID</param>
 /// <returns>处理结果</returns>
 public bool RestPrint(string processCardNumber, int id)
 {
     try
     {
         ProcResultModel ret = dal.RestPrint(processCardNumber, id);
         if (ret.execResult == 1)
         {
             return(true);
         }
     }
     catch (Exception)
     {
         throw;
     }
     return(false);
 }
예제 #2
0
        /// <summary>
        /// 初始化快照数据
        /// </summary>
        /// <returns></returns>
        public ProcResultModel InitDayReportData(int year, int month, int day, string dayValue)
        {
            SqlParameter[] parameters =
            {
                new SqlParameter("@errMsg",   SqlDbType.NVarChar, 50),
                new SqlParameter("@year",     SqlDbType.Int),
                new SqlParameter("@month",    SqlDbType.Int),
                new SqlParameter("@day",      SqlDbType.Int),
                new SqlParameter("@dayValue", SqlDbType.NVarChar, 10),
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = year;
            parameters[2].Value     = month;
            parameters[3].Value     = day;
            parameters[4].Value     = dayValue;
            ProcResultModel ret = SQLServerHelper.RunProcedureOutParamRetValue("uspWip_InitDayReportData", parameters);

            return(ret);
        }
예제 #3
0
        /// <summary>
        /// 重置打印状态
        /// </summary>
        /// <param name="processCardNumber">流转卡号</param>
        /// <param name="id">打印ID</param>
        /// <returns>处理结果</returns>
        public ProcResultModel RestPrint(string processCardNumber, int id)
        {
            try
            {
                SqlParameter[] parameters =
                {
                    new SqlParameter("@processCardNumber", SqlDbType.NVarChar, 50),
                    new SqlParameter("@id",                SqlDbType.Int, -1)
                };
                parameters[0].Value = processCardNumber;
                parameters[1].Value = id;

                ProcResultModel ret = SQLServerHelper.RunProcedureOutParamRetValue("uspWip_ResetPrint", parameters);
                return(ret);
            }
            catch (Exception)
            {
                throw;
            }
        }
예제 #4
0
        /// <summary>
        /// 生成顺序号
        /// </summary>
        /// <param name="serialNoType"></param>
        /// <returns></returns>
        public string GetSerialNo(SerialNoType serialNoType)
        {
            try
            {
                SqlParameter[] parameters =
                {
                    new SqlParameter("@type", SqlDbType.Char, 2)
                };
                parameters[0].Value = Convert.ToInt32(serialNoType).ToString();

                ProcResultModel ret = SQLServerHelper.RunProcedureOutParamRetValue("uspWip_GetSerialNoProduce", parameters);
                if (ret.execResult > 0)
                {
                    return(ret.execResult.ToString());
                }
                throw new Exception("生成顺序号错误");
            }
            catch
            {
                throw;
            }
        }