public bool Update(SystemClaimsDetails model, List <string> fileds, string sqlWhere) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("update {0} set ", model.GetType().Name); List <string> filedsList = new List <string>(); List <SqlParameter> sqlParameter = new List <SqlParameter>(); SqlParameter Param = new SqlParameter("@ID", SqlDbType.Int, 4); if (string.IsNullOrEmpty(sqlWhere)) { Param.Value = model.ID; sqlParameter.Add(Param); } foreach (string filed in fileds) { filedsList.Add(string.Format("{0}=@{0}", filed)); Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null)); sqlParameter.Add(Param); } strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray())); if (string.IsNullOrEmpty(sqlWhere)) { strSql.Append(" where ID=@ID "); } else { strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere); } SqlParameter[] parameters = sqlParameter.ToArray(); return(db.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }
/// <summary> /// 得到一个对象实体 /// </summary> public SystemClaimsDetails GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, ClaimsID, InvestorsID, InvestorsCellPhone, InvestorMoney, InvestorsTime, DayEarnings,ExpireEarnings, PayStatus,PayMark "); strSql.Append(" from SystemClaimsDetails "); strSql.Append(" where "); strSql.Append(where); var dt = db.GetTable(strSql.ToString()); SystemClaimsDetails model = null; if (dt.Rows.Count > 0) { model = Mapper.DynamicMap <IDataReader, List <SystemClaimsDetails> >(dt.CreateDataReader()).FirstOrDefault(); } return(model); }