public ActionResult Index() { List <base_wh_warehouse> depotlist = CommService.GetDepotList(); ViewData["depotlist"] = depotlist; return(View()); }
public ActionResult AddPSKU(string PSKU, string SSKU, string GSKU, string shopid) { ComResult com = new ComResult(); try { if (!Regex.IsMatch(shopid, @"^\+?[1-9][0-9]*$") && !string.IsNullOrEmpty(shopid)) { com.Msg = "只能是数字且不能为空"; com.State = 0; return(Json(com)); } var isok = CommService.AddPSKU(PSKU, SSKU, GSKU, Convert.ToInt32(shopid)); if (isok) { com.State = 1; com.Msg = "添加成功"; } else { com.State = 0; com.Msg = "添加失败"; } return(Json(com)); } catch (Exception ex) { com.State = 0; com.Msg = "添加失败,原因:" + ex.ToString(); return(Json(com)); } }
public ActionResult AssociateExpressCode() { List <base_exp_comp> expresslist = CommService.GetExpress(); ViewData["Expresslist"] = expresslist; return(View()); }
public ActionResult ExportSelectExpress() { List <base_exp_comp> expresslist = CommService.GetExpress(); ViewData["Expresslist"] = expresslist; return(View()); }
public ActionResult Index() { List <base_platform> platformlist = CommService.GetPlatformList(); ViewData["platformlist"] = platformlist; return(View()); }
/// <summary> /// 过滤不插入的SKU /// </summary> /// <param name="shopid"></param> /// <param name="table"></param> /// <returns></returns> public DataTable HasGSKU(int shopid, DataTable table) { try { List <GSKU> GSKUlist = CommService.GetGSKUListByshopID(shopid); GSKU[] str = GSKUlist.ToArray(); List <string> skulist = new List <string>(); //取出所有的需要过滤的SKU GetCSVcolByshopID foreach (var item in str) { skulist.Add(item.gsku); } string csvcol = CommService.GetCSVcolByshopID(shopid);//取出每个店铺SKU存储列 //csvcol.Replace("\"",""); for (int i = 0; i < table.Rows.Count; i++) { if (skulist.Contains(table.Rows[i][csvcol].ToString())) { table.Rows.Remove(table.Rows[i]); } } return(table); } catch (Exception ex) { throw ex; } }
public ActionResult DeletePSKU(string id) //AddPSKU { ComResult com = new ComResult(); try { var isok = CommService.DeletePSKU(Convert.ToInt32(id)); if (isok) { com.State = 1; com.Msg = "删除成功"; } else { com.State = 0; com.Msg = "删除失败"; } return(Json(com)); } catch (Exception ex) { com.State = 0; com.Msg = "删除失败,原因:" + ex.ToString(); return(Json(com)); } }
public Client(ThreadStart rcvThreadProc) { comm = new CommService <Client>(); endPoint = CommService <Client> .makeEndPoint("http://localhost", 4038); comm.rcvr.CreateRecvChannel(endPoint); comm.rcvr.StartRcvThead(rcvThreadProc); }
// GET: ExportCSV public ActionResult Index() { List <base_shop> shoplist = CommService.GetShopList(); List <base_exp_comp> expresslist = CommService.GetExpress(); ViewData["Expresslist"] = expresslist; ViewData["shoplist"] = shoplist; return(View()); }
public TestHarness() { Console.Title = "TestHareness Server"; streamproxy = CreateClientFileServiceChannel("http://localhost:8000/StreamService"); comm = new CommService <TestHarness>(); endPoint = CommService <TestHarness> .makeEndPoint("http://localhost", 4040); comm.rcvr.CreateRecvChannel(endPoint); comm.rcvr.StartRcvThead(rcvThreadProc); }
public ActionResult GetPlatForms() { try { var platlist = CommService.GetPlatformList(); return(Json(platlist)); } catch (Exception ex) { throw ex; } }
public ActionResult GetExpress() { try { var proclylist = CommService.GetExpress(); return(Json(proclylist)); } catch (Exception ex) { throw ex; } }
/// <summary> /// lấy giá api theo thời gian và hạng phòng /// </summary> /// <param name="datetime"></param> /// <param name="roomtypeid"></param> /// <returns></returns> public JsonResult GetPriceByDateInAndRoomType(string datetime, int roomtypeid) { tbl_RoomPriceLevel result = new CommService().GetPrice(roomtypeid, CommService.ConvertStringToDate(datetime)); tbl_RoomPriceLevel_Hour hours = null; if (result != null) { hours = new CommService().GetPriceHour(result.Id).FirstOrDefault(); } return(Json(new { result = result, hours = hours }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetProductClasfly() { try { var proclylist = CommService.GetProclsflyList(); return(Json(proclylist)); } catch (Exception ex) { throw ex; } }
/// <summary> /// lấy giá theo thời gian và id phòng /// </summary> /// <param name="datetime"></param> /// <param name="roomid"></param> /// <returns></returns> public JsonResult GetPriceByDateInAndRoom(string datetime, int roomid) { tbl_Room_Type o = new CommService().GetRoomTypeByRoomID(roomid); if (o == null) { return(Json(new { }, JsonRequestBehavior.AllowGet)); } else { return(GetPriceByDateInAndRoomType(datetime, o.Id)); } }
Client client; //for msg communication public MainWindow() { InitializeComponent(); //----------as a host, listen to channel to receive test result msg --------- Console.Title = "client 2 demo"; client = new Client(rcvThreadProc); //--------as a client, sending test request msg------------------------- for (int i = 0; i < 10; i++) { client.MakeMessage("Yaodong", "testrequest", client.endPoint, CommService <Client> .makeEndPoint("http://localhost", 4040)); client.comm.sndr.PostMessage(client.requestMsg);// put into sndBlockingQ, if there is any msg in the queue, a thread will deal with it. Thread.Sleep(400); } }
public ActionResult GetShops(string platformID) { try { if (string.IsNullOrEmpty(platformID)) { throw new Exception("店铺ID错误"); } var shoplist = CommService.GetShopList(platformID); return(Json(shoplist)); } catch (Exception ex) { throw ex; } }
public JsonResult ThemPhieuBuDinhMuc(int storeid, List <BukhoModel> products) { { var tblorder = new tbl_TransferOrder { SysHotelID = CommService.GetHotelId(), CreatorID = CommService.GetUserId(), DateCreated = DateTime.Now, Status = 1, SupplierID = 0, OrderCode = service.GetTransferCode(), // SupplierCode = order.SoChungTu, InputDate = DateTime.Today, }; List <tbl_TransferOrderDetail> listDetail = new List <tbl_TransferOrderDetail>(); var product = service.GetallProducts(); var cate = service.GetAllCategories(); foreach (var item in products) { var p1 = product.FirstOrDefault(p => p.Id == item.ProductId); var c = cate.FirstOrDefault(p => p.Id == p1?.ProductCateID); listDetail.Add(new tbl_TransferOrderDetail { SysHotelID = CommService.GetHotelId(), item = p1 != null ? p1.Name : "", catalogitemid = p1?.ProductCateID, catalogitem = c != null ? c.Name : "", DateCreated = DateTime.Now, CreatorID = CommService.GetUserId(), quantity = item.Quantity, itemid = item.ProductId, StoreID = item.StoreId, FromStoreId = storeid, Price = Convert.ToInt32(p1?.PriceOrder), }); } var msg = ""; var rs = service.StoreTransfer(tblorder, listDetail); if (string.IsNullOrEmpty(msg)) { msg = "Tạo phiếu lỗi"; } return(Json(new { ResponseCode = (rs ? "01" : "00"), Message = (rs ? "Tạo phiếu thành công" : msg) }, JsonRequestBehavior.AllowGet)); } }
public JsonResult ThemPhieuXuat(Order order, List <OrderDetail> orderdetails) { var tblorder = new tbl_PurchaseOrder { SysHotelID = CommService.GetHotelId(), CreatorID = CommService.GetUserId(), DateCreated = DateTime.Now, Status = 1, SupplierID = 0, OrderCode = order.SoPhieu, SupplierCode = order.SoChungTu, InputDate = Share.Todate(order.NgayNhapHD), DatePayment = Share.Todate(order.NgayChungTu), TypeOrder = 2 }; List <tbl_PurchaseOrderDetail> listDetail = new List <tbl_PurchaseOrderDetail>(); foreach (var item in orderdetails) { listDetail.Add(new tbl_PurchaseOrderDetail { SysHotelID = CommService.GetHotelId(), item = item.ProductName, catalogitemid = item.CateId, catalogitem = item.CateName, DateCreated = DateTime.Now, CreatorID = CommService.GetUserId(), quantity = item.Quantity, itemid = item.ProductId, StoreID = order.StoreId, Price = item.Price, ManufactureDate = Share.Todate(item.NgaySanXuat), ExpirationDate = Share.Todate(item.HanSuDung), }); } var msg = ""; var rs = service.Xuatkho(tblorder, listDetail, ref msg); if (string.IsNullOrEmpty(msg)) { msg = "Tạo phiếu lỗi"; } return(Json(new { ResponseCode = (rs ? "01" : "00"), Message = (rs ? "Tạo phiếu thành công" : msg) }, JsonRequestBehavior.AllowGet)); return(null); }
public ActionResult GetPSKUpage(string pagenum, string onepagecount, string shopID) { ComResult com = new ComResult(); try { if (!Regex.IsMatch(pagenum, @"^\+?[1-9][0-9]*$") && !string.IsNullOrEmpty(pagenum)) { com.Msg = "只能是数字"; com.State = 0; return(Json(com)); } if (!Regex.IsMatch(onepagecount, @"^\+?[1-9][0-9]*$") && !string.IsNullOrEmpty(onepagecount)) { com.Msg = "只能是数字"; com.State = 0; return(Json(com)); } if (!Regex.IsMatch(shopID, @"^\+?[1-9][0-9]*$") && !string.IsNullOrEmpty(shopID)) { com.Msg = "只能是数字"; com.State = 0; return(Json(com)); } if (string.IsNullOrEmpty(shopID)) { com.Msg = "没有选择店铺"; com.State = 0; return(Json(com)); } int totil = 0; int totilpage = 0; var PSKUlist = CommService.GetPSKUListByshopID(Convert.ToInt32(pagenum), Convert.ToInt32(onepagecount), Convert.ToInt32(shopID), out totil, out totilpage); PSKUViewmodel mypkskulist = new PSKUViewmodel(); mypkskulist.PSKUlist = PSKUlist; mypkskulist.totilcount = totil.ToString(); mypkskulist.totilpage = totilpage.ToString(); com.State = 1; com.DataResult = mypkskulist; return(Json(com)); } catch (Exception ex) { throw ex; } }
public JsonResult Add(Order order, List <OrderDetail> orderdetails) { var tblorder = new tbl_TransferOrder { SysHotelID = CommService.GetHotelId(), CreatorID = CommService.GetUserId(), DateCreated = DateTime.Now, Status = 1, SupplierID = 0, OrderCode = order.SoPhieu, // SupplierCode = order.SoChungTu, InputDate = Share.Todate(order.NgayNhapHD), // DatePayment = DateTime.ParseExact(order.NgayChungTu, "dd/MM/yyyy", CultureInfo.InvariantCulture) }; List <tbl_TransferOrderDetail> listDetail = new List <tbl_TransferOrderDetail>(); foreach (var item in orderdetails) { listDetail.Add(new tbl_TransferOrderDetail { SysHotelID = CommService.GetHotelId(), item = item.ProductName, catalogitemid = item.CateId, catalogitem = item.CateName, DateCreated = DateTime.Now, CreatorID = CommService.GetUserId(), quantity = item.Quantity, itemid = item.ProductId, StoreID = order.StoreId, FromStoreId = order.SrcStoreId, Price = item.Price, }); } var msg = ""; var rs = service.StoreTransfer(tblorder, listDetail, ref msg); if (string.IsNullOrEmpty(msg)) { msg = "Tạo phiếu lỗi"; } return(Json(new { ResponseCode = (rs ? "01" : "00"), Message = (rs ? "Tạo phiếu thành công" : msg) }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAllPSkuByShopID(int shopID) { ComResult com = new ComResult(); try { int totil = 0; int totilpage = 0; //默认取第一页,每页2000条数据,相当于全部查询出来,和以前的函数兼容 var PSKUlist = CommService.GetPSKUListByshopID(1, 2000, shopID, out totil, out totilpage); com.State = 1; com.DataResult = PSKUlist; return(Json(com)); } catch (Exception ex) { com.State = 0; com.Msg = ex.Message; return(Json(com)); } }
public PartialViewResult checkRoom(string dtFrom, string dtTo, int?typeRoomId) { DateTime dt1 = CommService.ConvertStringToDate(dtFrom); DateTime dt2 = CommService.ConvertStringToDate(dtTo); //khởi tạo ngày mặc định if (dt1.Year == 1900) { dt1 = DateTime.Now; } if (dt2.Year == 1900) { dt2 = DateTime.Now.AddDays(1); } ViewBag.dtFrom = dt1; ViewBag.dtTo = dt2; List <tbl_Room> result = new ReservationService().getRoomAvailable(dtFrom, dtTo, typeRoomId); return(PartialView("checkRoom", result)); }
//----< Create CommService and listener and start it >--------------- public bool StartService() { if(Util.verbose) Console.Write("\n Receiver starting service"); try { host = CreateListener(); host.Open(); svc = new CommService(); } catch (Exception ex) { Console.Write("\n\n --- creation of Receiver listener failed ---\n"); Console.Write("\n {0}", ex.Message); Console.Write("\n exiting\n\n"); return false; } return true; }
/// <summary> /// lấy ds phòng theo hạng phòng /// </summary> /// <param name="roomtypeid"></param> /// <returns></returns> public JsonResult GetAllRoomByRoomTypeID(int roomtypeid) { List <tbl_Room> lst = new CommService().GetAllRoomByTypeId(roomtypeid); return(Json(new { result = lst }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// lấy reservationid theo phòng đang đặt /// </summary> /// <param name="roomtypeid"></param> /// <returns></returns> public JsonResult GetReservationIDByRoomID(int roomid) { tbl_Reservation_Room lst = new CommService().GetReservationIDByRoomID(roomid); return(Json(new { result = lst }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// lấy checkin theo phòng đang ở /// </summary> /// <param name="roomtypeid"></param> /// <returns></returns> public JsonResult GetCheckInIDByRoomID(int roomid) { tbl_RoomUsing lst = new CommService().GetCheckInIDByRoomID(roomid); return(Json(new { result = lst }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// lấy hạng phòng theo id phòng /// </summary> /// <param name="roomid"></param> /// <returns></returns> public JsonResult GetRoomTypeByRoomID(int roomid) { tbl_Room_Type o = new CommService().GetRoomTypeByRoomID(roomid); return(Json(new { result = o }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出已选择快递到excel string packgecode, int ispacked, int pageSize, int pageIndex=1 /// </summary> /// <returns></returns> public ActionResult ExportToExcel(int expressid, int ispacked, DateTime?starttime, DateTime?endtime) { DBModel.Common.ComResult res = new DBModel.Common.ComResult(); //if (1==ispacked) //{ // res.Msg = "已导出包裹不能再导"; // res.State = 0; // return Json(res); //} int count = 0; List <ExpressPackgeModel> list = _service.GetExpressPackgeAllList(expressid, ispacked, out count, starttime, endtime); ///导出数据 string mymsg = string.Empty; string filename = "Excel" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; string FilePath = "\\DownExcel\\" + filename; // AppDomain.CurrentDomain.BaseDirectory + string expressname = CommService.GetExpressByID(expressid); //bool excisok = ExcelHelper.ListToExcel<ExportViewmodel>(newlist, FilePath, out mymsg); DataTable dt = new DataTable(); dt.Columns.Add("发货时间", typeof(string)); dt.Columns.Add("包裹号", typeof(string)); dt.Columns.Add("客户名", typeof(string)); dt.Columns.Add("客户前地址", typeof(string)); dt.Columns.Add("客户后地址", typeof(string)); dt.Columns.Add("客户电话", typeof(string)); dt.Columns.Add("客户邮编", typeof(string)); dt.Columns.Add("仓库地址", typeof(string)); dt.Columns.Add("仓库邮编", typeof(string)); dt.Columns.Add("店铺名称", typeof(string)); dt.Columns.Add("仓库电话", typeof(string)); dt.Columns.Add("sku", typeof(string)); dt.Columns.Add("打印sku1", typeof(string)); dt.Columns.Add("打印sku2", typeof(string)); dt.Columns.Add("发货类型", typeof(string)); dt.Columns.Add("请求代号", typeof(string)); dt.Columns.Add("请求管理代号", typeof(string)); dt.Columns.Add("运送管理代号", typeof(string)); dt.Columns.Add("客户管理番号", typeof(string)); foreach (var item2 in list) { DataRow dr = dt.NewRow(); dr["发货时间"] = item2.sendtime; dr["包裹号"] = item2.packgecode; dr["客户名"] = item2.custname; dr["客户前地址"] = item2.custaddress1; dr["客户后地址"] = item2.custaddress2; if (item2.custphone.Length < 3)//说明为空 { dr["客户电话"] = item2.custmobile; } else { dr["客户电话"] = item2.custphone; } dr["客户邮编"] = item2.custzip; dr["仓库地址"] = item2.shopaddress; dr["仓库邮编"] = item2.shopzip; dr["店铺名称"] = item2.shopname; dr["仓库电话"] = item2.shopphone; dr["sku"] = item2.sku; dr["打印sku1"] = item2.sku1; dr["打印sku2"] = item2.sku2; if (expressname == "yamato") { dr["发货类型"] = 3; } else if (expressname == "宅急便") { dr["发货类型"] = 0; } else { dr["发货类型"] = 1;//其他暂时为 1 } dr["请求代号"] = item2.daihao; dr["请求管理代号"] = item2.mangagedaihao; dr["运送管理代号"] = item2.senddaihao; dr["客户管理番号"] = item2.packgecode; dt.Rows.Add(dr); } int a = dt.Rows.Count; string error = string.Empty; bool excisok = ExcelHelper.ExcelOutResult(FilePath, dt, "", out error); if (excisok) { res.Msg = "导出成功"; res.State = 1; res.URL = "../DownExcel/" + filename; return(Json(res)); } else { res.Msg = "导出失败"; res.State = 0; return(Json(res)); } }
private void Button_Click_2(object sender, RoutedEventArgs e) { CommService cs = new CommService(); //cs.PostMessage(FileNameTextBox.Text); }
public PartialViewResult GetRoom(string id) { var obj = new CommService().GetAllRoomByTypeId(int.Parse(id)); return(PartialView("_ptvRoom", obj)); }