public SalesStaffCtrl(SalesInfo info)
: this()
{
this.Load -= SalesStaffCtrl_Load;
this.Load += SalesStaffCtrl_Load2;
_info = info;
}
public int SalesOrderManage(out string errText, SalesInfo salesInfo, List <SalesDetailInfo> details)
{
errText = "";
if (salesInfo == null || details == null || details.Count == 0)
{
errText = "信息不足，销售单保存失败！";
return(0);
}
foreach (var commodity in details)
{
var warehouse = commodity.WarehouseId;
var list = _stockDetailInfoDal.GetEntityList(out errText, warehouse, commodity.CommodityId);
if (list == null || list.Count == 0)
{
errText = "没有库存信息！";
return(0);
}
var stock = list[0];
if (stock.Count < commodity.Count)
{
errText = string.Format("商品{0}库存不足，当前库存{1}", commodity.CommodityId, stock.Count);
return(0);
}
}
foreach (var commodity in details)
{
var i = SaveSalesStockInfo(out errText, commodity.WarehouseId, commodity.CommodityId, commodity.Count, commodity.Remark);
if (i <= 0)
{
return(i);
}
}
return(1);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,ProductId,Count,Cost")] SalesInfo salesInfo)
{
if (id != salesInfo.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(salesInfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SalesInfoExists(salesInfo.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(salesInfo));
}
public ActionResult Export(int?id)
{
if (id != null)
{
SalesInfo info = new SalesInfo();
foreach (EventType type in Enum.GetValues(typeof(EventType)))
{
if (type != EventType.JazzPass)
{
AddToInfo(type, info);
}
}
switch (id)
{
case 0:
return(new CsvActionResult <KeyValuePair <string, int> >
(info.ActivitySales, "ActivitySales.csv", new string[] { "Activty", "Amount" }));
case 1:
return(new CsvActionResult <KeyValuePair <string, int> >
(info.Timeslots, "TimeslotSales.csv", new string[] { "Timeslot", "Amount" }));
case 2:
return(new CsvActionResult <KeyValuePair <string, int> >
(info.CountryCount, "CountrySales.csv", new string[] { "Country", "Amount" }));
case 3:
return(new CsvActionResult <KeyValuePair <string, int> >
(info.DailySales, "DailySales.csv", new string[] { "Day", "Amount" }));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
protected async Task UpdateSalesInfo(SalesOrder obj, SalesInfo _data)
{
if (_data == null)
{
currentErrors.AddValidationError(Messages.SalesRequired, obj.SalesOrderId);
return;
}
obj.TerritoryObject = _data.TerritoryId == null ? null :
await ctx.FindEntityAsync <SalesTerritory>(currentErrors, _data.TerritoryId);
obj.SalesPersonObject = _data.SalesPersonId == null ? null :
await ctx.FindEntityAsync <SalesPerson>(currentErrors, _data.SalesPersonId);
// remove sales reason that are not in the provided list
obj.ReasonObjectList.Where(r => _data.SalesReason == null || !_data.SalesReason.Contains(r.SalesReasonId))
.ToList().ForEach(r => obj.ReasonObjectList.Remove(r));
if (_data.SalesReason != null)
{
// add sales reasons from provided list that don't exist yet
_data.SalesReason.Where(rId => obj.ReasonObjectList.Where(r => r.SalesReasonId == rId).ToList().Count == 0)
.ToList().ForEach(rId => obj.ReasonObjectList.Add(new SalesOrderReason()
{
SalesOrderId = obj.SalesOrderId,
SalesReasonId = rId,
ModifiedDate = DateTime.Now
}));
}
}
// Return the SalesInfo if successed with nothing gone wrong
public TokenHandleResult(SalesInfo salesInfo, string insurer)
{
this._insurer = insurer;
this._successed = true;
this._salesInfo = salesInfo;
this.StatusCode = "200";
}
internal void InsertSalesInfo(SalesInfo instance)
{
base.com.CommandText = "spInsertSalesInfoByCustomer";
base.com.Parameters.AddWithValue("_InvNo", instance.InvNo);
base.com.Parameters.AddWithValue("_CustName", instance.CustName);
base.com.Parameters.AddWithValue("_Address", instance.Address);
base.com.Parameters.AddWithValue("_EmailAdd", instance.EmailAdd);
base.com.Parameters.AddWithValue("_ContactNumber", instance.ContactNo);
base.com.Parameters.AddWithValue("_CustNo", instance.CustNo);
base.com.Parameters.AddWithValue("_TotalAmount", instance.TotalAmount);
base.com.Parameters.AddWithValue("_EmpID", instance.EmpID);
base.com.Parameters.AddWithValue("_Status", instance.Status);
base.com.Parameters.AddWithValue("_Remarks", instance.Remarks);
base.com.Parameters.AddWithValue("_KioskID", instance.KioskID);
base.com.Parameters.AddWithValue("_TakenBy", instance._TakenBy);
try{
int res = Convert.ToInt32(base.com.ExecuteScalar());
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
closeConnection();
}
}
protected void UpdateSales(AdventureWorksEntities ctx, SalesOrder obj, SalesInfo _data)
{
obj.TerritoryIdObject = ctx.SalesTerritory.Find(_data.TerritoryId);
if (_data.TerritoryId != null && obj.TerritoryIdObject == null)
{
ErrorList.Current.AddError("Cannot find Sales Territory with ID {0}.", _data.TerritoryId);
}
obj.SalesPersonIdObject = ctx.SalesPerson.Find(_data.SalesPersonId);
if (_data.SalesPersonId != null && obj.SalesPersonIdObject == null)
{
ErrorList.Current.AddError("Cannot find Sales Person with ID {0}.", _data.SalesPersonId);
}
// remove sales reason that are not in the provided list
obj.ReasonObjectList.Where(r => _data.SalesReason == null || !_data.SalesReason.Contains(r.SalesReasonId))
.ToList().ForEach(r => obj.ReasonObjectList.Remove(r));
if (_data.SalesReason != null)
{
// add sales reasons from provided list that don't exist yet
_data.SalesReason.Where(rId => obj.ReasonObjectList.Where(r => r.SalesReasonId == rId).ToList().Count == 0)
.ToList().ForEach(rId => obj.ReasonObjectList.Add(new SalesOrderReason()
{
SalesOrderObject = obj,
SalesReasonId = rId,
ModifiedDate = DateTime.Now
}));
}
}
private object GetSampleSalesData(HttpRequest request, HotcakesApplication hccApp)
{
var info = new SalesInfo
{
ChartLabels =
new List <string>(new[]
{ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }),
ChartData =
new List <decimal>(new decimal[]
{
1040000, 1700000, 700000, 1400000, 1400000, 1700000, 1200000, 1400000, 1700000, 1700000, 1360000,
1020000
}),
OrdersCount = 30,
OrdersCompleted = 10,
OrdersTotalSum = 16300000,
OrdersSuccessfulTransactions = 27000,
SalesByDesktopCount = 14000,
SalesByDesktopPercent = 70,
SalesByDesktopPercentPrev = 80,
SalesByTabletCount = 4000,
SalesByTabletPercent = 20,
SalesByTabletPercentPrev = 10,
SalesByPhoneCount = 2000,
SalesByPhonePercent = 10,
SalesByPhonePercentPrev = 10
};
return(new SalesInfoJson(info, Localization));
}
void ListView1DoubleClick(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
SalesInfo t = infos[listView1.SelectedItems[0].Index];
WorkbenchSingleton.AddChild(new SalesInfoForm(t), "Edit Sales Information");
}
}
public SalesInfoForm(SalesInfo info)
{
InitializeComponent();
this.SalesInfo = info;
addToolStripMenuItem.Click += delegate { buttonAdd.PerformClick(); };
modifyToolStripMenuItem.Click += delegate { ListView1DoubleClick(this, null); };
listView1.Resize += delegate { columnHeader2.Width = listView1.Width - 22 - (columnHeader1.Width + columnHeader3.Width + columnHeader4.Width); };
}
/// <summary>
/// 销售还款
/// </summary>
/// <param name="userContext"></param>
/// <param name="salesId"></param>
/// <param name="money"></param>
/// <param name="remark"></param>
/// <param name="sendsms"></param>
/// <returns></returns>
public int SalesRepayment(UserContext userContext, int salesId, decimal money, string remark, int sendsms,
int operatorID)
{
var salesInfo = _salesDapperRepository.Find(x => x.saleID == salesId && x.accID == userContext.AccId);
if (salesInfo == null)
{
return(-1);
}
else if (salesInfo.UnpaidMoney <= 0)
{
return(-2);
}
else
{
var updateSalesInfo = new SalesInfo();
updateSalesInfo.accID = userContext.AccId;
updateSalesInfo.saleID = salesId;
updateSalesInfo.UnpaidMoney = salesInfo.UnpaidMoney - money;
updateSalesInfo.CashMoney = salesInfo.CashMoney + money;
bool result = _salesDapperRepository.Update <SalesInfo>(updateSalesInfo,
item => new { item.UnpaidMoney, item.CashMoney });
if (result)
{
var logModel = new SaleLogInfo
{
accID = userContext.AccId,
saleID = salesId,
saleListID = 0,
logType = 3,
itemType = 0,
OriginalVal = salesInfo.UnpaidMoney,
EditVal = money
};
logModel.FinalVal = logModel.OriginalVal - logModel.EditVal;
logModel.LogTime = DateTime.Now;
logModel.operatorTime = DateTime.Now;
logModel.operatorID = userContext.Operater;
logModel.operatorIP = userContext.IpAddress;
logModel.addedLgUserId = operatorID == 0 ? userContext.Operater : operatorID;
logModel.Remark = remark;
logModel.Flag = "";
_salesLogDapperRepository.Insert(logModel);
if (sendsms == 1)
{
//TODO 接统一短信接口
}
}
return(result ? 1 : 0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SalesInfo GetSalesInfoModel(int SalesID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SalesID,StoresID,ProductsID,sNum,sPrice,sDateTime,sAppendTime,sIsYH,sStoresName,sProductsName,(select sName from tbStoresInfo where StoresID=tbSalesInfo.StoresID) as StoresName,(select pName from tbProductsInfo where ProductsID=tbSalesInfo.ProductsID) as ProductsName from tbSalesInfo ");
strSql.Append(" where SalesID=@SalesID ");
SqlParameter[] parameters =
{
new SqlParameter("@SalesID", SqlDbType.Int, 4)
};
parameters[0].Value = SalesID;
SalesInfo model = new SalesInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SalesID"].ToString() != "")
{
model.SalesID = int.Parse(ds.Tables[0].Rows[0]["SalesID"].ToString());
}
if (ds.Tables[0].Rows[0]["StoresID"].ToString() != "")
{
model.StoresID = int.Parse(ds.Tables[0].Rows[0]["StoresID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "")
{
model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString());
}
if (ds.Tables[0].Rows[0]["sNum"].ToString() != "")
{
model.sNum = int.Parse(ds.Tables[0].Rows[0]["sNum"].ToString());
}
if (ds.Tables[0].Rows[0]["sPrice"].ToString() != "")
{
model.sPrice = decimal.Parse(ds.Tables[0].Rows[0]["sPrice"].ToString());
}
if (ds.Tables[0].Rows[0]["sDateTime"].ToString() != "")
{
model.sDateTime = DateTime.Parse(ds.Tables[0].Rows[0]["sDateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["sAppendTime"].ToString() != "")
{
model.sAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["sAppendTime"].ToString());
}
model.StoresName = ds.Tables[0].Rows[0]["StoresName"].ToString();
model.ProductsName = ds.Tables[0].Rows[0]["ProductsName"].ToString();
return(model);
}
else
{
return(null);
}
}
public async Task <IActionResult> Create([Bind("ProductId,Count,Cost, SalesInvoiceId")] SalesInfo salesInfo)
{
if (ModelState.IsValid)
{
_context.Add(salesInfo);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index), "SalesInfos", new { id = salesInfo.SalesInvoiceId }));
}
return(View(salesInfo));
}
void DeleteToolStripMenuItemClick(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
foreach (ListViewItem li in listView1.SelectedItems)
{
SalesInfo s = infos[li.Index];
DeleteSalesInfo(s, null);
}
OnActivated(null);
}
}
protected SalesInfo GetSalesInfo(SalesOrder obj)
{
SalesInfo res = new SalesInfo()
{
SalesPersonId = obj.SalesPersonObject?.BusinessEntityId,
TerritoryId = obj.TerritoryObject?.TerritoryId,
// select a list of sales reason IDs from the child list
SalesReason = obj.ReasonObjectList?.Select(r => r.SalesReasonId).ToList()
};
return(res);
}
private async void TabItem_RequestBringIntoView(object sender, RequestBringIntoViewEventArgs e)
{
await GetData();
SalesList.ItemsSource = Sales;
SalesList.Items.Refresh();
try
{
SalesInfos = (await SalesInfo.CreateSalesInfo(Beers, Sales)).ToList();
}
catch { }
}
private SearchResult GetSearchResult(SalesInfo entity)
{
if (entity != null)
{
// Get the SalesInfo if successed
return(new SearchResult(entity));
}
else
{
// No SalesInfo to get if the searching failed
return(new SearchResult());
}
}
public void AddSales(string Name, string Company, int Price)
{
TechValue.RecipeInfo RecipeInfo = CompanyManagerCall.GetCompanyValue(Company).GetTechValue().GetComponent <TechValue>().GetRecipe(Name);
foreach (var SalesItem in SalesItemArray)
{
if (SalesItem.RecipeInfo.Recipe == RecipeInfo.Recipe)
{
if (SalesItem.Seller == Company)
{
ModifySales(Name, Price);
return;
}
else
{
return;
}
}
}
SalesInfo newContent = new SalesInfo();
newContent.RecipeInfo = RecipeInfo;
newContent.Seller = Company;
newContent.QualityEvaluation = 1f;
newContent.Price = Price;
newContent.UploadDate = TimeManagerCall.TimeValue;
newContent.SoldCount = 0;
newContent.SoldCountList = new List <int>();
newContent.ContractList = new List <ContractInfo>();
SalesItemArray.Add(newContent);
UpdateItemCount(Company, Name);
if (PanelControllerCall.CurrentSidePanel != null)
{
if (PanelControllerCall.CurrentSidePanel.name == "ContractPanel")
{
ContractPanelController PanelComponent = PanelControllerCall.CurrentSidePanel.GetComponent <ContractPanelController>();
if (PanelComponent.CurrentCategory == newContent.RecipeInfo.Recipe.Type)
{
PanelComponent.UpdateList(true);
}
else
{
PanelComponent.UpdateList(false);
}
}
}
}
public bool CheckContractExist(SalesInfo Info, string CompanyName)
{
bool result = false;
foreach (var Contract in Info.ContractList)
{
if (Contract.CompanyName == CompanyName)
{
result = true;
}
}
return(result);
}
public int GetContractIndex(SalesInfo Info, string CompanyName)
{
int result = -1;
for (int i = 0; i < Info.ContractList.Count; i++)
{
if (Info.ContractList[i].CompanyName == CompanyName)
{
result = i;
}
}
return(result);
}
public ContractInfo GetContractInfo(SalesInfo Info, string CompanyName)
{
ContractInfo result = null;
foreach (var Contract in Info.ContractList)
{
if (Contract.CompanyName == CompanyName)
{
result = Contract;
}
}
return(result);
}
// GET: Sales
public ActionResult Index()
{
SalesInfo info = new SalesInfo();
foreach (EventType type in Enum.GetValues(typeof(EventType)))
{
if (type != EventType.JazzPass)
{
AddToInfo(type, info);
}
}
info.GetTop10();
return(View(info));
}
public void AddToInfo(EventType type, SalesInfo info)
{
List <TimeSlot> timeslots = activityRepository.GetTimeslots(type).ToList();
//amount sold
int total = timeslots.Sum(ts => ts.TotalSeats);
int sold = timeslots.Sum(ts => ts.OccupiedSeats);
info.AddAmountSold(type, sold, total);
//country stats
List <OrderHasTickets> ohts = orderRepository.getOrdersFromEvent(type).ToList();
var countries = ohts
.GroupBy(oht => oht.Order.Customer.Country)
.Select(x => new { Country = x.Key, count = x.Count(), amount = x.Average(y => y.Amount) })
.OrderByDescending(x => x.count);
foreach (var country in countries)
{
info.AddCountry(country.Country, (int)Math.Floor(country.count * country.amount));
}
//activity sales
var Activities = timeslots
.GroupBy(ts => ts.Activity)
.Select(x => new { activity = x.Key.Name, count = x.Count(), amount = x.Average(y => y.OccupiedSeats) })
.OrderByDescending(x => x.count);
foreach (var activity in Activities)
{
info.AddActivity(activity.activity, (int)Math.Floor(activity.count * activity.amount));
}
//DailySales
for (int i = 0; i < (DateTime.Now - DateTime.Parse("01/01/18 00:00")).TotalDays; i++)
{
DateTime date = DateTime.Now.AddDays(-i);
DateTime date2 = date.AddDays(1);
int amount = ohts.Where(oht => oht.Order.Date <= date2 && oht.Order.Date >= date).Sum(x => x.Amount);
info.AddDailySale(date, amount);
}
//timeslots
foreach (TimeSlot ts in timeslots)
{
info.AddTimeslot(ts, ts.OccupiedSeats);
}
}
// =========================================================================
// Sub Functions
// =========================================================================
private void InsertInvoice()
{
string invno = Request["invno"];
string custname = Request["custname"];
string address = Request["address"];
string emailadd = Request["emailadd"];
string contactno = Request["contactno"];
string custno = Request["custno"];
decimal total = Convert.ToDecimal(Request["total"]);
string empid = Request["empid"];
string status = Request["status"];
string remarks = Request["remarks"];
string kioskid = Request["kioskid"];
string takenby = Request["takenby"];
//
SalesInfo instance = new SalesInfo();
instance.InvNo = invno;
instance.CustName = custname;
instance.Address = address;
instance.EmailAdd = emailadd;
instance.ContactNo = contactno;
instance.CustNo = custno;
instance.TotalAmount = total;
instance.EmpID = empid;
instance.Status = status;
instance.Remarks = remarks;
instance.KioskID = Convert.ToInt32(kioskid);
instance._TakenBy = takenby;
//
bool isInserted = true;
JsonBridge <String> ins = new JsonBridge <String>();
try
{
SalesInfo.InsertSalesInfo(instance);
}
catch (Exception)
{
isInserted = false;
}
ins.Valid = isInserted == true ? 1 : 0;
string output = JsonConvert.SerializeObject(ins);
Response.Write(output);
}
// GET : Event
public ActionResult Event(int?id)
{
if (id != null)
{
if (Enum.IsDefined(typeof(EventType), id))
{
EventType type = (EventType)id;
SalesInfo info = new SalesInfo();
AddToInfo(type, info);
info.GetTop10();
info.PageName = type.ToString();
return(View(info));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
protected SalesInfo GetSalesInfo(SalesOrder obj)
{
SalesInfo res = new SalesInfo();
if (obj.SalesPersonIdObject != null)
{
res.SalesPersonId = obj.SalesPersonIdObject.BusinessEntityId;
}
if (obj.TerritoryIdObject != null)
{
res.TerritoryId = obj.TerritoryIdObject.TerritoryId;
}
// select a list of sales reason IDs from the child list
res.SalesReason = obj.ReasonObjectList.Select(r => r.SalesReasonId).ToList();
return(res);
}
void CloseToolStripMenuItemClick(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count > 0)
{
using (AdminPasswordForm f = new AdminPasswordForm()) {
if (WorkbenchSingleton.AddDialog(f) == DialogResult.OK)
{
foreach (ListViewItem li in listView1.SelectedItems)
{
SalesInfo s = infos[li.Index];
CloseSalesInfo(s, null);
}
OnActivated(null);
}
}
}
}
private void SalesReport()
{
string from = Request["from"];
string to = Request["to"];
string empid = Request["empid"];
var collection = SalesInfo.GetSalesByDateRange(from, to, empid);
JsonBridge <SalesInfo> jsonFeed = new JsonBridge <SalesInfo>();
jsonFeed.Valid = collection.Count != 0 ? 1 : 0;
jsonFeed.collection = collection;
//
string output = JsonConvert.SerializeObject(jsonFeed);
Response.Write(output);
}
private void SalesKiosk()
{
int kioskid = Convert.ToInt32(Request["kioskid"]);
string from = Request["from"];
string to = Request["to"];
var collection = SalesInfo.GetSalesByKioskDateRange(from, to, kioskid);
JsonBridge <SalesInfo> jsonFeed = new JsonBridge <SalesInfo>();
jsonFeed.Valid = collection.Count != 0 ? 1 : 0;
jsonFeed.collection = collection;
//
string output = JsonConvert.SerializeObject(jsonFeed);
Response.Write(output);
}
