public tbPrintPlaneSingle Select(int UserId, bool IsSingle)
{
tbPrintPlaneSingle Print = null;
IDbDataParameter[] parm = GetSelectByIdAndStateParam();
parm[0].Value = UserId;
parm[1].Value = IsSingle;
using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT_STATE, parm)) {
if (MyReader.Read())
{
Print = new tbPrintPlaneSingle()
{
PlaneId = MyReader.GetInt32(0),
LogisticsId = MyReader.GetInt32(1),
UserId = MyReader.GetInt32(2),
Image = MyReader.GetString(3),
Width = MyReader.GetInt32(4),
Height = MyReader.GetInt32(5),
IsSingle = MyReader.GetBoolean(6)
};
}
}
return(Print == null ? new tbPrintPlaneSingle() : Print);
}
public bool Update(tbPrintPlaneSingle PrintPlaneSingle)
{
bool IsOk = false;
IDbDataParameter[] parm = GetUpdateParam();
parm[0].Value = PrintPlaneSingle.PlaneId;
parm[1].Value = PrintPlaneSingle.LogisticsId;
parm[2].Value = PrintPlaneSingle.UserId;
parm[3].Value = PrintPlaneSingle.Image;
parm[4].Value = PrintPlaneSingle.Width;
parm[5].Value = PrintPlaneSingle.Height;
parm[6].Value = PrintPlaneSingle.IsSingle;
try {
DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_UPDATE, parm);
IsOk = true;
} catch { }
return(IsOk);
}
public int Insert(tbPrintPlaneSingle PrintPlaneSingle)
{
int Id = 0;
IDbDataParameter[] parm = GetInsertParam();
parm[0].Value = PrintPlaneSingle.LogisticsId;
parm[1].Value = PrintPlaneSingle.UserId;
parm[2].Value = PrintPlaneSingle.Image;
parm[3].Value = PrintPlaneSingle.Width;
parm[4].Value = PrintPlaneSingle.Height;
parm[5].Value = PrintPlaneSingle.IsSingle;
try {
using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_INSERT, parm)) {
if (MyReader.Read())
{
Id = MyReader.GetInt32(0);
}
}
} catch { }
return(Id);
}
/// <summary>
/// 修改打印面单模板信息
/// </summary>
/// <param name="PrintPlaneSingle">打印面单模板信息表</param>
/// <returns></returns>
public static bool Update(tbPrintPlaneSingle PrintPlaneSingle)
{
return(PrintPlaneSingleDal.Update(PrintPlaneSingle));
}
/// <summary>
/// 添加打印面单模板信息
/// </summary>
/// <param name="PrintPlaneSingle">打印面单模板信息表</param>
/// <returns></returns>
public static int Insert(tbPrintPlaneSingle PrintPlaneSingle)
{
return(PrintPlaneSingleDal.Insert(PrintPlaneSingle));
}
