public JsonResult CPay_add(string id, string money, string date)
{
CustomerPay en = new CustomerPay();
en.contractID = id;
en.money = Convert.ToDouble(money);
en.date = Convert.ToDateTime(date);
DaCustomerPay dal = new DaCustomerPay();
var result = new CustomJsonResult();
result.Data = dal.add(en);
return(result);
}
/// <summary>
/// 登记到账
/// </summary>
/// <param name="en">实体</param>
/// <returns></returns>
public int add(CustomerPay en)
{
string strSql = "insert into CustomerPay (contractID, orderID, money, date, backHandler) values (@contractID, @orderID, @money, @date, @back)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@contractID", en.contractID),
new SqlParameter("@orderID", en.orderID),
new SqlParameter("@money", en.money),
new SqlParameter("@date", en.date),
new SqlParameter("@back", en.backHandler)
};
int result = SqlHelper.ExecuteNonQuery(BaseHelper.DBConnStr, CommandType.Text, strSql, param);
return(result);
}
internal CustomerPay Return(int DirCustomersID)
{
CustomerPay customerPay = new CustomerPay();
customerPay.PayDateEnd = DateTime.Now.AddMonths(1);
using (Models.DbConnectionLogin db = new Models.DbConnectionLogin("ConnStrMSSQL"))
{
#region 1. Данные с таблицы DirCustomers (Дата и Платный) и формирование данных
//Выборка с таблицы "DirCustomers"
var query1 = db.DirCustomers.Where(x => x.DirCustomersID == DirCustomersID).ToList();
if (query1.Count() > 0)
{
customerPay.DirCustomersDate = Convert.ToDateTime(query1[0].DirCustomersDate);
customerPay.Pay = Convert.ToBoolean(query1[0].Pay);
}
/*
* //Формирование данных
* if (customerPay.DirCustomersDate.AddMonths(1) >= DateTime.Now.Date) //customerPay.Pay &&
* {
* customerPay.DirPayServiceID = -1; //-1;
* customerPay.DirPayServiceName = "BUSINESS"; //"Пробный";
* customerPay.CountUser = 1; //К-во пользователей
* //customerPay.CountTT = 1; //К-во ТТ
* //customerPay.CountIM = 1; //К-во ИМ
* customerPay.CountNomen = -1; //К-во Номенклатуры
* customerPay.CountContr = -1; //К-во Документов
* }
* else
* {
* customerPay.DirPayServiceID = 0; //0;
* customerPay.DirPayServiceName = "FREE"; //"Начинающий";
* customerPay.CountUser = 1; //К-во пользователей
* //customerPay.CountTT = 0; //К-во ТТ
* //customerPay.CountIM = 0; //К-во ИМ
* customerPay.CountNomen = 1000; //К-во Номенклатуры
* customerPay.CountContr = 100; //К-во Документов
* }
*/
customerPay.DirPayServiceID = -1; //-1;
customerPay.DirPayServiceName = "BUSINESS"; //"Пробный";
customerPay.CountUser = 10; //К-во пользователей
//customerPay.CountTT = 1; //К-во ТТ
//customerPay.CountIM = 1; //К-во ИМ
customerPay.CountNomen = -1; //К-во Номенклатуры
customerPay.CountContr = -1;
#endregion
#region 2.Проплачен ли "Основная Услуга"
/*
* var query2 =
* (
* from dirCustomers in db.DirCustomers
* from dirPayCustomers in db.DirPayCustomers
* from dirPayServices in db.DirPayServices
* where
* dirCustomers.DirCustomersID == DirCustomersID &&
* dirCustomers.DirCustomersID == dirPayCustomers.DirCustomersID &&
* dirPayCustomers.DirPayServiceID == dirPayServices.DirPayServiceID &&
* DateTime.Now >= dirPayCustomers.PayDateBegin &&
* DateTime.Now <= dirPayCustomers.PayDateEnd &&
* dirPayCustomers.DirPayServiceID <= 3 &&
* dirPayCustomers.Held == true
* select new
* {
* DirPayServiceID = dirPayCustomers.DirPayServiceID,
* DirPayServiceName = dirPayServices.DirPayServiceName,
* PayDateEnd = dirPayCustomers.PayDateEnd
* }
* ).ToList();
*
* if (query2.Count() > 0)
* {
* customerPay.DirPayServiceID = query2[0].DirPayServiceID;
* customerPay.DirPayServiceName = query2[0].DirPayServiceName;
* customerPay.PayDateEnd = query2[0].PayDateEnd;
* //Если проплачено, то как минимум у Клиента 3-и сотрудника
* customerPay.CountUser = 10;
* //Если проплачено, то INFINITY Номенклатуры и Документов
* //customerPay.CountTT = 1;
* //customerPay.CountIM = 1;
* customerPay.CountNomen = -1;
* customerPay.CountContr = -1;
* }
*/
#endregion
}
return(customerPay);
}
