/// <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)); } }