public static int AddSuigongdan()
{
SGDRecordMOD mod = new SGDRecordMOD();
mod.OrderNum = orderNum;
mod.ProType = proType;
mod.CustomerNum = customNum;
mod.Suigongdan = suigongdan;
return SGDRecordBLL.Insertmod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(SGDRecordMOD mod)
{
string sqlCommandString = @"IF(not exists(select * from SGDRecord where suigongdan=@suigongdan))
BEGIN
Insert Into SGDRecord(orderNum,customerNum,proType,suigongdan,PrintCount) Values
(@orderNum,@customerNum,@proType,@suigongdan,@PrintCount)
END";
SqlParameter[] arParams = new SqlParameter[5];
arParams[0] = new SqlParameter("@orderNum", mod.OrderNum);
arParams[1] = new SqlParameter("@customerNum", mod.ProType);
arParams[2] = new SqlParameter("@proType", mod.ProType);
arParams[3] = new SqlParameter("@suigongdan", mod.Suigongdan);
arParams[4] = new SqlParameter("@PrintCount", mod.PrintCount);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加随工单
/// </summary>
public void AddSuigongdan(HttpContext context)
{
int num = 0;
string orderNum = context.Request["orderNum"] + "";
string proType = context.Request["proType"] + "";
string customNum = context.Request["customNum"] + "";
string suigongdan = context.Request["suigongdan"] + "";
string proNum = context.Request["proNum"]+"";
SGDRecordMOD mod = new SGDRecordMOD() {
OrderNum = orderNum,
ProType = proType,
CustomerNum = customNum,
Suigongdan = suigongdan,
PrintCount = proNum
};
num = SGDRecordBLL.Insertmod(mod);
context.Response.Write("{\"d\":" + num + "}");
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(SGDRecordMOD mod)
{
return SGDRecordDAO.Insertmod(mod);
}