public static int Add(PayListInfo model)
{
SqlParameter idoutparam = DataBase.MakeOutParam("@ID", SqlDbType.Int, 4);
SqlParameter[] prams = new SqlParameter[] { idoutparam, DataBase.MakeInParam("@Uid", SqlDbType.Int, 4, model.Uid), DataBase.MakeInParam("@Money", SqlDbType.Money, 8, model.Money), DataBase.MakeInParam("@Status", SqlDbType.Int, 4, model.Status), DataBase.MakeInParam("@AddTime", SqlDbType.DateTime, 8, model.AddTime), DataBase.MakeInParam("@PayTime", SqlDbType.DateTime, 8, model.PayTime), DataBase.MakeInParam("@Tax", SqlDbType.Money, 8, model.Tax), DataBase.MakeInParam("@Charges", SqlDbType.Money, 8, model.Charges) };
if (DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "UP_PayList_ADD", prams) == 1)
{
return((int)idoutparam.Value);
}
return(0);
}
public static PayListInfo GetModel(int id)
{
SqlParameter[] prams = new SqlParameter[] { DataBase.MakeInParam("@ID", SqlDbType.Int, 4, id) };
PayListInfo model = null;
using (SqlDataReader dataReader = DataBase.ExecuteReader(CommandType.StoredProcedure, "UP_PayList_GetModel", prams))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
///
/// </summary>
/// <param name="dataReader"></param>
/// <returns></returns>
public static PayListInfo ReaderBind(SqlDataReader dataReader)
{
PayListInfo model = new PayListInfo();
object ojb = dataReader["ID"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.ID = (int)ojb;
}
ojb = dataReader["Uid"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.Uid = (int)ojb;
}
ojb = dataReader["Money"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.Money = (decimal)ojb;
}
ojb = dataReader["Status"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.Status = (int)ojb;
}
ojb = dataReader["AddTime"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.AddTime = (DateTime)ojb;
}
ojb = dataReader["PayTime"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.PayTime = (DateTime)ojb;
}
ojb = dataReader["Tax"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.Tax = (decimal)ojb;
}
ojb = dataReader["Charges"];
if ((ojb != null) && (ojb != DBNull.Value))
{
model.Charges = (decimal)ojb;
}
return(model);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool Update(PayListInfo model)
{
SqlParameter[] prams = new SqlParameter[] { DataBase.MakeInParam("@ID", SqlDbType.Int, 4, model.ID), DataBase.MakeInParam("@Uid", SqlDbType.Int, 4, model.Uid), DataBase.MakeInParam("@Money", SqlDbType.Money, 8, model.Money), DataBase.MakeInParam("@Status", SqlDbType.Int, 4, model.Status), DataBase.MakeInParam("@AddTime", SqlDbType.DateTime, 8, model.AddTime), DataBase.MakeInParam("@PayTime", SqlDbType.DateTime, 8, model.PayTime), DataBase.MakeInParam("@Tax", SqlDbType.Money, 8, model.Tax), DataBase.MakeInParam("@Charges", SqlDbType.Money, 8, model.Charges) };
return(DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "UP_PayList_Update", prams) > 0);
}
