public List<SmsPeopleOR> selectSmsPeopleData(string orgbhWhere)
{
if (string.IsNullOrEmpty(orgbhWhere))
return null;
string sql = @"select bu.* from t_SmsPeople bu
inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere;
DataTable dt = null;
try
{
dt = dbMsSql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
List<SmsPeopleOR> listSmsP = new List<SmsPeopleOR>();
foreach (DataRow dr in dt.Rows)
{
SmsPeopleOR obj = new SmsPeopleOR(dr);
listSmsP.Add(obj);
}
return listSmsP;
}
/// <summary>
/// 获取插入数据
/// </summary>
public string GetInsertSql(SmsPeopleOR smsPeople)
{
string sql = @"insert into t_SmsPeople (Id,Name,MobileNO,SendMoney,Description,
orgbh)
values ('@Id','@Name','@MobileNO',SendMoney,'@Description',
'@orgbh')";
sql = sql.Replace("@Id", smsPeople.Id); //
sql = sql.Replace("@Name", smsPeople.Name); //姓名
sql = sql.Replace("@MobileNO", smsPeople.Mobileno); //手机号码
sql = sql.Replace("@SendMoney", smsPeople.Sendmoney.ToString()); //发送金额
sql = sql.Replace("@Description", smsPeople.Description); //描述
sql = sql.Replace("@orgbh", smsPeople.Orgbh); //所属机构
return sql;
}