//public
public dataJson GetCommodity(int start, int count)
{
try
{
int end = start + count;
var tables = CommodityService.Query(start, end);
if (tables.TotalCount > 0)
{
var list = tables.ModelList.Select(x => new CommodityModel(x, ImageUrl)).ToList();
return(new dataJson()
{
count = count, events = list, start = start, total = tables.TotalCount
});
}
return(new dataJson()
{
count = count, events = null, start = start, total = tables.TotalCount
});
}
catch (Exception ex)
{
logService.Insert(ex);
return(null);
}
}
public ActionResult GetCommodityInfoMain(string id)
{
string key = HotelCloud.Common.HCRequest.GetString("key");//"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID");
string userweixinid = HotelCloud.Common.HCRequest.GetString("userweixinID");
string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch");
string type = HotelCloud.Common.HCRequest.GetString("type");
string sort = HotelCloud.Common.HCRequest.GetString("sort");
string price = HotelCloud.Common.HCRequest.GetString("price");
string selectCity = HotelCloud.Common.HCRequest.GetString("selectCity");
string cityName = HotelCloud.Common.HCRequest.GetString("cityName");
string subitem = HotelCloud.Common.HCRequest.GetString("subitem");
int curpage = HotelCloud.Common.HCRequest.getInt("curpage");
int pagesize = HotelCloud.Common.HCRequest.getInt("pagesize");
int dataCount = HotelCloud.Common.HCRequest.getInt("dataCount");
if (pagesize < 1)
{
pagesize = 6;
}
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
DataTable commodityDataTable = CommodityService.GetCommodityListMain(sort, MallSearch, type, price, subitem, selectCity, cityName, curpage, weixinid, id, false, ref dataCount, pagesize);
return(Json(new
{
dataCount = dataCount,
data = SerializeDataTable(commodityDataTable)
}, JsonRequestBehavior.AllowGet));
}
public SellerBackgroundController(ModelContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
shopService = new ShopService(_context);
commodityService = new CommodityService(_context);
_hostingEnvironment = hostingEnvironment;
}
public ActionResult CommodityRichText(string id)
{
string hotelId = id;
string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id
string commodityId = HotelCloud.Common.HCRequest.GetString("CommodityID"); //酒店微信id
string userweixinid = "";
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
var DataTable = CommodityService.GetDataById(commodityId);
var hotelData = GetHotelBySupermarket(int.Parse(id)).Rows[0];
ViewData["myPoints"] = 0;
var userDt = orderService.GetScoreByUser(weixinid, userweixinid);
if (userDt.Rows.Count > 0)
{
ViewData["myPoints"] = userDt.Rows[0]["Emoney"];
}
ViewData["Address"] = hotelData["address"];
ViewData["soldCount"] = SupermarketOrderDetailService.GetSoldCount(commodityId).Rows[0][0];
ViewData["hotelName"] = DishOrderLogic.GetHotelName(hotelId);
ViewData["commodityTable"] = DataTable;
ViewData["hotelId"] = id;
ViewData["weixinid"] = weixinid;
ViewData["userweixinid"] = userweixinid;
ViewData["CommodityID"] = commodityId;
return(View());
}
public IMessageProvider Save()
{
if (string.IsNullOrWhiteSpace(commodityNo))
{
AddError(1, "请输入商品编码");
return(this);
}
var commdity = CommodityService.GetBycommodityNo(commodityNo);
if (commdity == null)
{
AddError(1, "商品编码不存在");
return(this);
}
var model = SecondKillCommoditysService.GetById(Id);
if (model != null)
{
model.commodityId = commdity.commodityId;
model.num = num;
model.price = price;
model.surplusNum = num - model.payNum;
model.commodityNo = commodityNo;
SecondKillCommoditysService.Update(model);
}
AddMessage("success");
return(this);
}
public void loadForm(bool isDeleteMU)
{
numbTotalBefore = 0m;
shouldRemoveRow = isDeleteMU;
btnUpdateMu.Enabled = false;
dgvMiniUnits.Rows.Clear();
string cmdtyCode;
string gradeCode;
string custName;
{
var withBlock = My.MyProject.Forms.FrmEditAddRailList;
if (isDeleteMU == false)
{
tempDt = withBlock.miniUnitDT;
}
else
{
tempDt = tempDeletedMUDT;
}
// Populate dgv
string totalbStr;
foreach (var mu in tempDt)
{
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
mu.TotalBilled = Convert.ToDecimal(mu.TotalBilled);
}
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 3)
else
{
mu.TotalBilled = Convert.ToInt32(mu.TotalBilled);
// totalbStr = FormatNumber(mu.TotalBilled.ToString, 0)
}
cmdtyCode = CommodityService.GetById(mu.CommodityId).CommodityCode;
gradeCode = GradeService.GetById(mu.GradeId).GradeCode;
custName = CompanyService.GetVWById(mu.CustomerId).CompanyName;
dgvMiniUnits.Rows.Add(withBlock.txtUnitNumber.Text + "(" + MdlBookingManagement.digitToLetter((object)mu.MiniUnitOrder).ToUpper() + ")", custName, cmdtyCode + " " + gradeCode, (object)mu.TotalBilled);
numbTotalBefore = (decimal)(numbTotalBefore + mu.TotalBilled);
}
// Set texts.
if (withBlock.cboCargoType.Text.Equals("BULK"))
{
labelTotalSomething.Text = "Total Weight:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("0.###");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("0.###");
nucTotal.DecimalPlaces = 3;
}
else
{
labelTotalSomething.Text = "Total Pieces:";
lbltotalNumber.Text = withBlock.nudTotalBilledWeight.Value.ToString("#");
numbToReassign = withBlock.nudTotalBilledWeight.Value - numbTotalBefore;
lblTotaltoBeAsgn.Text = numbToReassign.ToString("#");
nucTotal.DecimalPlaces = 0;
}
}
}
public void Read()
{
var account = this.AccountService.GetById(InnerObject.AccountId);
string myName = "无会员信息";
var my = AccountService.QueryAccountWithOwner(new Services.AccountRequest()
{
Ids = new int[] { InnerObject.AccountId }
}).FirstOrDefault();
if (my != null)
{
myName = my.OwnerDisplayName;
}
OrderId = InnerObject.OrderId;
TotalMoney = InnerObject.TotalMoney.ToString("C");
CreateDate = InnerObject.createDate.ToString("yyyy-MM-dd HH:mm:ss");
Creater = InnerObject.Creater;
AccountName = account.Name;
AccountDiaplayName = myName;
Phone = InnerObject.Phone;
Address = InnerObject.Address;
State = ModelHelper.GetBoundText(InnerObject, x => x.State);
Sender = (string.IsNullOrWhiteSpace(InnerObject.Sender)?"无派送信息":InnerObject.Sender);
detials = OrderService.GetByorderId(InnerObject.OrderId).Select(x => new OrderDetialBase(x)).ToList();
foreach (var item in detials)
{
var good = CommodityService.GetById(item.GoodId);
item.GoodName = good.Name;
item.DisplayName = good.DisplayName;
}
}
private void btnEditCommodity_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtCommodity.Text) | string.IsNullOrEmpty(txtCommodityCode.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Fields Empty !", "The Commodity or Commodity Code fields cannot be empty.", this);
}
else if (CommodityService.VerifyByCommodityCode(txtCommodityCode.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Warning!", "This registration code already exists!", this);
}
else if (CommodityId == 0)
{
if (CommodityService.Insert(txtCommodityCode.Text, txtCommodity.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Commodity inserted successfully.", this);
My.MyProject.Forms.frmCommodityGrainMain.LoadCommodity();
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Commodity, please contact the IT department. Error # 0121", this);
}
}
else if (CommodityService.Update(CommodityId, txtCommodityCode.Text, txtCommodity.Text))
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Success", "Commodity updated successfully.", this);
My.MyProject.Forms.frmCommodityGrainMain.LoadCommodity();
Close();
}
else
{
My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Error!", "There was an error when changing the Commodity, please contact the IT department. Error # 0121", this);
}
}
public ActionResult Index(string id)
{
string hotelId = id;
string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id
string userweixinid = "";
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
string search = HotelCloud.Common.HCRequest.GetString("SupermarketSearch");
DataTable commodityDataTable = CommodityService.GetDataByUserId(weixinid, id, userweixinid);
List <DataRow> rows = commodityDataTable.AsEnumerable().ToList();
if (!string.IsNullOrWhiteSpace(search))
{
rows = rows.Where(r => WeiXinPublic.ConvertHelper.ToString(r["Name"]).Contains(search)).ToList();
}
string hotelName = DishOrderLogic.GetHotelName(hotelId);
ViewData["SupermarketSearch"] = search;
ViewData["hotelId"] = id;
ViewData["Address"] = hotelName;
ViewData["weixinid"] = weixinid;
ViewData["userweixinid"] = userweixinid;
ViewData["commodityDataTable"] = commodityDataTable;
ViewData["commodityList"] = rows;
ViewData["CommodityTypeTable"] = CommodityService.GetCommodityTypeByhotelId(weixinid, hotelId, "");
return(View());
}
public ActionResult ShoppingMallByLingZong(string id)
{
string hotelId = id;
string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id
string userweixinid = "";
string search = HotelCloud.Common.HCRequest.GetString("MallSearch");
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
//促销显示
var pList = CommodityService.GetSaleProductsListToList(weixinid, search, "", "");
ViewData["products"] = pList;
ViewData["MallSearch"] = search;
ViewData["hotelId"] = id;
ViewData["weixinid"] = weixinid;
ViewData["userweixinid"] = userweixinid;
ViewData["CommodityTypeTable"] = CommodityService.GetCommodityTypeByWeixinId(weixinid, "", search);
ViewData["CommodityAllTypeTable"] = CommodityService.GetCommodityTypeByWeixinId(weixinid, "", "");
ViewData["CommodityExtensionTable"] = CommodityService.GetCommodityExtensionByWeixinId(weixinid);
return(View());
}
public void Ready()
{
var qq = CommodityService.Query(new Services.CommodityRequest()
{
State = CommodityStates.Normal
}).Select(x => new ListCommodity(x)).ToList();
this.Detial.Merge(qq);
}
public CommodityDetail GetByCommodity(int id)
{
// Load();
var item = CommodityService.GetById(id);
if (item != null && item.commodityState == CommodityStates.putaway)
{
var list = new List <SpecificationAndSpecificationDetail>();
if (!string.IsNullOrWhiteSpace(item.specificationId))
{
string[] spIds = item.specificationId.Split(',');
for (int i = 0; i < spIds.Count(); i++)
{
int specificationId = 0;
int.TryParse(spIds[i], out specificationId);
var specification = SpecificationService.GetSpecificationAndSpecificationDetailById(specificationId);
if (specification != null)
{
list.Add(specification);
}
}
//return new CommodityDetail(item, ImageUrl, list,null);
}
//int userId = 0;
//var user = _securityHelper.GetCurrentUser();
//if (user != null)
// userId = user.CurrentUser.UserId;
//var request = new ReviewRequest();
//request.CommodityId = item.commodityId;
//request.State = ReviewStates.Show;
//request.UserId = userId;
////request.State = ReviewStates.Show;
//ListReviewView ListRv = new ListReviewView();
//var Review = ReviewService.MicroMallQuery(request);
//if(Review!=null)
//{
// ListRv.TotalCount = Review.TotalCount;
// int TotalPage = Math.Max((Review.TotalCount + request.PageSize - 1) / request.PageSize, 1);
// if (1 == TotalPage)
// {
// ListRv.NextPage = 0;
// }
// else if (1 < TotalPage)
// {
// ListRv.NextPage = 2;
// }
// ListRv.List = Review.ModelList.Select(x => new ReviewView() {Content=x.Content, ReviewId=x.ReviewId, SubmitTime=x.SubmitTime.ToString(), UserId=x.UserId, UserName=x.UserName }).ToList();
//}
var site = SiteService.Query(new SiteRequest()).FirstOrDefault();
if (site != null)
{
ImageUrl = site.imageUrl;
}
return(new CommodityDetail(item, ImageUrl, list, null));
}
return(new CommodityDetail(null, "", null, null));
}
void worker()
{
Invoke(new Action(() => txtName.Text = ""));
Invoke(new Action(() => txtBrand.Text = ""));
Invoke(new Action(() => txtPrice.Text = ""));
Invoke(new Action(() => lblBarcode.Text = "- - -"));
Invoke(new Action(() => lblMessageCommodity.Text = ""));
grpPrice.BackColor
= grpName.BackColor
= grpPrice.BackColor
= grpBrand.BackColor = Color.WhiteSmoke;
long barcode = 0;
long.TryParse(txtBarcode.Text.Trim(), out barcode);
if (string.IsNullOrEmpty(txtBarcode.Text) || barcode == 0)
{
timer1.Enabled = false;
return;
}
try
{
commodity = CommodityService.get(barcode);
if (commodity != null)
{
Invoke(new Action(() => txtName.Text = commodity.Name));
Invoke(new Action(() => txtBrand.Text = commodity.Brand));
Invoke(new Action(() => txtPrice.Text = commodity.Price == 0 ? "" : commodity.Price.ToString("N0")));
Invoke(new Action(() => lblMessageCommodity.Text = ""));
Invoke(new Action(() => lblMessageBarcode.Text = ""));
Invoke(new Action(() => lblBarcode.Text = txtBarcode.Text));
Invoke(new Action(() => txtBarcode.Text = ""));
Invoke(new Action(() => txtPrice.Focus()));
}
else
{
Invoke(new Action(() => lblMessageCommodity.Text = ""));
Invoke(new Action(() => lblMessageBarcode.Text = ""));
Invoke(new Action(() => lblMessageCommodity.Text = "هیچ کالایی با این بارکد از پایگاه داده یافت نشد"));
Invoke(new Action(() => lblBarcode.Text = txtBarcode.Text));
Invoke(new Action(() => txtBrand.Focus()));
}
}
catch (Exception ex)
{
Invoke(new Action(() => lblMessageCommodity.Text = ""));
Invoke(new Action(() => lblMessageBarcode.Text = ""));
Invoke(new Action(() => lblMessageBarcode.Text = "فرمت بارکد وارد شده اشتباه می باشد"));
}
timer1.Enabled = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (validate())
{
if (commodity == null)
{
Commodity comm = new Commodity();
if (string.IsNullOrWhiteSpace(lblBarcode.Text) || lblBarcode.Text == "- - -")
{
comm.BarCode = 0;
}
else
{
comm.BarCode = long.Parse(lblBarcode.Text.Trim());
}
comm.Name = txtName.Text.Trim();
comm.Brand = txtBrand.Text;
comm.Price = int.Parse(txtPrice.Text.Replace(",", ""));
CommodityService.add(comm);
lblMessageCommodity.Text = comm.Name + " - با موفقیت دخیره شد";
}
else
{
if (ISChangeValue())
{
commodity.State = 3;
}
else
{
commodity.State = 2;
}
commodity.BarCode = long.Parse(lblBarcode.Text.Trim());
commodity.Name = txtName.Text.Trim();
commodity.Brand = txtBrand.Text;
commodity.Price = int.Parse(txtPrice.Text.Replace(",", ""));
CommodityService.update(commodity);
lblMessageCommodity.Text = commodity.Name + " - با موفقیت دخیره شد";
}
bindGrid();
txtBarcode.Focus();
}
else
{
//lblMessageCommodity.Text = "ورودی اطلاعات دارای اشکال می باشد";
}
}
catch (Exception ex)
{
lblMessageCommodity.Text = ex.Message;
}
}
private void frmEditCommodity_Load(object sender, EventArgs e)
{
if (CommodityId != 0)
{
var L = CommodityService.GetById(CommodityId);
txtCommodity.Text = L.CommodityName;
txtCommodityCode.Text = L.CommodityCode;
}
}
/* TODO ERROR: Skipped EndRegionDirectiveTrivia *//* TODO ERROR: Skipped RegionDirectiveTrivia */
public void LoadCommodity()
{
listCommodity = CommodityService.GetAll();
var Lc = from b in listCommodity
where b.CommodityId > 0
select b;
CommodityBindingSource.DataSource = Lc.ToList();
ListCommodityByColumn = Lc.ToList();
}
void bindGrid()
{
radGridView1.DataSource = CommodityService.getall();
if (radGridView1.Rows.Count() > 0)
{
radGridView1.Rows[radGridView1.Rows.Count - 1].IsCurrent = true;
}
lblUser.Text = "کالاهای افزوده شده : " + radGridView1.Rows.Count;
}
public void Resume(int id)
{
var item = this.CommodityService.GetById(id);
if (item != null && item.State == CommodityStates.Invalid)
{
item.State = CommodityStates.Normal;
CommodityService.Update(item);
Logger.LogWithSerialNo(LogTypes.CommodityResume, SerialNoHelper.Create(), id, item.Name);
AddMessage("resume.success", item.Name);
}
}
public IMessageProvider Create()
{
var serialNo = SerialNoHelper.Create();
// InnerObject.AccountLevel = AccountLevel;
InnerObject.State = PointRebateStates.Normal;
CommodityService.Create(InnerObject);
AddMessage("success", InnerObject.DisplayName);
Logger.LogWithSerialNo(LogTypes.CommodityCreate, serialNo, InnerObject.CommodityId, InnerObject.DisplayName);
return(this);
}
private void FrmGrainInvList_Load(object sender, EventArgs e)
{
firstLoad = true;
var giService = new GrainInventoryService();
dgvInventory.DataSource = GrainInventoryService.GetAllGrainInventory();
using (var db = new WTCCeresEntities())
{
{
var withBlock = cboCustomer;
var categories = new List <int>();
categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER);
categories.Add((int)MdlEnum.CompanyCategory.CUSTOMER_VENDOR);
withBlock.DataSource = CompanyService.GetByCompanyCategoryId(categories, db);
withBlock.DisplayMember = "CompanyName";
withBlock.ValueMember = "CompanyId";
}
var exclusionList = new List <string>();
exclusionList.Add("RELEASED");
{
var withBlock1 = cboUnitNumber;
var newUs = new VW_UnitSourceMiniUnit();
newUs.MiniunitNumber = "";
newUs.MiniUnitId = 0;
var uslist = MiniUnitService.GetAll(exclusionList, db);
uslist.Insert(0, newUs);
withBlock1.DataSource = uslist;
withBlock1.DisplayMember = "MiniUnitNumber";
withBlock1.ValueMember = "MiniUnitId";
withBlock1.SelectedIndex = -1;
}
{
var withBlock2 = cboCommodity;
withBlock2.DataSource = CommodityService.GetAll(db);
withBlock2.DisplayMember = "CommodityCode";
withBlock2.ValueMember = "CommodityId";
}
{
var withBlock3 = cboGrade;
withBlock3.DataSource = GradeService.GetAll(db);
withBlock3.DisplayMember = "GradeCode";
withBlock3.ValueMember = "GradeId";
}
}
firstLoad = false;
}
public void Save()
{
var serialNo = SerialNoHelper.Create();
var item = CommodityService.GetById(CommodityId);
if (item != null)
{
item.DisplayName = DisplayName;
item.Name = Name;
item.Price = Price;
CommodityService.Update(item);
AddMessage("success", item.DisplayName);
Logger.LogWithSerialNo(LogTypes.CommodityEdit, serialNo, item.CommodityId, item.DisplayName);
}
}
public int GetAllCount(int companyId, int customerId, int commodityId, int commodityTypeId, int brandId, int warsehouseId, int status, DateTime? startDate, DateTime? endDate, int userId)
{
var commoditySvc = new CommodityService();
var companySvc = new CompanyService();
var listCommodity = commoditySvc.GetCommodityByUser(userId);
var listCompany = companySvc.GetAllCompanyByUser((int)CustomerType.Internal, userId);
if (listCompany.Count > 0 && listCommodity.Count > 0)
{
List<int> listComm = listCommodity.Select(o => o.Id).ToList();
List<int> listComp = listCompany.Select(o => o.Id).ToList();
var sorts = new List<SortCol> { new SortCol { ColName = "Id", IsDescending = false } };
var func1 = GetQueryExp(companyId, customerId, commodityId, commodityTypeId, brandId, warsehouseId, status, startDate, endDate, listComm, listComp);
return SalesOrderDAL.GetCount(func1);
}
return 0;
}
public void Query()
{
var request = new CommodityRequest();
// fill condition
if (State != States.All)
{
request.State = State;
}
request.DisplayNameWith = DisplayName;
request.NameWith = Name;
var query = CommodityService.Query(request);
this.List = query.ToList(this, x => new ListCommodity(x));
}
public void Ready()
{
var qq = CommodityService.Query(new Services.CommodityRequest()
{
State = CommodityStates.Normal
}).Select(x => new ListCommodity(x)).ToList();
if (Detial == null)
{
this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest()
{
State = CommodityStates.Normal
}).Select(x => new ListCommodity(x)).ToList());
}
this.Detial.Merge(qq);
}
private void radGridView1_CellClick(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
{
if (e.Row.Cells[0].Value == null)
{
return;
}
long barcode = 0;
long.TryParse(e.Row.Cells[0].Value.ToString(), out barcode);
Invoke(new Action(() => txtName.Text = ""));
Invoke(new Action(() => txtBrand.Text = ""));
Invoke(new Action(() => txtPrice.Text = ""));
Invoke(new Action(() => lblBarcode.Text = "- - -"));
Invoke(new Action(() => lblMessageCommodity.Text = ""));
grpPrice.BackColor
= grpName.BackColor
= grpPrice.BackColor
= grpBrand.BackColor = Color.WhiteSmoke;
if (e.ColumnIndex == 5)
{
if (MessageBox.Show("آیا از حذف این کالا مطمئن هستید ؟", "حذف کالا", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
CommodityService.removeCommodity(barcode, e.Row.Cells[1].Value.ToString());
bindGrid();
}
return;
}
commodity = CommodityService.get(barcode, e.Row.Cells[1].Value.ToString());
if (commodity != null)
{
Invoke(new Action(() => txtName.Text = commodity.Name));
Invoke(new Action(() => txtBrand.Text = commodity.Brand));
Invoke(new Action(() => txtPrice.Text = commodity.Price == 0 ? "" : commodity.Price.ToString("N0")));
Invoke(new Action(() => lblMessageCommodity.Text = ""));
Invoke(new Action(() => lblMessageBarcode.Text = ""));
Invoke(new Action(() => lblBarcode.Text = commodity.BarCode + ""));
Invoke(new Action(() => txtPrice.Focus()));
}
}
public void Read(string phone)
{
AccountMsg = OrderService.GetAccountByPhone(phone);
if (AccountMsg == null)
{
this.AddError(LogTypes.AddOrder, "找不到电话号码对应的会员", AccountMsg);
return;
}
Address = AccountMsg.Address;
gender = AccountMsg.Gender == 1 ? "先生" : AccountMsg.Gender == 2 ? "女士" : "保密";
AccountId = AccountMsg.AccountId;
_accountName = AccountMsg.AccountName;
Phone = phone;
this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest()
{
State = CommodityStates.Normal
}).Select(x => new ListCommodity(x)).ToList());
}
public ActionResult GetDataTravelAgencyCommdityLocat(string id)
{
string key = HotelCloud.Common.HCRequest.GetString("key");//"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID");
string userweixinid = HotelCloud.Common.HCRequest.GetString("userweixinID");
string type = HotelCloud.Common.HCRequest.GetString("type");
string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch");
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
DataTable commodityDataTable = CommodityService.GetDataTravelAgencyCommdityLocat(weixinid, type, MallSearch);
return(Json(new
{
data = SerializeDataTable(commodityDataTable)
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 购物车列表
/// </summary>
/// <param name="openId"></param>
/// <returns></returns>
public ListCartDetail GetShoppingCart(int userId)
{
//var tran = TransactionHelper.BeginTransaction();
var model = new ListCartDetail();
try
{
var GetShoppingCart = ShoppingCartService.GetByAccountId(userId);//检测完毕后第二次获取信息
if (GetShoppingCart != null && GetShoppingCart.ModelList != null && GetShoppingCart.ModelList.Count > 0)
{
foreach (var item in GetShoppingCart.ModelList)
{
var model1 = new CartDetailsModel();
var comm = CommodityService.GetById(item.commodityId);
if (comm != null)
{
model1.commodityId = comm.commodityId;
model1.Freight = comm.commodityFreight;
model1.Id = item.shoppingCartId;
model1.Image = GetFirstImage(comm.images);
model1.Price = comm.commodityPrice;
model1.quantity = item.quantity;
model1.CommodityStock = comm.commodityInventory;
model1.specification = item.specification;
model1.Title = comm.commodityName;
model.CartDetailsList.Add(model1);
//model.TotalAmt += model1.Price * model1.quantity;
//model.Freight += model1.Freight;
}
}
}
}
catch (Exception ex)
{
logService.Insert(ex);
return(null);
}
return(model);
}
/// <summary>
/// 获取促销产品信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult GetSaleProductsListToList(string id)
{
string key = HotelCloud.Common.HCRequest.GetString("key"); //"酒店微信id@用户微信id"
string weixinid = HotelCloud.Common.HCRequest.GetString("weixinID"); //酒店微信id
string userweixinid = "";
if (!key.Equals("") && key.Contains("@"))
{
weixinid = key.Split('@')[0];//酒店微信id
userweixinid = key.Split('@')[1];
}
string MallSearch = HotelCloud.Common.HCRequest.GetString("MallSearch");
string cityName = HotelCloud.Common.HCRequest.GetString("cityName");
string price = HotelCloud.Common.HCRequest.GetString("price");
var pList = CommodityService.GetSaleProductsListToList(weixinid, MallSearch, cityName, price);
JavaScriptSerializer serializer = new JavaScriptSerializer();
return(Json(new
{
data = serializer.Serialize(pList)
}, JsonRequestBehavior.AllowGet));
}
public void Read()
{
//var accounts = AccountService.QueryAccountWithOwner(new Services.AccountRequest());
//List<IdNamePair> accountBounded = new List<IdNamePair>();
//int[] ids=new int[accounts.Count()];
//int i=0;
//foreach (var item in accounts)
//{
// ids[i] = item.AccountId; i += 1;
// accountBounded.Add(new IdNamePair() {Key=item.AccountId,Name=item.OwnerDisplayName });
//}
//var accounts2 = AccountService.Query(new Services.AccountRequest()).Where(x => !ids.Contains(x.AccountId));
//foreach (var item in accounts2)
//{
// accountBounded.Add(new IdNamePair() { Key=item.AccountId,Name=item.Name });
//}
//AccountId.Bind(accountBounded);
this.Detial = new MultiCheckList <ListCommodity>(CommodityService.Query(new Services.CommodityRequest()
{
State = CommodityStates.Normal
}).Select(x => new ListCommodity(x)).ToList());
}
public JsonResult GetCommoditiesByCode(string code, string name, string originalName, int commodityTypeID, int commodityCategoryID)
{
try
{
var commodityResult = new { CommodityID = 0, Code = "", Name = "", VATPercent = new decimal(0) };
var result = commodityRepository.SearchCommoditiesByName(code, null).Select(s => new { s.CommodityID, s.Code, s.Name, s.CommodityCategory.VATPercent });
if (result.Count() > 0)
{
commodityResult = new { CommodityID = result.First().CommodityID, Code = result.First().Code, Name = result.First().Name, VATPercent = result.First().VATPercent }
}
;
else
{
CommodityDTO commodityDTO = new CommodityDTO();
commodityDTO.Code = code;
commodityDTO.Name = name;
commodityDTO.OfficialName = name;
commodityDTO.OriginalName = originalName;
commodityDTO.CommodityTypeID = commodityTypeID;
commodityDTO.CommodityCategoryID = commodityCategoryID;
CommodityService commodityService = new CommodityService(this.commodityRepository);
commodityService.UserID = 2; //Ai cung co quyen add Commodity, boi viec add can cu theo UserID = 2: [email protected]
if (commodityService.Save(commodityDTO))
{
commodityResult = new { CommodityID = commodityDTO.CommodityID, Code = commodityDTO.Code, Name = commodityDTO.Name, VATPercent = new decimal(10) }
}
;
}
return(Json(commodityResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { CommodityID = 0, Code = ex.Message, Name = ex.Message, VATPercent = new decimal(10) }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCommoditiesByCode(string code, string name, string originalName, int commodityTypeID, int commodityCategoryID)
{
try
{
var commodityResult = new { CommodityID = 0, Code = "", Name = "", CommodityTypeID = 0, VATPercent = new decimal(0) };
var result = commodityRepository.SearchCommoditiesByName(code, null, true).Select(s => new { s.CommodityID, s.Code, s.Name, s.CommodityTypeID, s.CommodityCategory.VATPercent });
if (result.Count() > 0)
commodityResult = new { CommodityID = result.First().CommodityID, Code = result.First().Code, Name = result.First().Name, CommodityTypeID = result.First().CommodityTypeID, VATPercent = result.First().VATPercent };
else
{
CommodityDTO commodityDTO = new CommodityDTO();
commodityDTO.Code = MVCBase.CommonExpressions.ComposeCommodityCode(code, commodityTypeID);
commodityDTO.Name = name;
commodityDTO.OfficialName = name;
commodityDTO.OriginalName = originalName;
commodityDTO.CommodityTypeID = commodityTypeID;
commodityDTO.CommodityCategoryID = commodityCategoryID;
CommodityService commodityService = new CommodityService(this.commodityRepository);
commodityService.UserID = 2; //Ai cung co quyen add Commodity, boi viec add can cu theo UserID = 2: [email protected]
commodityDTO.PreparedPersonID = commodityService.UserID;
if (commodityService.Save(commodityDTO))
commodityResult = new { CommodityID = commodityDTO.CommodityID, Code = commodityDTO.Code, Name = commodityDTO.Name, CommodityTypeID = commodityDTO.CommodityTypeID, VATPercent = new decimal(10) };
}
return Json(commodityResult, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { CommodityID = 0, Code = ex.Message, Name = ex.Message, VATPercent = new decimal(10) }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult UpdateCommodityIsOpen(int comId, bool isOpen)
{
var commSvc = new CommodityService();
var errorCode = commSvc.UpdateCommodityIsOpen(comId, isOpen);
return MyAjaxHelper.RedirectAjax(errorCode, null);
}
public override ActionResult Index()
{
var commSvc = new CommodityService();
ViewBag.AllCommodities = commSvc.GetAllCommodities();
return View();
}
public List<SalesOrderViewVM> GetSalesOrderByRange(int from, int to, int companyId, int customerId, int commodityId, int commodityTypeId, int brandId, int warsehouseId, int status, DateTime? startDate, DateTime? endDate, int userId)
{
List<SalesOrderViewVM> list = new List<SalesOrderViewVM>();
var commoditySvc = new CommodityService();
var companySvc = new CompanyService();
var listCommodity = commoditySvc.GetCommodityByUser(userId);
var listCompany = companySvc.GetAllCompanyByUser((int)CustomerType.Internal, userId);
if (listCompany.Count > 0 && listCommodity.Count > 0)
{
List<int> listComm = listCommodity.Select(o => o.Id).ToList();
List<int> listComp = listCompany.Select(o => o.Id).ToList();
var sorts = new List<SortCol> { new SortCol { ColName = "Id", IsDescending = false } };
var func1 = GetQueryExp(companyId, customerId, commodityId, commodityTypeId, brandId, warsehouseId, status, startDate, endDate, listComm, listComp);
var result = SalesOrderDAL.Query(func1, sorts, from, to, new List<string> { "Company", "Stock.Company", "Stock.Warehouse", "Stock.Commodity", "Stock.CommodityType", "Stock.Brand" });
foreach (var r in result)
{
SalesOrderViewVM order = new SalesOrderViewVM()
{
Id = r.Id,
Date = r.Date.ToString("yyyy-MM-dd"),
Qty = r.Quantity,
Price = r.Price ?? 0,
Remark = r.Comment,
Status = r.Status,
CustomerName = r.Company.Name,
InterCompanyName = r.Stock.Company.Name,
CommodityName = r.Stock.Commodity.Name,
CommodityTypeName = r.Stock.CommodityType.Name,
BrandName = r.Stock.Brand.Name,
WarsehouseName = r.Stock.Warehouse.Name
};
Type orderStatus = typeof(SalesOrderStatus);
var item = (SalesOrderStatus)Enum.ToObject(orderStatus, r.Status);
string description = EnumHelper.GetDescription<SalesOrderStatus>(item);
var des = description.Split(new char[] { ',' });
order.StatusMsg = des[0];
if (des.Length > 1)
{
order.OptionMsg = des[1];
}
list.Add(order);
}
}
return list;
}
