Ejemplo n.º 1
0
        /// <summary>
        /// 根据主键id查询信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static PrintSGDCountMOD GetmodByid(string orderNum,string proType)
        {
            PrintSGDCountMOD mod = new PrintSGDCountMOD();
            string sqlcommandString = "select * from PrintSGDCount where OrderNum='"+orderNum+"' and ProType='"+proType+"'";

            try
            {
                SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString);
                if (reader.Read())
                {
                    if (reader["PrintCount"] != null && reader["PrintCount"].ToString() != "")
                    {
                        mod.PrintCount = Convert.ToInt32(reader["PrintCount"].ToString());
                    }
                    reader.Close();
                    return mod;
                }
                else
                {
                    reader.Close();
                    return null;
                }

            }
            catch (Exception e)
            {
                throw e;
            }
        }
Ejemplo n.º 2
0
 public static int UpdatePrintCount()
 {
     int count = 0;
     if (proNum != "")
     {
         count = Convert.ToInt32(proNum);
         PrintSGDCountMOD mod = PrintSGDCountBLL.GetmodByid(orderNum, proType);
         if (mod != null)
         {
             if (mod.PrintCount.ToString() != "")
             {
                 mod.PrintCount = mod.PrintCount + count;
             }
             else
             {
                 mod.PrintCount = count;
             }
             mod.OrderNum = orderNum;
             mod.ProType = proType;
             return PrintSGDCountBLL.Updatemod(mod);
         }
         else
         {
             mod = new PrintSGDCountMOD();
             mod.PrintCount = count;
             mod.OrderNum = orderNum;
             mod.ProType = proType;
             return PrintSGDCountBLL.Insertmod(mod);
         }
     }
     else
     {
         return 0;
     }
 }
Ejemplo n.º 3
0
 /// <summary>
 /// 更新
 /// </summary>
 /// <param name="dtomodList">数据对象</param>
 /// <returns></returns>
 public static int Updatemod(PrintSGDCountMOD mod)
 {
     string sqlCommandString = "Update PrintSGDCount Set PrintCount=@PrintCount Where OrderNum=@OrderNum and ProType=@ProType";
     SqlParameter[] arParams = new SqlParameter[3];
     arParams[0] = new SqlParameter("@OrderNum", mod.OrderNum);
     arParams[1] = new SqlParameter("@ProType", mod.ProType);
     arParams[2] = new SqlParameter("@PrintCount", mod.PrintCount);
     return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
 }
Ejemplo n.º 4
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="dtomodList">对象</param>
 /// <returns></returns>
 public static int Insertmod(PrintSGDCountMOD mod)
 {
     string sqlCommandString = "Insert Into PrintSGDCount(OrderNum,ProType,PrintCount)Values(@OrderNum,@ProType,@PrintCount)";
     SqlParameter[] arParams = new SqlParameter[3];
     arParams[0] = new SqlParameter("@OrderNum", mod.OrderNum);
     arParams[1] = new SqlParameter("@ProType", mod.ProType);
     arParams[2] = new SqlParameter("@PrintCount", mod.PrintCount);
     return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
 }
Ejemplo n.º 5
0
 /// <summary>
 /// 修改打印数量
 /// </summary>
 public void UpdatePrintCount(HttpContext context)
 {
     int count = 0;
     int num = 0;
     string proNum = context.Request["proNum"] + "";
     string orderNum = context.Request["orderNum"] + "";
     string proType = context.Request["proType"] + "";
     if (proNum != "")
     {
         count = Convert.ToInt32(proNum);
         PrintSGDCountMOD mod = PrintSGDCountBLL.GetmodByid(orderNum, proType);
         if (mod != null)
         {
             if (mod.PrintCount.ToString() != "")
             {
                 mod.PrintCount = mod.PrintCount + count;
             }
             else
             {
                 mod.PrintCount = count;
             }
             mod.OrderNum = orderNum;
             mod.ProType = proType;
             num= PrintSGDCountBLL.Updatemod(mod);
         }
         else
         {
             mod = new PrintSGDCountMOD();
             mod.PrintCount = count;
             mod.OrderNum = orderNum;
             mod.ProType = proType;
             num = PrintSGDCountBLL.Insertmod(mod);
         }
     }
     context.Response.Write("{\"d\":" + num + "}");
 }
Ejemplo n.º 6
0
 /// <summary>
 /// 更新
 /// </summary>
 /// <param name="dtomodList">数据对象</param>
 /// <returns></returns>
 public static int Updatemod(PrintSGDCountMOD mod)
 {
     return PrintSGDCountDAO.Updatemod(mod);
 }
Ejemplo n.º 7
0
 /// <summary>
 /// 添加
 /// </summary>
 /// <param name="dtomodList">对象</param>
 /// <returns></returns>
 public static int Insertmod(PrintSGDCountMOD mod)
 {
     return PrintSGDCountDAO.Insertmod(mod);
 }