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