/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EntrustInfo model)
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@bankcardnum", SqlDbType.VarChar, 30),
new SqlParameter("@bankname", SqlDbType.NVarChar, 150),
new SqlParameter("@payee", SqlDbType.NVarChar, 10),
new SqlParameter("@amount", SqlDbType.Decimal, 9),
new SqlParameter("@rate", SqlDbType.Decimal, 9),
new SqlParameter("@remittancefee", SqlDbType.Decimal, 9),
new SqlParameter("@totalAmt", SqlDbType.Decimal, 9),
new SqlParameter("@addtime", SqlDbType.DateTime),
new SqlParameter("@cdate", SqlDbType.DateTime),
new SqlParameter("@cadmin", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.id;
parameters[1].Value = model.userid;
parameters[2].Value = model.status;
parameters[3].Value = model.bankcardnum;
parameters[4].Value = model.bankname;
parameters[5].Value = model.payee;
parameters[6].Value = model.amount;
parameters[7].Value = model.rate;
parameters[8].Value = model.remittancefee;
parameters[9].Value = model.totalAmt;
parameters[10].Value = model.addtime;
parameters[11].Value = model.cdate;
parameters[12].Value = model.cadmin;
parameters[13].Value = model.remark;
rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_entrust_Update", parameters);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
public static EntrustInfo GetModelFromDs(DataSet ds)
{
EntrustInfo model = new EntrustInfo();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"] != null && ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["bankcardnum"] != null && ds.Tables[0].Rows[0]["bankcardnum"].ToString() != "")
{
model.bankcardnum = ds.Tables[0].Rows[0]["bankcardnum"].ToString();
}
if (ds.Tables[0].Rows[0]["bankname"] != null && ds.Tables[0].Rows[0]["bankname"].ToString() != "")
{
model.bankname = ds.Tables[0].Rows[0]["bankname"].ToString();
}
if (ds.Tables[0].Rows[0]["payee"] != null && ds.Tables[0].Rows[0]["payee"].ToString() != "")
{
model.payee = ds.Tables[0].Rows[0]["payee"].ToString();
}
if (ds.Tables[0].Rows[0]["amount"] != null && ds.Tables[0].Rows[0]["amount"].ToString() != "")
{
model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString());
}
if (ds.Tables[0].Rows[0]["rate"] != null && ds.Tables[0].Rows[0]["rate"].ToString() != "")
{
model.rate = decimal.Parse(ds.Tables[0].Rows[0]["rate"].ToString());
}
if (ds.Tables[0].Rows[0]["remittancefee"] != null && ds.Tables[0].Rows[0]["remittancefee"].ToString() != "")
{
model.remittancefee = decimal.Parse(ds.Tables[0].Rows[0]["remittancefee"].ToString());
}
if (ds.Tables[0].Rows[0]["totalAmt"] != null && ds.Tables[0].Rows[0]["totalAmt"].ToString() != "")
{
model.totalAmt = decimal.Parse(ds.Tables[0].Rows[0]["totalAmt"].ToString());
}
if (ds.Tables[0].Rows[0]["addtime"] != null && ds.Tables[0].Rows[0]["addtime"].ToString() != "")
{
model.addtime = DateTime.Parse(ds.Tables[0].Rows[0]["addtime"].ToString());
}
if (ds.Tables[0].Rows[0]["cdate"] != null && ds.Tables[0].Rows[0]["cdate"].ToString() != "")
{
model.cdate = DateTime.Parse(ds.Tables[0].Rows[0]["cdate"].ToString());
}
if (ds.Tables[0].Rows[0]["cadmin"] != null && ds.Tables[0].Rows[0]["cadmin"].ToString() != "")
{
model.cadmin = int.Parse(ds.Tables[0].Rows[0]["cadmin"].ToString());
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
return(model);
}
else
{
return(null);
}
}
