/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ModMoneyApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Shop_MoneyApply set ");
strSql.Append("shopid=@shopid,");
strSql.Append("marketid=@marketid,");
strSql.Append("apply_name=@apply_name,");
strSql.Append("apply_money=@apply_money,");
strSql.Append("apply_ispost=@apply_ispost,");
strSql.Append("apply_posttime=@apply_posttime,");
strSql.Append("apply_postcheck=@apply_postcheck,");
strSql.Append("apply_postchecktime=@apply_postchecktime,");
strSql.Append("apply_isback=@apply_isback,");
strSql.Append("apply_backtime=@apply_backtime,");
strSql.Append("apply_backcheck=@apply_backcheck,");
strSql.Append("apply_backchecktime=@apply_backchecktime,");
strSql.Append("apply_mark=@apply_mark");
strSql.Append(" where apply_id=@apply_id");
SqlParameter[] parameters =
{
new SqlParameter("@shopid", SqlDbType.VarChar, 50),
new SqlParameter("@marketid", SqlDbType.VarChar, 50),
new SqlParameter("@apply_name", SqlDbType.VarChar, 50),
new SqlParameter("@apply_money", SqlDbType.Decimal, 9),
new SqlParameter("@apply_ispost", SqlDbType.VarChar, 50),
new SqlParameter("@apply_posttime", SqlDbType.DateTime),
new SqlParameter("@apply_postcheck", SqlDbType.VarChar, 50),
new SqlParameter("@apply_postchecktime", SqlDbType.DateTime),
new SqlParameter("@apply_isback", SqlDbType.VarChar, 50),
new SqlParameter("@apply_backtime", SqlDbType.DateTime),
new SqlParameter("@apply_backcheck", SqlDbType.VarChar, 50),
new SqlParameter("@apply_backchecktime", SqlDbType.DateTime),
new SqlParameter("@apply_mark", SqlDbType.VarChar, 500),
new SqlParameter("@apply_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.shopid;
parameters[1].Value = model.marketid;
parameters[2].Value = model.apply_name;
parameters[3].Value = model.apply_money;
parameters[4].Value = model.apply_ispost;
parameters[5].Value = model.apply_posttime;
parameters[6].Value = model.apply_postcheck;
parameters[7].Value = model.apply_postchecktime;
parameters[8].Value = model.apply_isback;
parameters[9].Value = model.apply_backtime;
parameters[10].Value = model.apply_backcheck;
parameters[11].Value = model.apply_backchecktime;
parameters[12].Value = model.apply_mark;
parameters[13].Value = model.apply_id;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModMoneyApply model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Shop_MoneyApply(");
strSql.Append("shopid,marketid,apply_name,apply_money,apply_ispost,apply_posttime,apply_postcheck,apply_postchecktime,apply_isback,apply_backtime,apply_backcheck,apply_backchecktime,apply_mark)");
strSql.Append(" values (");
strSql.Append("@shopid,@marketid,@apply_name,@apply_money,@apply_ispost,@apply_posttime,@apply_postcheck,@apply_postchecktime,@apply_isback,@apply_backtime,@apply_backcheck,@apply_backchecktime,@apply_mark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@shopid", SqlDbType.VarChar, 50),
new SqlParameter("@marketid", SqlDbType.VarChar, 50),
new SqlParameter("@apply_name", SqlDbType.VarChar, 50),
new SqlParameter("@apply_money", SqlDbType.Decimal, 9),
new SqlParameter("@apply_ispost", SqlDbType.VarChar, 50),
new SqlParameter("@apply_posttime", SqlDbType.DateTime),
new SqlParameter("@apply_postcheck", SqlDbType.VarChar, 50),
new SqlParameter("@apply_postchecktime", SqlDbType.DateTime),
new SqlParameter("@apply_isback", SqlDbType.VarChar, 50),
new SqlParameter("@apply_backtime", SqlDbType.DateTime),
new SqlParameter("@apply_backcheck", SqlDbType.VarChar, 50),
new SqlParameter("@apply_backchecktime", SqlDbType.DateTime),
new SqlParameter("@apply_mark", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.shopid;
parameters[1].Value = model.marketid;
parameters[2].Value = model.apply_name;
parameters[3].Value = model.apply_money;
parameters[4].Value = model.apply_ispost;
parameters[5].Value = model.apply_posttime;
parameters[6].Value = model.apply_postcheck;
parameters[7].Value = model.apply_postchecktime;
parameters[8].Value = model.apply_isback;
parameters[9].Value = model.apply_backtime;
parameters[10].Value = model.apply_backcheck;
parameters[11].Value = model.apply_backchecktime;
parameters[12].Value = model.apply_mark;
return(adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ModMoneyApply GetModel(string shopid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 apply_id,shopid,marketid,apply_name,apply_money,apply_ispost,apply_posttime,apply_postcheck,apply_postchecktime,apply_isback,apply_backtime,apply_backcheck,apply_backchecktime,apply_mark from T_Shop_MoneyApply ");
strSql.Append(" where shopid=@shopid");
SqlParameter[] parameters =
{
new SqlParameter("@shopid", SqlDbType.VarChar, 50)
};
parameters[0].Value = shopid;
ModMoneyApply model = new ModMoneyApply();
DataSet ds = adoHelper.ExecuteSqlDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ModMoneyApply DataRowToModel(DataRow row)
{
ModMoneyApply model = new ModMoneyApply();
if (row != null)
{
if (row["apply_id"] != null && row["apply_id"].ToString() != "")
{
model.apply_id = int.Parse(row["apply_id"].ToString());
}
if (row["shopid"] != null)
{
model.shopid = row["shopid"].ToString();
}
if (row["marketid"] != null)
{
model.marketid = row["marketid"].ToString();
}
if (row["apply_name"] != null)
{
model.apply_name = row["apply_name"].ToString();
}
if (row["apply_money"] != null && row["apply_money"].ToString() != "")
{
model.apply_money = decimal.Parse(row["apply_money"].ToString());
}
if (row["apply_ispost"] != null)
{
model.apply_ispost = row["apply_ispost"].ToString();
}
if (row["apply_posttime"] != null && row["apply_posttime"].ToString() != "")
{
model.apply_posttime = DateTime.Parse(row["apply_posttime"].ToString());
}
if (row["apply_postcheck"] != null)
{
model.apply_postcheck = row["apply_postcheck"].ToString();
}
if (row["apply_postchecktime"] != null && row["apply_postchecktime"].ToString() != "")
{
model.apply_postchecktime = DateTime.Parse(row["apply_postchecktime"].ToString());
}
if (row["apply_isback"] != null)
{
model.apply_isback = row["apply_isback"].ToString();
}
if (row["apply_backtime"] != null && row["apply_backtime"].ToString() != "")
{
model.apply_backtime = DateTime.Parse(row["apply_backtime"].ToString());
}
if (row["apply_backcheck"] != null)
{
model.apply_backcheck = row["apply_backcheck"].ToString();
}
if (row["apply_backchecktime"] != null && row["apply_backchecktime"].ToString() != "")
{
model.apply_backchecktime = DateTime.Parse(row["apply_backchecktime"].ToString());
}
if (row["apply_mark"] != null)
{
model.apply_mark = row["apply_mark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(ModMoneyApply model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ModMoneyApply model)
{
return(dal.Add(model));
}