protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
{
try
{
if (TxtVIPNo.Text.Trim().Length <= 0)
{
X.MessageBox.Alert("提醒", "请输入VIP卡号！").Show();
return;
}
CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["DBRetail"];
string sql = "select vipid,vipname,centum,pcentum from vip_user where vipcode='{0}'";
CJ_DevelopHelper.SqlStr = String.Format(sql, TxtVIPNo.Text.Trim().Replace("'", "").Replace("--", ""));
DataTable dt = CJ_DevelopHelper.SQL_ReturnDateTable;
string cardno = "";
if (dt.Rows.Count == 1)
{
lbInfo.Html = " 姓名:<font color=red>" + dt.Rows[0]["vipname"].ToString()
+ "</font> 总积分:<font color=red>" + dt.Rows[0]["centum"].ToString()
+ "</font> 上季积分:<font color=red>" + dt.Rows[0]["pcentum"].ToString() + "</font>";
cardno = dt.Rows[0]["vipid"].ToString();
}
else
{
X.MessageBox.Alert("提醒", "VIP卡号不正确，请检查，找到" + dt.Rows.Count.ToString() + "条记录！").Show();
return;
}
RetailStore.DataSource = GetRecordByProc(cardno);
RetailStore.DataBind();
}
catch (Exception error)
{
X.MessageBox.Alert("异常", error.Message).Show();
}
}
public async Task <IActionResult> Edit(decimal id, [Bind("STOREID,STORENAME,PHONE,CONTACTFIRSTNAME,CONTACTLASTNAME,ADDRESS,ZIPCODE,CITYID")] RetailStore retailStore)
{
if (id != retailStore.STOREID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(retailStore);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RetailStoreExists(retailStore.STOREID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(retailStore));
}
public RetailStore Create()
{
var store = new RetailStore(Name);
PopulateDepartments(store);
return(store);
}
public void GetItem_WhenInvalidItemName()
{
RetailStore store = RetailFactory.CreateGiftShop();
Assert.ThrowsException <NotFoundException>(() =>
{
store.GetItem(deptName: "Merchandise", itemName: "____");
});
}
public void GetItem_WhenInvalidDepartmentName()
{
RetailStore store = RetailFactory.CreateGiftShop();
Assert.ThrowsException <NotFoundException>(() =>
{
store.GetItem(deptName: "___", itemName: "T-Shirt");
});
}
public void GetItem_WhenMissingItemName()
{
RetailStore store = RetailFactory.CreateGiftShop();
Assert.ThrowsException <ArgumentNullException>(() =>
{
store.GetItem(deptName: "Merchandise", itemName: null);
});
}
public void GetItem_WhenInvalidPrice()
{
RetailStore store = RetailFactory.CreateGiftShop();
Assert.ThrowsException <InvalidPriceException>(() =>
{
store.GetItem(deptName: "Snacks", itemName: "BadPriceCandy");
});
}
public void GetItem_WhenMissingDepartmentName()
{
RetailStore store = RetailFactory.CreateGiftShop();
Assert.ThrowsException <ArgumentNullException>(() =>
{
store.GetItem(deptName: null, itemName: "T-Shirt");
});
}
public void GetItem_WhenItemFound()
{
RetailStore store = RetailFactory.CreateGiftShop();
RetailItem item = store.GetItem(deptName: "Merchandise", itemName: "T-Shirt");
Assert.IsNotNull(item);
Assert.AreEqual("T-Shirt", item.Name);
}
public async Task <IActionResult> Create([Bind("STOREID,STORENAME,PHONE,CONTACTFIRSTNAME,CONTACTLASTNAME,ADDRESS,ZIPCODE,CITYID")] RetailStore retailStore)
{
if (ModelState.IsValid)
{
_context.Add(retailStore);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(retailStore));
}
public void SetUp()
{
var inventory = new Inventory(new Dictionary <string, Product>
{
{ "123456", new Product(12.34m) },
{ "123457", new Product(1564.34m) },
});
m_Screen = new Screen();
m_RetailStore = new RetailStore(m_Screen, inventory);
}
public void SetUp()
{
var inventory = new Inventory(new Dictionary <string, Product>
{
{ "1", new Product(8.50m) },
{ "2", new Product(12.36m) },
{ "3", new Product(65.13m) },
});
m_Screen = new Screen();
m_RetailStore = new RetailStore(m_Screen, inventory);
}
public override void PopulateDepartments(RetailStore store)
{
var dept = new RetailDepartment("Snacks");
dept.AddItem("Ice cream", 1.25m);
dept.AddItem("Soft drink", 0.50m);
dept.AddItem("Water bottle", 0.95m);
dept.AddItem("BadPriceCandy", -0.05m);
store.Departments.Add(dept);
dept = new RetailDepartment("Merchandise");
dept.AddItem("T-Shirt", 9.95m);
dept.AddItem("Magazine", 1.50m);
store.Departments.Add(dept);
}
public static void CreateSalesOrderWithoutChangeset(Resources context)
{
string salesOrderNumber = "100006";
try
{
RetailStore retailStore = new RetailStore();
DataServiceCollection <RetailStore> retailStoreCollection = new DataServiceCollection <RetailStore>(context);
retailStoreCollection.Add(retailStore);
//retailStore.
//SalesOrderHeader salesOrder = new SalesOrderHeader();
//DataServiceCollection<SalesOrderHeader> salesOrderCollection = new DataServiceCollection<SalesOrderHeader>(context);
//salesOrderCollection.Add(salesOrder);
//salesOrder.SalesOrderNumber = salesOrderNumber; // Change number sequence setting in AX to allow user to set values.
//salesOrder.CurrencyCode = "USD";
//salesOrder.InvoiceCustomerAccountNumber = "US-001";
//salesOrder.OrderingCustomerAccountNumber = "US-001";
//salesOrder.LanguageId = "en-us";
//salesOrder.DataAreaId = "USMF";
//SalesOrderLine salesOrderLine = new SalesOrderLine();
//DataServiceCollection<SalesOrderLine> salesOrderLineCollection = new DataServiceCollection<SalesOrderLine>(context);
//salesOrderLineCollection.Add(salesOrderLine);
//salesOrderLine.SalesOrderNumber = salesOrder.SalesOrderNumber;
//salesOrderLine.ItemNumber = "1000";
//salesOrderLine.OrderedSalesQuantity = 1;
//salesOrderLine.ShippingSiteId = "ABC"; // Error in line.
//salesOrderLine.ShippingWarehouseId = "24";
//salesOrderLine.DataAreaId = "USMF";
context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithIndependentOperations); // The changes within the branch are treated as independent operation. Failure in one will not roll back others.
Console.WriteLine(string.Format("Invoice {0} - Saved !", salesOrderNumber));
}
catch (DataServiceRequestException e)
{
Console.WriteLine(string.Format("Invoice {0} - Save Failed !", salesOrderNumber));
}
}
public static void CreateSalesOrderInSingleChangeset(Resources context)
{
string salesOrderNumber = "100005";
try
{
RetailStore retailStore = new RetailStore();
DataServiceCollection <RetailStore> retailStoreCollection = new DataServiceCollection <RetailStore>(context);
SalesOrderHeader salesOrder = new SalesOrderHeader();
DataServiceCollection <SalesOrderHeader> salesOrderCollection = new DataServiceCollection <SalesOrderHeader>(context);
salesOrderCollection.Add(salesOrder);
salesOrder.SalesOrderNumber = salesOrderNumber; // Change number sequence setting in AX to allow user to set values.
salesOrder.CurrencyCode = "USD";
salesOrder.InvoiceCustomerAccountNumber = "US-001";
salesOrder.OrderingCustomerAccountNumber = "US-001";
salesOrder.LanguageId = "en-us";
salesOrder.DataAreaId = "USMF";
SalesOrderLine salesOrderLine = new SalesOrderLine();
DataServiceCollection <SalesOrderLine> salesOrderLineCollection = new DataServiceCollection <SalesOrderLine>(context);
salesOrderLineCollection.Add(salesOrderLine);
salesOrderLine.SalesOrderNumber = salesOrder.SalesOrderNumber;
salesOrderLine.ItemNumber = "1000";
salesOrderLine.OrderedSalesQuantity = 1;
salesOrderLine.ShippingSiteId = "2";
salesOrderLine.ShippingWarehouseId = "24";
salesOrderLine.DataAreaId = "USMF";
context.SaveChanges(SaveChangesOptions.PostOnlySetProperties | SaveChangesOptions.BatchWithSingleChangeset); // Batch with Single Changeset ensure the saved changed runs in all-or-nothing mode.
Console.WriteLine(string.Format("Invoice {0} - Saved !", salesOrderNumber));
}
catch (DataServiceRequestException e)
{
Console.WriteLine(string.Format("Invoice {0} - Save Failed !", salesOrderNumber));
}
}
protected void Report_DataBind(object sender, StoreRefreshDataEventArgs e)
{
try
{
if (Request["shopid"] == null)
{
return;
}
//订单销售连接串
CJ_DevelopHelper.SqlConn_Str = ConfigurationManager.AppSettings["DBRetail"];
string sql = "select retailid,setdate,znums,zxsums,zssums,FCalcSums,zxsums-zssums as yhsum,s_sums,vipcode,s_name,x_name,crdate,cr_name,comment,sure,chk_sure,depotid from d_Retail ";
string condition = "where depotid='" + Request["shopid"].ToString().Replace("'", "").Replace("--", "") + "' ";
//单号
if (TxtRetailNo.Text.Trim().Length > 0)
{
condition += " and retailid='" + TxtRetailNo.Text.Trim().Replace("'", "").Replace("--", "") + "' ";
X.Js.AddScript("retailno='" + TxtRetailNo.Text.Trim().Replace("'", "").Replace("--", "") + "';#{RetailSubStore}.reload();");
}
//开始结束如期
if (DTStart.SelectedValue != null)
{
condition += " and setdate>='" + DTStart.SelectedValue.ToString() + "' ";
}
if (DTEnd.SelectedValue != null)
{
condition += " and setdate<='" + DTEnd.SelectedValue.ToString() + "' ";
}
//状态
condition += CboState.Value.ToString();
CJ_DevelopHelper.SqlStr = sql + condition;
DataTable dt = CJ_DevelopHelper.SQL_ReturnDateTable;
RetailStore.DataSource = dt;
RetailStore.DataBind();
}
catch (Exception error)
{
X.MessageBox.Alert("异常", error.Message).Show();
}
}
public abstract void PopulateDepartments(RetailStore store);
static void Main(string[] args)
{
RetailStore giftShop = RetailFactory.CreateGiftShop();
RetailItem item = giftShop.GetItem("Merchandise", "T-Shirt");
}
public void InitializePos()
{
//Enable Logging
Logger.Enabled = true;
//Check database connection
// try
// {
//Load Organization
Logger.Info(this.GetType().FullName, this.GetType().FullName + "Reading Organization", PosSettings.Default.Debug);
Organization organization = new Organization();
organization.Organization_no = PosSettings.Default.Organization;
organization.LoadByOrganizationNo();
PosContext.Instance.Organization = organization;
Logger.Info(this.GetType().FullName, this.GetType().FullName + "Reading PosConfig", PosSettings.Default.Debug);
PosConfig posConfig = new PosConfig();
posConfig.ConfigNo = PosSettings.Default.Configuration;
posConfig.LoadByConfigNo();
//Load configuration setting via PocConfig
posConfig.Organization_id = PosSettings.Default.Organization;
posConfig.Relations();
//Cash the config code in the PosContext
PosContext.Instance.Config = posConfig;
//Load parameter setting;
PosParameters parms = new PosParameters(PosContext.Instance.Config.ConfigNo);
PosContext.Instance.Parameters = parms;
Application.Current.MainWindow.FontFamily = new FontFamily(PosContext.Instance.Parameters.getParam("FontFamily"));
//Retatil store group
RetailStore retailStore = new RetailStore();
retailStore.Retail_store_no = PosSettings.Default.Store;
retailStore.Organization_no = PosSettings.Default.Organization;
retailStore.Load();
// Store RetailStore object in PosContext for easy reference
PosContext.Instance.RetailStore = retailStore;
// }
// catch (Exception e)
// {
// Logger.Error(this.GetType().FullName, e.StackTrace, e);
// MessageBox.Show("Please setup data source" + "\n" + e.ToString());
// PosHardware.Instance.Close();
// Application.Current.Shutdown();
// return;
// }
//Load panel classes
// this.progressView.SetProgressStep(50, "Loading menus");
this.LoadPanels();
//End
// this.progressView.SetProgressStep(100, "Loading Startup events");
this.InitDisplay();
//Pos Explorer
try
{
//PropertyInfo info = this.GetType().FullName
Logger.Info(this.GetType().FullName, this.GetType().FullName + ":" + "Creating PosExplorer", PosSettings.Default.Debug);
PosContext.Instance.PosExplorer = new PosExplorer();
Logger.Info(this.GetType().FullName, this.GetType().FullName + ":" + "Initilizing POS Hardware", PosSettings.Default.Debug);
PosHardware.Instance.Initialize();
}
catch (Exception e)
{
Logger.Error(this.GetType().FullName, e.ToString(), e);
}
this.status = true;
}
