/// <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;
}
}
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;
}
}
/// <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);
}
/// <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);
}
/// <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 + "}");
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(PrintSGDCountMOD mod)
{
return PrintSGDCountDAO.Updatemod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(PrintSGDCountMOD mod)
{
return PrintSGDCountDAO.Insertmod(mod);
}