/// <summary>
/// 在数据库中新增一个持久化对象,自增长列id的值会自动从数据库中返回
/// </summary>
/// <remarks></remarks>
public int Create(Model.Roles_Permissions model)
{
string sequel = "IF NOT EXISTS(SELECT TOP(1) * FROM yxs_roles_permissions WHERE [id]=@ID and [operatecode]=@OperateCode) Insert into [yxs_roles_permissions](";
sequel = sequel + "[id],[operatecode])";
sequel = sequel + "Values(";
sequel = sequel + "@ID,@OperateCode) Select @@rowcount ";
DbCommand dbCommand = db.GetSqlStringCommand(sequel.ToString());
db.AddInParameter(dbCommand, "ID", DbType.AnsiString, model.ID);
db.AddInParameter(dbCommand, "OperateCode", DbType.AnsiString, model.OperateCode);
int cmdresult;
object obj = db.ExecuteScalar(dbCommand);
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
return(cmdresult);
}
/// <summary>
/// 返回数据
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public Model.Roles_Permissions GetModel(System.Data.DataRow row)
{
Model.Roles_Permissions model = new Model.Roles_Permissions();
if (row != null)
{
model.ID = int.Parse(row["id"].ToString());
model.OperateCode = int.Parse(row["operatecode"].ToString());
return(model);
}
else
{
return(null);
}
}
