/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_appreport model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_appreport("); strSql.Append("a_successratio,a_alipay,a_wechat,a_curr,a_arpur,a_datetime,a_time,a_appname,a_appid,a_uerid,a_equipment,a_count,a_success,a_notpay,a_request,a_money,a_qqwallet"); strSql.Append(") values ("); strSql.Append("@a_successratio,@a_alipay,@a_wechat,@a_curr,@a_arpur,@a_datetime,@a_time,@a_appname,@a_appid,@a_uerid,@a_equipment,@a_count,@a_success,@a_notpay,@a_request,@a_money,@a_qqwallet"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@a_successratio", SqlDbType.Decimal, 9), new SqlParameter("@a_alipay", SqlDbType.Decimal, 9), new SqlParameter("@a_wechat", SqlDbType.Decimal, 9), new SqlParameter("@a_curr", SqlDbType.Decimal, 9), new SqlParameter("@a_arpur", SqlDbType.Decimal, 9), new SqlParameter("@a_datetime", SqlDbType.DateTime), new SqlParameter("@a_time", SqlDbType.DateTime), new SqlParameter("@a_appname", SqlDbType.NVarChar, -1), new SqlParameter("@a_appid", SqlDbType.Int, 4), new SqlParameter("@a_uerid", SqlDbType.Int, 4), new SqlParameter("@a_equipment", SqlDbType.Decimal, 9), new SqlParameter("@a_count", SqlDbType.Decimal, 9), new SqlParameter("@a_success", SqlDbType.Decimal, 9), new SqlParameter("@a_notpay", SqlDbType.Decimal, 9), new SqlParameter("@a_request", SqlDbType.Decimal, 9), new SqlParameter("@a_money", SqlDbType.Decimal, 9), new SqlParameter("@a_qqwallet", SqlDbType.Decimal, 9) }; parameters[0].Value = model.a_successratio; parameters[1].Value = model.a_alipay; parameters[2].Value = model.a_wechat; parameters[3].Value = model.a_curr; parameters[4].Value = model.a_arpur; parameters[5].Value = model.a_datetime; parameters[6].Value = model.a_time; parameters[7].Value = model.a_appname; parameters[8].Value = model.a_appid; parameters[9].Value = model.a_uerid; parameters[10].Value = model.a_equipment; parameters[11].Value = model.a_count; parameters[12].Value = model.a_success; parameters[13].Value = model.a_notpay; parameters[14].Value = model.a_request; parameters[15].Value = model.a_money; parameters[16].Value = model.a_qqwallet; object obj = DbHelperSQLTotal.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_appreport model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_appreport set "); strSql.Append(" a_successratio = @a_successratio , "); strSql.Append(" a_alipay = @a_alipay , "); strSql.Append(" a_wechat = @a_wechat , "); strSql.Append(" a_curr = @a_curr , "); strSql.Append(" a_arpur = @a_arpur , "); strSql.Append(" a_datetime = @a_datetime , "); strSql.Append(" a_time = @a_time , "); strSql.Append(" a_appname = @a_appname , "); strSql.Append(" a_appid = @a_appid , "); strSql.Append(" a_uerid = @a_uerid , "); strSql.Append(" a_equipment = @a_equipment , "); strSql.Append(" a_count = @a_count , "); strSql.Append(" a_success = @a_success , "); strSql.Append(" a_notpay = @a_notpay , "); strSql.Append(" a_request = @a_request, "); strSql.Append(" a_money=@a_money "); strSql.Append(" a_qqwallet=@a_qqwallet "); strSql.Append(" where a_id=@a_id "); SqlParameter[] parameters = { new SqlParameter("@a_id", SqlDbType.Int, 4), new SqlParameter("@a_successratio", SqlDbType.Decimal, 9), new SqlParameter("@a_alipay", SqlDbType.Decimal, 9), new SqlParameter("@a_wechat", SqlDbType.Decimal, 9), new SqlParameter("@a_curr", SqlDbType.Decimal, 9), new SqlParameter("@a_arpur", SqlDbType.Decimal, 9), new SqlParameter("@a_datetime", SqlDbType.DateTime), new SqlParameter("@a_time", SqlDbType.DateTime), new SqlParameter("@a_appname", SqlDbType.NVarChar, -1), new SqlParameter("@a_appid", SqlDbType.Int, 4), new SqlParameter("@a_uerid", SqlDbType.Int, 4), new SqlParameter("@a_equipment", SqlDbType.Decimal, 9), new SqlParameter("@a_count", SqlDbType.Decimal, 9), new SqlParameter("@a_success", SqlDbType.Decimal, 9), new SqlParameter("@a_notpay", SqlDbType.Decimal, 9), new SqlParameter("@a_request", SqlDbType.Decimal, 9), new SqlParameter("@a_money", SqlDbType.Decimal, 9), new SqlParameter("@a_qqwallet", SqlDbType.Decimal, 9) }; parameters[0].Value = model.a_id; parameters[1].Value = model.a_successratio; parameters[2].Value = model.a_alipay; parameters[3].Value = model.a_wechat; parameters[4].Value = model.a_curr; parameters[5].Value = model.a_arpur; parameters[6].Value = model.a_datetime; parameters[7].Value = model.a_time; parameters[8].Value = model.a_appname; parameters[9].Value = model.a_appid; parameters[10].Value = model.a_uerid; parameters[11].Value = model.a_equipment; parameters[12].Value = model.a_count; parameters[13].Value = model.a_success; parameters[14].Value = model.a_notpay; parameters[15].Value = model.a_request; parameters[16].Value = model.a_money; parameters[17].Value = model.a_qqwallet; int rows = DbHelperSQLTotal.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_appreport GetModel(int a_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select a_id, a_successratio, a_alipay, a_wechat, a_curr, a_arpur, a_datetime, a_time, a_appname, a_appid, a_uerid, a_equipment, a_count, a_success, a_notpay, a_request,a_money,a_qqwallet "); strSql.Append(" from jmp_appreport "); strSql.Append(" where a_id=@a_id"); SqlParameter[] parameters = { new SqlParameter("@a_id", SqlDbType.Int, 4) }; parameters[0].Value = a_id; JMP.MDL.jmp_appreport model = new JMP.MDL.jmp_appreport(); DataSet ds = DbHelperSQLTotal.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["a_id"].ToString() != "") { model.a_id = int.Parse(ds.Tables[0].Rows[0]["a_id"].ToString()); } if (ds.Tables[0].Rows[0]["a_successratio"].ToString() != "") { model.a_successratio = decimal.Parse(ds.Tables[0].Rows[0]["a_successratio"].ToString()); } if (ds.Tables[0].Rows[0]["a_alipay"].ToString() != "") { model.a_alipay = decimal.Parse(ds.Tables[0].Rows[0]["a_alipay"].ToString()); } if (ds.Tables[0].Rows[0]["a_wechat"].ToString() != "") { model.a_wechat = decimal.Parse(ds.Tables[0].Rows[0]["a_wechat"].ToString()); } if (ds.Tables[0].Rows[0]["a_curr"].ToString() != "") { model.a_curr = decimal.Parse(ds.Tables[0].Rows[0]["a_curr"].ToString()); } if (ds.Tables[0].Rows[0]["a_arpur"].ToString() != "") { model.a_arpur = decimal.Parse(ds.Tables[0].Rows[0]["a_arpur"].ToString()); } if (ds.Tables[0].Rows[0]["a_datetime"].ToString() != "") { model.a_datetime = DateTime.Parse(ds.Tables[0].Rows[0]["a_datetime"].ToString()); } if (ds.Tables[0].Rows[0]["a_time"].ToString() != "") { model.a_time = DateTime.Parse(ds.Tables[0].Rows[0]["a_time"].ToString()); } model.a_appname = ds.Tables[0].Rows[0]["a_appname"].ToString(); if (ds.Tables[0].Rows[0]["a_appid"].ToString() != "") { model.a_appid = int.Parse(ds.Tables[0].Rows[0]["a_appid"].ToString()); } if (ds.Tables[0].Rows[0]["a_uerid"].ToString() != "") { model.a_uerid = int.Parse(ds.Tables[0].Rows[0]["a_uerid"].ToString()); } if (ds.Tables[0].Rows[0]["a_equipment"].ToString() != "") { model.a_equipment = decimal.Parse(ds.Tables[0].Rows[0]["a_equipment"].ToString()); } if (ds.Tables[0].Rows[0]["a_count"].ToString() != "") { model.a_count = decimal.Parse(ds.Tables[0].Rows[0]["a_count"].ToString()); } if (ds.Tables[0].Rows[0]["a_success"].ToString() != "") { model.a_success = decimal.Parse(ds.Tables[0].Rows[0]["a_success"].ToString()); } if (ds.Tables[0].Rows[0]["a_notpay"].ToString() != "") { model.a_notpay = decimal.Parse(ds.Tables[0].Rows[0]["a_notpay"].ToString()); } if (ds.Tables[0].Rows[0]["a_request"].ToString() != "") { model.a_request = decimal.Parse(ds.Tables[0].Rows[0]["a_request"].ToString()); } if (ds.Tables[0].Rows[0]["a_money"].ToString() != "") { model.a_money = decimal.Parse(ds.Tables[0].Rows[0]["a_money"].ToString()); } if (ds.Tables[0].Rows[0]["a_qqwallet"].ToString() != "") { model.a_qqwallet = decimal.Parse(ds.Tables[0].Rows[0]["a_qqwallet"].ToString()); } return(model); } else { return(null); } }