/// <summary>
/// 增加一条数据
/// </summary>
public void Add(JMP.MDL.jmp_order_audit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jmp_order_audit(");
strSql.Append("order_amount,created_on,is_processed,processed_time,processed_by,processed_result,order_code,order_table_name,app_id,message,trade_no,payment_time,payment_amount,payment_status,is_send_message,message_send_time");
strSql.Append(") values (");
strSql.Append("@order_amount,@created_on,@is_processed,@processed_time,@processed_by,@processed_result,@order_code,@order_table_name,@app_id,@message,@trade_no,@payment_time,@payment_amount,@payment_status,@is_send_message,@message_send_time");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@order_amount", SqlDbType.Decimal, 5),
new SqlParameter("@created_on", SqlDbType.DateTime),
new SqlParameter("@is_processed", SqlDbType.Int, 4),
new SqlParameter("@processed_time", SqlDbType.DateTime),
new SqlParameter("@processed_by", SqlDbType.NVarChar, 30),
new SqlParameter("@processed_result", SqlDbType.NVarChar, -1),
new SqlParameter("@order_code", SqlDbType.NVarChar, -1),
new SqlParameter("@order_table_name", SqlDbType.NVarChar, 30),
new SqlParameter("@app_id", SqlDbType.Int, 4),
new SqlParameter("@message", SqlDbType.NVarChar, -1),
new SqlParameter("@trade_no", SqlDbType.NVarChar, -1),
new SqlParameter("@payment_time", SqlDbType.DateTime),
new SqlParameter("@payment_amount", SqlDbType.Decimal, 5),
new SqlParameter("@payment_status", SqlDbType.NVarChar, 255),
new SqlParameter("@is_send_message", SqlDbType.Int, 4),
new SqlParameter("@message_send_time", SqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.order_amount;
parameters[2].Value = model.created_on;
parameters[3].Value = model.is_processed;
parameters[4].Value = model.processed_time;
parameters[5].Value = model.processed_by;
parameters[6].Value = model.processed_result;
parameters[7].Value = model.order_code;
parameters[8].Value = model.order_table_name;
parameters[9].Value = model.app_id;
parameters[10].Value = model.message;
parameters[11].Value = model.trade_no;
parameters[12].Value = model.payment_time;
parameters[13].Value = model.payment_amount;
parameters[14].Value = model.payment_status;
parameters[15].Value = model.is_send_message;
parameters[16].Value = model.message_send_time;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.jmp_order_audit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jmp_order_audit set ");
strSql.Append(" id = @id , ");
strSql.Append(" order_amount = @order_amount , ");
strSql.Append(" created_on = @created_on , ");
strSql.Append(" is_processed = @is_processed , ");
strSql.Append(" processed_time = @processed_time , ");
strSql.Append(" processed_by = @processed_by , ");
strSql.Append(" processed_result = @processed_result , ");
strSql.Append(" order_code = @order_code , ");
strSql.Append(" order_table_name = @order_table_name , ");
strSql.Append(" app_id = @app_id , ");
strSql.Append(" message = @message , ");
strSql.Append(" trade_no = @trade_no , ");
strSql.Append(" payment_time = @payment_time , ");
strSql.Append(" payment_amount = @payment_amount , ");
strSql.Append(" payment_status = @payment_status , ");
strSql.Append(" is_send_message = @is_send_message , ");
strSql.Append(" message_send_time = @message_send_time ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@order_amount", SqlDbType.Decimal, 5),
new SqlParameter("@created_on", SqlDbType.DateTime),
new SqlParameter("@is_processed", SqlDbType.Int, 4),
new SqlParameter("@processed_time", SqlDbType.DateTime),
new SqlParameter("@processed_by", SqlDbType.NVarChar, 30),
new SqlParameter("@processed_result", SqlDbType.NVarChar, -1),
new SqlParameter("@order_code", SqlDbType.NVarChar, -1),
new SqlParameter("@order_table_name", SqlDbType.NVarChar, 30),
new SqlParameter("@app_id", SqlDbType.Int, 4),
new SqlParameter("@message", SqlDbType.NVarChar, -1),
new SqlParameter("@trade_no", SqlDbType.NVarChar, -1),
new SqlParameter("@payment_time", SqlDbType.DateTime),
new SqlParameter("@payment_amount", SqlDbType.Decimal, 5),
new SqlParameter("@payment_status", SqlDbType.NVarChar, 255),
new SqlParameter("@is_send_message", SqlDbType.Int, 4),
new SqlParameter("@message_send_time", SqlDbType.DateTime)
};
parameters[0].Value = model.id;
parameters[1].Value = model.order_amount;
parameters[2].Value = model.created_on;
parameters[3].Value = model.is_processed;
parameters[4].Value = model.processed_time;
parameters[5].Value = model.processed_by;
parameters[6].Value = model.processed_result;
parameters[7].Value = model.order_code;
parameters[8].Value = model.order_table_name;
parameters[9].Value = model.app_id;
parameters[10].Value = model.message;
parameters[11].Value = model.trade_no;
parameters[12].Value = model.payment_time;
parameters[13].Value = model.payment_amount;
parameters[14].Value = model.payment_status;
parameters[15].Value = model.is_send_message;
parameters[16].Value = model.message_send_time;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.jmp_order_audit GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, order_amount, created_on, is_processed, processed_time, processed_by, processed_result, order_code, order_table_name, app_id, message, trade_no, payment_time, payment_amount, payment_status,is_send_message,message_send_time");
strSql.Append(" from jmp_order_audit ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
JMP.MDL.jmp_order_audit model = new JMP.MDL.jmp_order_audit();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["order_amount"].ToString() != "")
{
model.order_amount = decimal.Parse(ds.Tables[0].Rows[0]["order_amount"].ToString());
}
if (ds.Tables[0].Rows[0]["created_on"].ToString() != "")
{
model.created_on = DateTime.Parse(ds.Tables[0].Rows[0]["created_on"].ToString());
}
if (ds.Tables[0].Rows[0]["is_processed"].ToString() != "")
{
model.is_processed = int.Parse(ds.Tables[0].Rows[0]["is_processed"].ToString());
}
if (ds.Tables[0].Rows[0]["processed_time"].ToString() != "")
{
model.processed_time = DateTime.Parse(ds.Tables[0].Rows[0]["processed_time"].ToString());
}
model.processed_by = ds.Tables[0].Rows[0]["processed_by"].ToString();
model.processed_result = ds.Tables[0].Rows[0]["processed_result"].ToString();
model.order_code = ds.Tables[0].Rows[0]["order_code"].ToString();
model.order_table_name = ds.Tables[0].Rows[0]["order_table_name"].ToString();
if (ds.Tables[0].Rows[0]["app_id"].ToString() != "")
{
model.app_id = int.Parse(ds.Tables[0].Rows[0]["app_id"].ToString());
}
model.message = ds.Tables[0].Rows[0]["message"].ToString();
model.trade_no = ds.Tables[0].Rows[0]["trade_no"].ToString();
if (ds.Tables[0].Rows[0]["payment_time"].ToString() != "")
{
model.payment_time = DateTime.Parse(ds.Tables[0].Rows[0]["payment_time"].ToString());
}
if (ds.Tables[0].Rows[0]["payment_amount"].ToString() != "")
{
model.payment_amount = decimal.Parse(ds.Tables[0].Rows[0]["payment_amount"].ToString());
}
model.payment_status = ds.Tables[0].Rows[0]["payment_status"].ToString();
if (ds.Tables[0].Rows[0]["message_send_time"].ToString() != "")
{
model.message_send_time = DateTime.Parse(ds.Tables[0].Rows[0]["message_send_time"].ToString());
}
if (ds.Tables[0].Rows[0]["is_send_message"].ToString() != "")
{
model.is_send_message = int.Parse(ds.Tables[0].Rows[0]["is_send_message"].ToString());
}
return(model);
}
else
{
return(null);
}
}
