/// <summary>
/// 对象实体绑定数据
/// </summary>
public VAN_OA.Model.EFrom.A_ProInfos ReaderBind(IDataReader dataReader)
{
VAN_OA.Model.EFrom.A_ProInfos model = new VAN_OA.Model.EFrom.A_ProInfos();
object ojb;
ojb = dataReader["ids"];
if (ojb != null && ojb != DBNull.Value)
{
model.ids = (int)ojb;
}
ojb = dataReader["pro_Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.pro_Id = (int)ojb;
}
ojb = dataReader["a_Role_Id"];
if (ojb != null && ojb != DBNull.Value)
{
model.a_Role_Id = (int)ojb;
}
ojb = dataReader["a_Index"];
if (ojb != null && ojb != DBNull.Value)
{
model.a_Index = (int)ojb;
}
ojb = dataReader["A_RoleName"];
if (ojb != null && ojb != DBNull.Value)
{
model.RoleName = (string)ojb;
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(VAN_OA.Model.EFrom.A_ProInfos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update A_ProInfos set ");
strSql.Append("pro_Id=" + model.pro_Id + ",");
strSql.Append("a_Role_Id=" + model.a_Role_Id + ",");
strSql.Append("a_Index=" + model.a_Index + "");
strSql.Append(" where ids=" + model.ids + "");
DBHelp.ExeCommand(strSql.ToString());
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(VAN_OA.Model.EFrom.A_ProInfos model, SqlCommand objCommand)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into A_ProInfos(");
strSql.Append("pro_Id,a_Role_Id,a_Index");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("" + model.pro_Id + ",");
strSql.Append("" + model.a_Role_Id + ",");
strSql.Append("" + model.a_Index + "");
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
objCommand.CommandText = strSql.ToString();
int result;
object obj = objCommand.ExecuteScalar();
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
