/// <summary>
/// 得到一个对象实体
/// </summary>
public WechatBuilder.Model.wx_ucard_users_consumeinfo DataRowToModel(DataRow row)
{
WechatBuilder.Model.wx_ucard_users_consumeinfo model = new WechatBuilder.Model.wx_ucard_users_consumeinfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["sId"] != null && row["sId"].ToString() != "")
{
model.sId = int.Parse(row["sId"].ToString());
}
if (row["uid"] != null && row["uid"].ToString() != "")
{
model.uid = int.Parse(row["uid"].ToString());
}
if (row["moduleType"] != null)
{
model.moduleType = row["moduleType"].ToString();
}
if (row["moduleTypeId"] != null && row["moduleTypeId"].ToString() != "")
{
model.moduleTypeId = int.Parse(row["moduleTypeId"].ToString());
}
if (row["moduleActionName"] != null)
{
model.moduleActionName = row["moduleActionName"].ToString();
}
if (row["moduleActionId"] != null && row["moduleActionId"].ToString() != "")
{
model.moduleActionId = int.Parse(row["moduleActionId"].ToString());
}
if (row["cScoreType"] != null && row["cScoreType"].ToString() != "")
{
model.cScoreType = int.Parse(row["cScoreType"].ToString());
}
if (row["score"] != null && row["score"].ToString() != "")
{
model.score = int.Parse(row["score"].ToString());
}
if (row["cMoneyType"] != null && row["cMoneyType"].ToString() != "")
{
model.cMoneyType = int.Parse(row["cMoneyType"].ToString());
}
if (row["consumeMoney"] != null && row["consumeMoney"].ToString() != "")
{
model.consumeMoney = decimal.Parse(row["consumeMoney"].ToString());
}
if (row["cContent"] != null)
{
model.cContent = row["cContent"].ToString();
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["addTime"] != null && row["addTime"].ToString() != "")
{
model.addTime = DateTime.Parse(row["addTime"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
if (row["sn"] != null)
{
model.sn = row["sn"].ToString();
}
if (row["operName"] != null)
{
model.operName = row["operName"].ToString();
}
if (row["pwd"] != null)
{
model.pwd = row["pwd"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WechatBuilder.Model.wx_ucard_users_consumeinfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,sId,uid,moduleType,moduleTypeId,moduleActionName,moduleActionId,cScoreType,score,cMoneyType,consumeMoney,cContent,remark,addTime,sort_id,sn,operName,pwd from wx_ucard_users_consumeinfo ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
WechatBuilder.Model.wx_ucard_users_consumeinfo model = new WechatBuilder.Model.wx_ucard_users_consumeinfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
