/// <summary>
/// 设置使用
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Set(Model.DzCodesModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Dz_Codes set DTime=@DTime,Mob=@Mob,PCodes=@PCodes,States=1");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@DTime", model.DTime),
new SqlParameter("@mob", model.Mob),
new SqlParameter("@PCodes", model.PCodes),
new SqlParameter("@id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
/// <summary>
/// 添加组织
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.DzCodesModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Dz_Codes(");
strSql.Append("Codes,Price,CTime,DTime,Mob,PCodes,States,Notes)");
strSql.Append(" values (");
strSql.Append("@Codes,@Price,@CTime,@DTime,@Mob,@PCodes,@States,@Notes)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Codes", model.Codes),
new SqlParameter("@Price", model.Price),
new SqlParameter("@CTime", model.CTime),
new SqlParameter("@DTime", model.DTime),
new SqlParameter("@Mob", model.Mob),
new SqlParameter("@PCodes", model.PCodes),
new SqlParameter("@States", model.States),
new SqlParameter("@Notes", model.Notes)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
