using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.WebService;
|
using System.Data;
|
using System.Data.SqlClient;
|
using CY.WebService.Logging;
|
|
namespace CyinOrderWebService
|
{
|
public class WebServiceBLL
|
{
|
/// <summary>
|
/// 自动对规定时间内的订单进行收货操作
|
/// </summary>
|
public void AcceptOverTimeOrder()
|
{
|
try
|
{
|
List<int> d = new List<int>();
|
Database _dataBase = new Database();
|
DataTable OrderTable = _dataBase.SelectModel(" * ", " EC_OrderBasic ", string.Format(" OrderState <> 1 AND OrderState <> 6 AND OrderState <> -1 AND OrderState > 0 AND DeliveryTime <=GETDATE() AND OrderTypeId <=0 "));//执行查询
|
DataRow[] result = OrderTable.Select();
|
int i = -1;
|
while (++i < result.Length)
|
{
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter(){ParameterName="@returnValue",Direction=ParameterDirection.ReturnValue,SqlDbType=SqlDbType.Int,DbType=DbType.Int32},
|
new SqlParameter(){ParameterName="@orderId",Value=int.Parse(result[i]["Keyid"].ToString())},
|
new SqlParameter(){ParameterName="@memberId",Value=Guid.Parse(result[i]["BuyerId"].ToString()),SqlDbType=SqlDbType.UniqueIdentifier}
|
};
|
_dataBase.Query("sp_EC_Order_AcceptById", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetAdapter log_Log4NetAdapter = new Log4NetAdapter();
|
log_Log4NetAdapter.Log(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 自动删除超过规定时间的线上订单
|
/// </summary>
|
public void DelOverTimeOrder()
|
{
|
try
|
{
|
List<int> d = new List<int>();
|
Database _dataBase = new Database();
|
DataTable OrderTable = _dataBase.SelectModel(" * ", " EC_OrderBasic ", string.Format(" PayState = 0 AND OrderState = 1 AND CreateTime <='{0}' AND OrderTypeId <=0 ", DateTime.Now.AddDays(-int.Parse(System.Configuration.ConfigurationManager.AppSettings["OrderOverDays"].ToString())).ToString()));//执行查询
|
DataRow[] result = OrderTable.Select();
|
int i = -1;
|
while (++i < result.Length)
|
{
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter(){ParameterName="@Keyid",Value=int.Parse(result[i]["Keyid"].ToString())}
|
};
|
_dataBase.Query("sp_EC_OrderBasic_DeleteOnlineOverTime", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetAdapter log_Log4NetAdapter = new Log4NetAdapter();
|
log_Log4NetAdapter.Log(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 自动删除超过规定时间的线上订单
|
/// </summary>
|
public void RemovedlOverTimeOrder()
|
{
|
try
|
{
|
string time = DateTime.Now.AddDays(-int.Parse(System.Configuration.ConfigurationManager.AppSettings["RecruitmentsOverDays"].ToString())).ToString();
|
Database _dataBase = new Database();
|
_dataBase.ExecuteSql(" UPDATE OA_StaffRecruitments SET R_Status='1' WHERE R_Status='2' AND R_StartTime <='" + time + "' ");
|
}
|
catch (Exception ex)
|
{
|
Log4NetAdapter log_Log4NetAdapter = new Log4NetAdapter();
|
log_Log4NetAdapter.Log(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 将已到期会员状态修改为已到期
|
/// </summary>
|
public void SetMemberStatus()
|
{
|
try
|
{
|
List<int> d = new List<int>();
|
Database _dataBase = new Database();
|
DataTable OrderTable = _dataBase.SelectModel(" * ", " EC_MemberBasic ", string.Format(" MemberType = '印刷厂商' AND ExpirationTime <= GETDATE() AND UseState='3' "));//执行查询
|
DataRow[] result = OrderTable.Select();
|
int i = -1;
|
while (++i < result.Length)
|
{
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter(){ParameterName="@MemberId",Value=Guid.Parse(result[i]["MemberId"].ToString()),SqlDbType=SqlDbType.UniqueIdentifier},
|
new SqlParameter(){ParameterName="@UseState",Value=1}
|
};
|
_dataBase.Query("sp_EC_MemberBasic_FirmOverTime", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetAdapter log_Log4NetAdapter = new Log4NetAdapter();
|
log_Log4NetAdapter.Log(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 15天未还款自动降低客户信誉
|
/// </summary>
|
public void LowerCreditLevel()
|
{
|
try
|
{
|
Database _dataBase = new Database();
|
DataTable OrderTable = _dataBase.SelectModel(" t.PayeeId,MIN(t.CreateTime) AS CreateTime ", " (SELECT PayeeId,CreateTime FROM dbo.Pay_IncExpRecord AS a WHERE a.BalanceAccount='9' AND a.TradingType=1 AND a.Keyid > ISNULL((SELECT TOP(1) Keyid FROM dbo.Pay_IncExpRecord WHERE BalanceAccount='14' AND a.PayeeId = PayId ORDER BY Keyid DESC),0) AND a.CreateTime > ISNULL((SELECT TOP(1) CreateTime FROM dbo.Pay_CreditRecard WHERE a.PayeeId = PayId ORDER BY Keyid DESC),'2000-01-01 00:00:00')) t ", string.Format(" 1=1 GROUP BY t.PayeeId ORDER BY MIN(t.CreateTime) "));//执行查询
|
DataRow[] result = OrderTable.Select();
|
int i = -1;
|
while (++i < result.Length)
|
{
|
int Payeeid = int.Parse(result[i]["PayeeId"].ToString());
|
DateTime CreatTime = DateTime.Parse(result[i]["CreateTime"].ToString());
|
if (CreatTime.AddDays(15) < DateTime.Now)
|
{
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter(){ParameterName="@PayeeId",Value=Payeeid}
|
};
|
_dataBase.Query("sp_Pay_PaymentAccount_LowerCreditLevel", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
Log4NetAdapter log_Log4NetAdapter = new Log4NetAdapter();
|
log_Log4NetAdapter.Log(ex.Message);
|
}
|
}
|
}
|
}
|
