/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(viviapi.Model.Finance.Agent.WithdrawAgentNotify model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@notify_id", SqlDbType.VarChar, 20),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@trade_no", SqlDbType.VarChar, 40),
new SqlParameter("@out_trade_no", SqlDbType.VarChar, 64),
new SqlParameter("@notifystatus", SqlDbType.TinyInt, 1),
new SqlParameter("@notifyurl", SqlDbType.VarChar, 1000),
new SqlParameter("@resText", SqlDbType.NVarChar, 200),
new SqlParameter("@addTime", SqlDbType.DateTime),
new SqlParameter("@resTime", SqlDbType.DateTime),
new SqlParameter("@ext1", SqlDbType.VarChar, 50),
new SqlParameter("@ext2", SqlDbType.VarChar, 50),
new SqlParameter("@ext3", SqlDbType.VarChar, 50),
new SqlParameter("@remark", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.id;
parameters[1].Value = model.notify_id;
parameters[2].Value = model.userid;
parameters[3].Value = model.trade_no;
parameters[4].Value = model.out_trade_no;
parameters[5].Value = model.notifystatus;
parameters[6].Value = model.notifyurl;
parameters[7].Value = model.resText;
parameters[8].Value = model.addTime;
parameters[9].Value = model.resTime;
parameters[10].Value = model.ext1;
parameters[11].Value = model.ext2;
parameters[12].Value = model.ext3;
parameters[13].Value = model.remark;
DbHelperSQL.RunProcedure("proc_withdrawAgentNotify_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public viviapi.Model.Finance.Agent.WithdrawAgentNotify GetModel(int id)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
viviapi.Model.Finance.Agent.WithdrawAgentNotify model = new viviapi.Model.Finance.Agent.WithdrawAgentNotify();
DataSet ds = DbHelperSQL.RunProcedure("proc_withdrawAgentNotify_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public viviapi.Model.Finance.Agent.WithdrawAgentNotify DataRowToModel(DataRow row)
{
viviapi.Model.Finance.Agent.WithdrawAgentNotify model = new viviapi.Model.Finance.Agent.WithdrawAgentNotify();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["notify_id"] != null)
{
model.notify_id = row["notify_id"].ToString();
}
if (row["userid"] != null && row["userid"].ToString() != "")
{
model.userid = int.Parse(row["userid"].ToString());
}
if (row["trade_no"] != null)
{
model.trade_no = row["trade_no"].ToString();
}
if (row["out_trade_no"] != null)
{
model.out_trade_no = row["out_trade_no"].ToString();
}
if (row["notifystatus"] != null && row["notifystatus"].ToString() != "")
{
model.notifystatus = int.Parse(row["notifystatus"].ToString());
}
if (row["notifyurl"] != null)
{
model.notifyurl = row["notifyurl"].ToString();
}
if (row["resText"] != null)
{
model.resText = row["resText"].ToString();
}
if (row["addTime"] != null && row["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(row["addTime"].ToString());
}
if (row["resTime"] != null && row["resTime"].ToString() != "")
{
model.resTime = DateTime.Parse(row["resTime"].ToString());
}
if (row["ext1"] != null)
{
model.ext1 = row["ext1"].ToString();
}
if (row["ext2"] != null)
{
model.ext2 = row["ext2"].ToString();
}
if (row["ext3"] != null)
{
model.ext3 = row["ext3"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(viviapi.Model.Finance.Agent.WithdrawAgentNotify model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(viviapi.Model.Finance.Agent.WithdrawAgentNotify model)
{
return(dal.Add(model));
}
