public virtual bool AddOrdersPayment(OrdersPaymentInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Orders_Payment";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Orders_Payment_ID"] = entity.Orders_Payment_ID;
DrAdd["Orders_Payment_OrdersID"] = entity.Orders_Payment_OrdersID;
DrAdd["Orders_Payment_MemberID"] = entity.Orders_Payment_MemberID;
DrAdd["Orders_Payment_PaymentStatus"] = entity.Orders_Payment_PaymentStatus;
DrAdd["Orders_Payment_SysUserID"] = entity.Orders_Payment_SysUserID;
DrAdd["Orders_Payment_DocNo"] = entity.Orders_Payment_DocNo;
DrAdd["Orders_Payment_Name"] = entity.Orders_Payment_Name;
DrAdd["Orders_Payment_ApplyAmount"] = entity.Orders_Payment_ApplyAmount;
DrAdd["Orders_Payment_Amount"] = entity.Orders_Payment_Amount;
DrAdd["Orders_Payment_Status"] = entity.Orders_Payment_Status;
DrAdd["Orders_Payment_Note"] = entity.Orders_Payment_Note;
DrAdd["Orders_Payment_Addtime"] = entity.Orders_Payment_Addtime;
DrAdd["Orders_Payment_Site"] = entity.Orders_Payment_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public void EditOrdersPayment()
{
int Orders_Payment_ID = tools.CheckInt(Request.Form["Orders_Payment_ID"]);
int Orders_Payment_OrdersID = tools.CheckInt(Request.Form["Orders_Payment_OrdersID"]);
int Orders_Payment_PaymentStatus = tools.CheckInt(Request.Form["Orders_Payment_PaymentStatus"]);
int Orders_Payment_SysUserID = tools.CheckInt(Request.Form["Orders_Payment_SysUserID"]);
string Orders_Payment_DocNo = tools.CheckStr(Request.Form["Orders_Payment_DocNo"]);
string Orders_Payment_Name = tools.CheckStr(Request.Form["Orders_Payment_Name"]);
double Orders_Payment_Amount = tools.CheckFloat(Request.Form["Orders_Payment_Amount"]);
string Orders_Payment_Note = tools.CheckStr(Request.Form["Orders_Payment_Note"]);
OrdersPaymentInfo entity = new OrdersPaymentInfo();
entity.Orders_Payment_ID = Orders_Payment_ID;
entity.Orders_Payment_OrdersID = Orders_Payment_OrdersID;
entity.Orders_Payment_PaymentStatus = Orders_Payment_PaymentStatus;
entity.Orders_Payment_SysUserID = Orders_Payment_SysUserID;
entity.Orders_Payment_DocNo = Orders_Payment_DocNo;
entity.Orders_Payment_Name = Orders_Payment_Name;
entity.Orders_Payment_Amount = Orders_Payment_Amount;
entity.Orders_Payment_Note = Orders_Payment_Note;
entity.Orders_Payment_Addtime = DateTime.Now;
entity.Orders_Payment_Site = Public.GetCurrentSite();
if (MyBLL.EditOrdersPayment(entity))
{
Public.Msg("positive", "操作成功", "操作成功", true, "orders_payment_list.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual IList <OrdersPaymentInfo> GetOrdersPayments(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <OrdersPaymentInfo> entitys = null;
OrdersPaymentInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try {
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Orders_Payment";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersPaymentInfo>();
while (RdrList.Read())
{
entity = new OrdersPaymentInfo();
entity.Orders_Payment_ID = Tools.NullInt(RdrList["Orders_Payment_ID"]);
entity.Orders_Payment_OrdersID = Tools.NullInt(RdrList["Orders_Payment_OrdersID"]);
entity.Orders_Payment_MemberID = Tools.NullInt(RdrList["Orders_Payment_MemberID"]);
entity.Orders_Payment_PaymentStatus = Tools.NullInt(RdrList["Orders_Payment_PaymentStatus"]);
entity.Orders_Payment_SysUserID = Tools.NullInt(RdrList["Orders_Payment_SysUserID"]);
entity.Orders_Payment_DocNo = Tools.NullStr(RdrList["Orders_Payment_DocNo"]);
entity.Orders_Payment_Name = Tools.NullStr(RdrList["Orders_Payment_Name"]);
entity.Orders_Payment_ApplyAmount = Tools.NullDbl(RdrList["Orders_Payment_ApplyAmount"]);
entity.Orders_Payment_Amount = Tools.NullDbl(RdrList["Orders_Payment_Amount"]);
entity.Orders_Payment_Status = Tools.NullInt(RdrList["Orders_Payment_Status"]);
entity.Orders_Payment_Note = Tools.NullStr(RdrList["Orders_Payment_Note"]);
entity.Orders_Payment_Addtime = Tools.NullDate(RdrList["Orders_Payment_Addtime"]);
entity.Orders_Payment_Site = Tools.NullStr(RdrList["Orders_Payment_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual IList <OrdersPaymentInfo> GetOrdersPaymentsByOrdersID(int OrdersID)
{
IList <OrdersPaymentInfo> entitys = null;
OrdersPaymentInfo entity = null;
string SqlList = "";
SqlDataReader RdrList = null;
try
{
SqlList = "SELECT * FROM Orders_Payment WHERE Orders_Payment_OrdersID = " + OrdersID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <OrdersPaymentInfo>();
while (RdrList.Read())
{
entity = new OrdersPaymentInfo();
entity.Orders_Payment_ID = Tools.NullInt(RdrList["Orders_Payment_ID"]);
entity.Orders_Payment_OrdersID = Tools.NullInt(RdrList["Orders_Payment_OrdersID"]);
entity.Orders_Payment_MemberID = Tools.NullInt(RdrList["Orders_Payment_MemberID"]);
entity.Orders_Payment_PaymentStatus = Tools.NullInt(RdrList["Orders_Payment_PaymentStatus"]);
entity.Orders_Payment_SysUserID = Tools.NullInt(RdrList["Orders_Payment_SysUserID"]);
entity.Orders_Payment_DocNo = Tools.NullStr(RdrList["Orders_Payment_DocNo"]);
entity.Orders_Payment_Name = Tools.NullStr(RdrList["Orders_Payment_Name"]);
entity.Orders_Payment_ApplyAmount = Tools.NullDbl(RdrList["Orders_Payment_ApplyAmount"]);
entity.Orders_Payment_Amount = Tools.NullDbl(RdrList["Orders_Payment_Amount"]);
entity.Orders_Payment_Status = Tools.NullInt(RdrList["Orders_Payment_Status"]);
entity.Orders_Payment_Note = Tools.NullStr(RdrList["Orders_Payment_Note"]);
entity.Orders_Payment_Addtime = Tools.NullDate(RdrList["Orders_Payment_Addtime"]);
entity.Orders_Payment_Site = Tools.NullStr(RdrList["Orders_Payment_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual OrdersPaymentInfo GetOrdersPaymentByOrdersID(int Orders_ID, int Payment_Status)
{
OrdersPaymentInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Orders_Payment WHERE Orders_Payment_OrdersID = " + Orders_ID;
if (Payment_Status > 0)
{
SqlList += " AND Orders_Payment_PaymentStatus=" + Payment_Status;
}
SqlList += " ORDER BY Orders_Payment_ID DESC";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new OrdersPaymentInfo();
entity.Orders_Payment_ID = Tools.NullInt(RdrList["Orders_Payment_ID"]);
entity.Orders_Payment_OrdersID = Tools.NullInt(RdrList["Orders_Payment_OrdersID"]);
entity.Orders_Payment_MemberID = Tools.NullInt(RdrList["Orders_Payment_MemberID"]);
entity.Orders_Payment_PaymentStatus = Tools.NullInt(RdrList["Orders_Payment_PaymentStatus"]);
entity.Orders_Payment_SysUserID = Tools.NullInt(RdrList["Orders_Payment_SysUserID"]);
entity.Orders_Payment_DocNo = Tools.NullStr(RdrList["Orders_Payment_DocNo"]);
entity.Orders_Payment_Name = Tools.NullStr(RdrList["Orders_Payment_Name"]);
entity.Orders_Payment_ApplyAmount = Tools.NullDbl(RdrList["Orders_Payment_ApplyAmount"]);
entity.Orders_Payment_Amount = Tools.NullDbl(RdrList["Orders_Payment_Amount"]);
entity.Orders_Payment_Status = Tools.NullInt(RdrList["Orders_Payment_Status"]);
entity.Orders_Payment_Note = Tools.NullStr(RdrList["Orders_Payment_Note"]);
entity.Orders_Payment_Addtime = Tools.NullDate(RdrList["Orders_Payment_Addtime"]);
entity.Orders_Payment_Site = Tools.NullStr(RdrList["Orders_Payment_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditOrdersPayment(OrdersPaymentInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Orders_Payment WHERE Orders_Payment_ID = " + entity.Orders_Payment_ID;
DtAdd = DBHelper.Query(SqlAdd);
try {
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Orders_Payment_ID"] = entity.Orders_Payment_ID;
DrAdd["Orders_Payment_OrdersID"] = entity.Orders_Payment_OrdersID;
DrAdd["Orders_Payment_MemberID"] = entity.Orders_Payment_MemberID;
DrAdd["Orders_Payment_PaymentStatus"] = entity.Orders_Payment_PaymentStatus;
DrAdd["Orders_Payment_SysUserID"] = entity.Orders_Payment_SysUserID;
DrAdd["Orders_Payment_DocNo"] = entity.Orders_Payment_DocNo;
DrAdd["Orders_Payment_Name"] = entity.Orders_Payment_Name;
DrAdd["Orders_Payment_ApplyAmount"] = entity.Orders_Payment_ApplyAmount;
DrAdd["Orders_Payment_Amount"] = entity.Orders_Payment_Amount;
DrAdd["Orders_Payment_Status"] = entity.Orders_Payment_Status;
DrAdd["Orders_Payment_Note"] = entity.Orders_Payment_Note;
DrAdd["Orders_Payment_Addtime"] = entity.Orders_Payment_Addtime;
DrAdd["Orders_Payment_Site"] = entity.Orders_Payment_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
return(true);
}
public void changeOrdersPayment()
{
int Orders_Payment_ID = tools.CheckInt(Request["Orders_Payment_ID"]);
int Orders_Payment_OrdersID = tools.CheckInt(Request["Orders_Payment_OrdersID"]);
double Orders_Payment_Amount = tools.CheckInt(Request["Orders_Payment_Amount"]);
string paymentmemo = "";
OrdersPaymentInfo entity = MyBLL.GetOrdersPaymentByID(Orders_Payment_ID);
if (entity != null)
{
entity.Orders_Payment_Amount = Orders_Payment_Amount;
entity.Orders_Payment_Status = 1;
paymentmemo = entity.Orders_Payment_DocNo;
if (MyBLL.EditOrdersPayment(entity))
{
orderlog.Orders_Log(Orders_Payment_OrdersID, Session["User_Name"].ToString(), "退款申请单审核", "通过", "订单号：" + paymentmemo + " 退款申请通过");
Public.Msg("positive", "操作成功", "操作成功", true, "orders_payment_applylist.aspx");
}
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual bool EditOrdersPayment(OrdersPaymentInfo entity)
{
return(MyDAL.EditOrdersPayment(entity));
}
public virtual bool AddOrdersPayment(OrdersPaymentInfo entity)
{
return(MyDAL.AddOrdersPayment(entity));
}
