/// <summary>
/// 从行中读取数据映射到实体类的属性中
/// </summary>
/// <remarks></remarks>
private static Entity.account_Entity GetEntity(DataRow row)
{
Entity.account_Entity _obj = new Entity.account_Entity();
if (!row["ID"].Equals(DBNull.Value))
{
_obj.ID = Convert.ToInt32(row["ID"]);
}
if (!row["account_no"].Equals(DBNull.Value))
{
_obj.account_no = Convert.ToString(row["account_no"]);
}
if (!row["account_name"].Equals(DBNull.Value))
{
_obj.account_name = Convert.ToString(row["account_name"]);
}
if (!row["rg_code"].Equals(DBNull.Value))
{
_obj.rg_code = Convert.ToString(row["rg_code"]);
}
if (!row["type_code"].Equals(DBNull.Value))
{
_obj.type_code = Convert.ToString(row["type_code"]);
}
if (!row["type_name"].Equals(DBNull.Value))
{
_obj.type_name = Convert.ToString(row["type_name"]);
}
if (!row["AgencyNo"].Equals(DBNull.Value))
{
_obj.AgencyNo = Convert.ToString(row["AgencyNo"]);
}
return(_obj);
}
/// <summary>
/// 更新账户信息
/// </summary>
/// <param name="ai">用户实体</param>
/// <returns>影响行数</returns>
public static int Updateaccount(Entity.account_Entity ai)
{
string sequel = "DR_Updateaccount";
SqlParameter[] paras = (SqlParameter[])ValueParas(ai);
int result = SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, sequel, paras);
return(result);
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组Insert用
/// </summary>
/// <remarks></remarks>
private static IDbDataParameter[] ValueParas(Entity.account_Entity _obj)
{
SqlParameter[] paras = new SqlParameter[7];
paras[0] = new SqlParameter("@ID", _obj.ID);
paras[1] = new SqlParameter("@account_no", _obj.account_no);
paras[2] = new SqlParameter("@account_name", _obj.account_name);
paras[3] = new SqlParameter("@rg_code", _obj.rg_code);
paras[4] = new SqlParameter("@type_code", _obj.type_code);
paras[5] = new SqlParameter("@type_name", _obj.type_name);
paras[6] = new SqlParameter("@AgencyNo", _obj.AgencyNo);
paras[0].DbType = DbType.Int32;
paras[1].DbType = DbType.String;
paras[2].DbType = DbType.String;
paras[3].DbType = DbType.String;
paras[4].DbType = DbType.String;
paras[5].DbType = DbType.String;
paras[6].DbType = DbType.String;
return(paras);
}
public static int Updateaccount(Entity.account_Entity ai)
{
return(DAL.account_DAL.Updateaccount(ai));
}
