/// <summary>
/// 得到一个对象实体
/// </summary>
public Bitshare.DataDecision.Model.OperationOrFunctionUser GetModel(string UserName, string rf_Type, string OperRational_Name, string rf_Right_Authority)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserName,rf_Type,OperRational_Name,rf_Right_Authority from OperationOrFunctionUser ");
strSql.Append(" where UserName=@UserName and rf_Type=@rf_Type and OperRational_Name=@OperRational_Name and rf_Right_Authority=@rf_Right_Authority ");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@rf_Type", SqlDbType.VarChar, 50),
new SqlParameter("@OperRational_Name", SqlDbType.VarChar, 50),
new SqlParameter("@rf_Right_Authority", SqlDbType.VarChar, 50)
};
parameters[0].Value = UserName;
parameters[1].Value = rf_Type;
parameters[2].Value = OperRational_Name;
parameters[3].Value = rf_Right_Authority;
Bitshare.DataDecision.Model.OperationOrFunctionUser model = new Bitshare.DataDecision.Model.OperationOrFunctionUser();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bitshare.DataDecision.Model.OperationOrFunctionUser DataRowToModel(DataRow row)
{
Bitshare.DataDecision.Model.OperationOrFunctionUser model = new Bitshare.DataDecision.Model.OperationOrFunctionUser();
if (row != null)
{
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["rf_Type"] != null)
{
model.rf_Type = row["rf_Type"].ToString();
}
if (row["OperRational_Name"] != null)
{
model.OperRational_Name = row["OperRational_Name"].ToString();
}
if (row["rf_Right_Authority"] != null)
{
model.rf_Right_Authority = row["rf_Right_Authority"].ToString();
}
}
return(model);
}
