/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateM_CreditInfo(M_CreditInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_M_CreditInfo set ");
strSql.Append("m_UserInfoID=@m_UserInfoID,");
strSql.Append("m_Type=@m_Type,");
strSql.Append("m_level=@m_level,");
strSql.Append("score=@score,");
strSql.Append("total_num=@total_num,");
strSql.Append("good_num=@good_num,");
strSql.Append("last_updatetime=@last_updatetime");
strSql.Append(" where m_CreditInfoID=@m_CreditInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@m_CreditInfoID", SqlDbType.Int, 4),
new SqlParameter("@m_UserInfoID", SqlDbType.Int, 4),
new SqlParameter("@m_Type", SqlDbType.Int, 4),
new SqlParameter("@m_level", SqlDbType.Int, 4),
new SqlParameter("@score", SqlDbType.Int, 4),
new SqlParameter("@total_num", SqlDbType.Int, 4),
new SqlParameter("@good_num", SqlDbType.Int, 4),
new SqlParameter("@last_updatetime", SqlDbType.DateTime)
};
parameters[0].Value = model.m_CreditInfoID;
parameters[1].Value = model.m_UserInfoID;
parameters[2].Value = model.m_Type;
parameters[3].Value = model.m_level;
parameters[4].Value = model.score;
parameters[5].Value = model.total_num;
parameters[6].Value = model.good_num;
parameters[7].Value = model.last_updatetime;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public M_CreditInfo GetM_CreditInfoModel(int m_CreditInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 m_CreditInfoID,m_UserInfoID,m_Type,m_level,score,total_num,good_num,last_updatetime from tb_M_CreditInfo ");
strSql.Append(" where m_CreditInfoID=@m_CreditInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@m_CreditInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = m_CreditInfoID;
M_CreditInfo model = new M_CreditInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["m_CreditInfoID"].ToString() != "")
{
model.m_CreditInfoID = int.Parse(ds.Tables[0].Rows[0]["m_CreditInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["m_UserInfoID"].ToString() != "")
{
model.m_UserInfoID = int.Parse(ds.Tables[0].Rows[0]["m_UserInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["m_Type"].ToString() != "")
{
model.m_Type = int.Parse(ds.Tables[0].Rows[0]["m_Type"].ToString());
}
if (ds.Tables[0].Rows[0]["m_level"].ToString() != "")
{
model.m_level = int.Parse(ds.Tables[0].Rows[0]["m_level"].ToString());
}
if (ds.Tables[0].Rows[0]["score"].ToString() != "")
{
model.score = int.Parse(ds.Tables[0].Rows[0]["score"].ToString());
}
if (ds.Tables[0].Rows[0]["total_num"].ToString() != "")
{
model.total_num = int.Parse(ds.Tables[0].Rows[0]["total_num"].ToString());
}
if (ds.Tables[0].Rows[0]["good_num"].ToString() != "")
{
model.good_num = int.Parse(ds.Tables[0].Rows[0]["good_num"].ToString());
}
if (ds.Tables[0].Rows[0]["last_updatetime"].ToString() != "")
{
model.last_updatetime = DateTime.Parse(ds.Tables[0].Rows[0]["last_updatetime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddM_CreditInfo(M_CreditInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_M_CreditInfo(");
strSql.Append("m_UserInfoID,m_Type,m_level,score,total_num,good_num,last_updatetime)");
strSql.Append(" values (");
strSql.Append("@m_UserInfoID,@m_Type,@m_level,@score,@total_num,@good_num,@last_updatetime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@m_UserInfoID", SqlDbType.Int, 4),
new SqlParameter("@m_Type", SqlDbType.Int, 4),
new SqlParameter("@m_level", SqlDbType.Int, 4),
new SqlParameter("@score", SqlDbType.Int, 4),
new SqlParameter("@total_num", SqlDbType.Int, 4),
new SqlParameter("@good_num", SqlDbType.Int, 4),
new SqlParameter("@last_updatetime", SqlDbType.DateTime)
};
parameters[0].Value = model.m_UserInfoID;
parameters[1].Value = model.m_Type;
parameters[2].Value = model.m_level;
parameters[3].Value = model.score;
parameters[4].Value = model.total_num;
parameters[5].Value = model.good_num;
parameters[6].Value = model.last_updatetime;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}