void Start()
{
OtherScriptToAccess = ShopStoreObject.GetComponent <ShopStore> ();
testStringToGet = OtherScriptToAccess.testString;
Debug.Log(testStringToGet);
}
private void button2_Click(object sender, EventArgs e)
{
SupplyAssemblyOrder order = (SupplyAssemblyOrder)dataGridView1.CurrentRow.DataBoundItem;
var sscios = from sad in DataService.db.GetTable <SupplyAssemblyDetails>()
where sad.supplyAssemblyOrderId == order.id
join st in DataService.db.GetTable <SupplierStore>() on sad.supplierStoreId equals st.id
select new SupplierStoreComponentInOrder(st.computerComponent.id, st.computerComponent.type, st.computerComponent.name, st.supplierPrice, sad.id, sad.count);
foreach (var sscio in sscios)
{
var ss = DataService.db.GetTable <ShopStore>()
.Where(ssP => ssP.computerComponentId == sscio.id)
.SingleOrDefault();
if (ss == null)
{
var shopStore = new ShopStore(sscio.id, sscio.count);
DataService.db.GetTable <ShopStore>().InsertOnSubmit(shopStore);
}
else
{
ss.count = ss.count + sscio.count;
}
}
order.status = SupplyAssemblyOrderStatus.ARRIVED;
DataService.db.SubmitChanges();
updateForm();
}
public void Additem()
{
//testStringToGet = GetComponent<ShopStore> ().testString;
OtherScriptToAccess = ShopStoreObject.GetComponent <ShopStore> ();
testStringToGet = OtherScriptToAccess.testString;
Debug.Log(testStringToGet);
}
private void SaveStoreItem(object sender, RoutedEventArgs e)
{
if (FoodBox.SelectedItem == null)
{
MessageBox.Show("Food is not selected!");
return;
}
if (FoodUnitBox.SelectedItem == null)
{
MessageBox.Show("Unit is not selected!");
return;
}
if (FoodAmount.Text == "")
{
MessageBox.Show("Food amount field is empty!");
return;
}
ShopContext shopContext = new ShopContext();
string foodName = FoodBox.SelectedItem.ToString();
int foodId = shopContext.FoodDictionary.Where(f => f.Name == foodName).Select(f => f.FoodID).First();
UnitPropertis unit = FoodUnitBox.SelectedItem as UnitPropertis;
List <int> unitIdList = shopContext.UnitDictionary.Where(u => u.Name == unit.Name).Select(u => u.UnitID).ToList();
int unitId = shopContext.Unit.Where(u => unitIdList.Any(d => d == u.UnitID))
.Where(u => u.UnitStep == unit.Step).Select(u => u.UnitID).First();
float amount = Convert.ToSingle(FoodAmount.Text);
ShopStore shopStore = new ShopStore();
shopStore.ShopID = ShopId;
shopStore.FoodID = foodId;
shopStore.Amount = amount;
shopStore.UnitID = unitId;
if (shopContext.ShopStore.Where(s => s.FoodID == shopStore.FoodID && s.UnitID == shopStore.UnitID).Count() > 0)
{
MessageBox.Show("Element is existed!");
return;
}
shopContext.ShopStore.Add(shopStore);
shopContext.SaveChanges();
FoodTypeBox.SelectedItem = null;
FoodBox.SelectedItem = null;
FoodUnitBox.SelectedItem = null;
FoodTypeBox.Text = "Type";
FoodBox.Text = "Food";
FoodUnitBox.Text = "Unit";
FoodAmount.Text = "";
}
private void SaveStore(object sender, RoutedEventArgs e)
{
if (StoreList.SelectedItem != null)
{
ShopStorePropertie itemProperty = StoreList.SelectedItem as ShopStorePropertie;
ShopContext shopContext = new ShopContext();
ShopStore editedItem = shopContext.ShopStore
.Where(s => s.ShopID == ShopId && s.FoodID == itemProperty.FoodId && s.UnitID == itemProperty.Unit.UnitId).First();
float userAmount = Convert.ToSingle(StoreAmount.Text);
if (userAmount != editedItem.Amount)
{
ShopStore newItem = new ShopStore();
newItem.ShopID = editedItem.ShopID;
newItem.FoodID = editedItem.FoodID;
newItem.Amount = userAmount;
newItem.UnitID = editedItem.UnitID;
shopContext.ShopStore.Remove(editedItem);
shopContext.ShopStore.Add(newItem);
shopContext.SaveChanges();
}
}
NamePanel.Visibility = Visibility.Collapsed;
string lang;
string type;
if (LanguageBox.SelectedItem != null)
{
lang = LanguageBox.SelectedItem.ToString();
}
else
{
lang = MainLanguage;
}
if (TypeBox.SelectedItem != null)
{
type = TypeBox.SelectedItem.ToString();
RefreshList(lang, type);
}
else
{
RefreshList(lang);
}
}
private void button5_Click(object sender, EventArgs e)
{
decimal price = 0;
try
{
price = decimal.Parse(textBox1.Text);
textBox1.Clear();
}
catch (FormatException)
{
MessageBox.Show("Неверный формат в поле 'количества'.");
return;
}
ShopStore shopStore = (ShopStore)dataGridView1.CurrentRow.DataBoundItem;
DataService.db.ExecuteCommand("update computer_component set trade_price = {0} where id = {1}",
price, shopStore.computerComponent.id);
DataService.refreshAll();
var sss = from ss in DataService.db.GetTable <ShopStore>()
select ss;
bindingSource1.DataSource = sss;
}
private void DeleteStoreItem(object sender, RoutedEventArgs e)
{
ShopContext shopContext = new ShopContext();
if (StoreList.SelectedItem != null)
{
ShopStorePropertie storeItem = StoreList.SelectedItem as ShopStorePropertie;
ShopStore deletedItem = shopContext.ShopStore
.Where(s => s.ShopID == ShopId && s.FoodID == storeItem.FoodId && s.UnitID == storeItem.Unit.UnitId).First();
shopContext.ShopStore.Remove(deletedItem);
shopContext.SaveChanges();
string lang;
string type = null;
if (StoreLanguageBox.SelectedItem != null)
{
lang = StoreLanguageBox.SelectedItem.ToString();
}
else
{
lang = MainLanguage;
}
if (FoodTypeBox.SelectedItem != null)
{
type = FoodTypeBox.SelectedItem.ToString();
}
if (type != null)
{
RefreshList(lang, type);
}
else
{
RefreshList(lang);
}
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult ShopStore(long shopId)
{
ShopStore homeModel = new ShopStore();
ShopInfo shop = ServiceHelper.Create <IShopService>().GetShop(shopId, false);
if (shop != null)
{
ViewBag.SortType = shop.SortType;
ViewBag.Logo = base.CurrentSiteSetting.MemberLogo;
homeModel.ShopId = shop.Id;
homeModel.ShopLogo = shop.Logo;
homeModel.CompanyAddress = shop.CompanyAddress; // +"/" + shop.ECompanyAddress + "</span>";
homeModel.ShopName = shop.ShopName; // +"/" + shop.ECompanyName;
homeModel.ContactsEmail = shop.ContactsEmail;
homeModel.ContactsPhone = shop.ContactsPhone;
homeModel.CompanyFoundingDate = shop.CompanyFoundingDate.HasValue ? shop.CompanyFoundingDate.Value.ToString("yyyy-MM-dd") : string.Empty;
homeModel.URL = shop.URL;
homeModel.CompanyFoundingDate = shop.CreateDate.ToShortDateString();
homeModel.GMPPhoto = shop.GMPPhoto;
homeModel.ISOPhoto = shop.ISOPhoto;
homeModel.FDAPhoto = shop.FDAPhoto;
homeModel.Fax = shop.Fax;
homeModel.OrganizationCodePhoto = shop.OrganizationCodePhoto;
homeModel.TaxRegistrationCertificatePhoto = shop.TaxRegistrationCertificatePhoto;
homeModel.BusinessLicenceNumberPhoto = shop.BusinessLicenceNumberPhoto;
homeModel.ShopAccount = shop.ShopAccount;
homeModel.ContactsName = shop.ContactsName;// +"/" + shop.EContactsName;
homeModel.BankName = shop.BankName;
homeModel.BankAccountNumber = shop.BankAccountNumber;
// homeModel.Price=
homeModel.ShopEndDate = (shop.EndDate.HasValue ? shop.EndDate.Value.ToString("yyyy-MM-dd") : string.Empty);
ShopGradeInfo shopGradeInfo = (
from c in ServiceHelper.Create <IShopService>().GetShopGrades()
where c.Id == shop.GradeId
select c).FirstOrDefault();
homeModel.ShopGradeName = (shopGradeInfo != null ? shopGradeInfo.Name : string.Empty);
IQueryable <StatisticOrderCommentsInfo> shopStatisticOrderComments = ServiceHelper.Create <IShopService>().GetShopStatisticOrderComments(shopId);
StatisticOrderCommentsInfo statisticOrderCommentsInfo = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 13
select c).FirstOrDefault(); //质量与描述满意度
StatisticOrderCommentsInfo statisticOrderCommentsInfo1 = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 14
select c).FirstOrDefault();//发货速度满意度
StatisticOrderCommentsInfo statisticOrderCommentsInfo2 = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 15
select c).FirstOrDefault();//服务态度满意度
StatisticOrderCommentsInfo statisticOrderCommentsInfo3 = (
from c in shopStatisticOrderComments
where (int)c.CommentKey == 16 //包装质量满意度
select c).FirstOrDefault();
string str = "5"; //如果无评价数据，默认为5分
homeModel.ProductAndDescription = (statisticOrderCommentsInfo != null ? string.Format("{0:F}", statisticOrderCommentsInfo.CommentValue) : str);
homeModel.SellerServiceAttitude = (statisticOrderCommentsInfo1 != null ? string.Format("{0:F}", statisticOrderCommentsInfo1.CommentValue) : str);
homeModel.SellerDeliverySpeed = (statisticOrderCommentsInfo2 != null ? string.Format("{0:F}", statisticOrderCommentsInfo2.CommentValue) : str);
homeModel.PackingQuality = (statisticOrderCommentsInfo3 != null ? string.Format("{0:F}", statisticOrderCommentsInfo3.CommentValue) : str);
DateTime date = DateTime.Now.AddDays(-1).Date;
DateTime dateTime = date.AddDays(1).AddMilliseconds(-1);
ShopInfo.ShopVistis shopVistiInfo = ServiceHelper.Create <IShopService>().GetShopVistiInfo(date, dateTime, shopId);
List <EchartsData> echartsDatas = new List <EchartsData>();
if (shopVistiInfo == null)
{
string str1 = (new decimal(0)).ToString();
ViewBag.VistiCounts = str1;
ViewBag.OrderCounts = str1;
ViewBag.SaleAmounts = str1;
}
else
{
ViewBag.VistiCounts = shopVistiInfo.VistiCounts;
ViewBag.OrderCounts = shopVistiInfo.OrderCounts;
ViewBag.SaleAmounts = shopVistiInfo.SaleAmounts;
}
}
return(View(homeModel));
}
