public ActionResult GetCommodityView()
{
CommodityModel model = new CommodityModel();
var CommodityId = Request.QueryString["commodityid"];
try
{
CommodityClient = new CommodityServiceClient();
CommodityDto cmdto = CommodityClient.GetById(CommodityId != null ? Convert.ToInt32(CommodityId) : 0);
model.CommodityId = cmdto.CommodityId;
model.CommoditiesInCommodityClass = cmdto.CommoditiesInCommodityClass;
model.Name = cmdto.Name;
model.BotanicalName = cmdto.BotanicalName;
model.IsActive = cmdto.IsActive;
model.Image = (((!String.IsNullOrEmpty(cmdto.Image)) ? Constants.IMAGEUPLOADPATHCOMMODITY + cmdto.Image : Constants.BLANKIMAGEPATH)).Replace("~/", "../../");
model.CommodityClassList = GetCommodityClassList();
}
catch (Exception ex)
{
return(View("ErrorPage"));
}
finally
{
if (CommodityClient != null)
{
CommodityClient.Close();
}
}
return(View("CommodityView", model));
}
public ActionResult BoothDetail(int id)
{
var _booth = db.Booths.FirstOrDefault(x => x.BoothId == id);
BoothModel _model = new BoothModel();
if (_booth != null)
{
_model.Id = _booth.BoothId;
_model.Name = _booth.BoothName;
_model.Location = _booth.BoothLocation;
_model.Operator = _booth.Operator;
_model.Introduction = _booth.BoothIntroduction;
_model.Commoditys = new List <CommodityModel>();
var _commodities = db.Commoditys.Where(x => x.BoothId == _booth.BoothId).ToList();
foreach (var _commodity in _commodities)
{
CommodityModel model = new CommodityModel();
model.Id = _commodity.CommodityId;
model.Name = _commodity.CommodityName;
model.Price = _commodity.CommodityPrice;
model.Classification = _commodity.CommodityClassification;
_model.Commoditys.Add(model);
}
}
return(View("Details", _model));
}
public async Task <IEnumerable <CommodityModel> > GetCommoditiesAsync()
{
List <CommodityModel> commodities = new List <CommodityModel>();
//string sql = "select * from CommodityRef order by commod_name";
string sql = "select * from Commod_LU order by Descript";
SqlCommand command = new SqlCommand(sql);
command.Connection = _connection;
_connection.Open();
var reader = await command.ExecuteReaderAsync(CommandBehavior.CloseConnection);
DataTable table = new DataTable();
table.Load(reader);
foreach (DataRow row in table.Rows)
{
CommodityModel commodity = new CommodityModel
{
IsChecked = true,
Commodity = row["COMMOD"].ToString(),
CommodityName = row["Descript"].ToString()
};
commodities.Add(commodity);
}
return(commodities);
}
/// <summary>
/// 得到文件名
/// </summary>
/// <returns></returns>
public virtual ActionResult DetailInfo(IList <CommodityParamModel> ps)
{
var model = new CommodityModel();
if (ps != null && ps.Count > 0)
{
var id = ps.Select(it => it.Id.Convert <long>()).ToArray();
var query = new QueryInfo();
query.Query <CommodityEntity>().Where(it => id.Contains(it.Id) && it.Site.Id == SiteId & it.Status == CommodityStatusType.Normal)
.Select(it => new object[] { it.Id, it.Name, it.FileName, it.Password, it.Price,
it.IsShowPrice, it.Description, it.CommodityImages.
Select(s => new object[] { s.FileName, s.Sequence }) });
model.Commodities = this.GetEntities <CommodityEntity>(query);
if (model.Commodities != null)
{
for (int i = 0; i < model.Commodities.Count;)
{
var p = ps.FirstOrDefault(it => it.Id.Convert <long>() == model.Commodities[i].Id);
if (p == null || !string.IsNullOrEmpty(model.Commodities[i].Password) && model.Commodities[i].Password != p.Id)
{
model.Commodities.RemoveAt(i);
continue;
}
i++;
}
}
}
return(View(GetViewPath("~/Views/Commodity/_DetailInfo.cshtml"), model));
}
public CommodityModel GetCommodity(int id)
{
try
{
var check = tRSEntities4.CommodityMasters.Where(x => x.id == id && x.IsActive == true).FirstOrDefault();
if (check != null)
{
CommodityModel commodity = new CommodityModel();
commodity.id = check.id;
commodity.name = check.name;
commodity.commodityType = check.commodityType;
commodity.IsPerishable = check.IsPerishable;
commodity.IsRestricted = check.IsRestricted;
check.IsActive = (bool)commodity.IsActive;
return(commodity);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
public bool SaveCommodity(CommodityModel model)
{
try
{
CommodityMaster db = new CommodityMaster()
{
IsActive = true,
name = model.name,
commodityType = model.commodityType,
IsRestricted = model.IsRestricted,
IsPerishable = model.IsPerishable,
};
if (!CheckIfNameExists(model.name))
{
tRSEntities4.CommodityMasters.Add(db);
tRSEntities4.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
public List <CommodityModel> GetCommodities()
{
try
{
List <CommodityModel> models = new List <CommodityModel>();
var data = tRSEntities4.CommodityMasters.Where(x => x.IsActive == true).ToList();
foreach (var item in data)
{
CommodityModel db = new CommodityModel
{
id = item.id,
name = item.name,
commodityType = item.commodityType,
IsRestricted = item.IsRestricted,
IsPerishable = item.IsPerishable,
IsActive = (bool)item.IsActive,
commodityTypename = tRSEntities4.CommodityTypeMasters.Where(x => x.id == item.commodityType).Select(x => x.Name).FirstOrDefault(),
};
models.Add(db);
}
return(models);
}
catch (Exception e)
{
throw e;
}
}
private void RecipeToDb(List <CommodityShadow> commodityList, string recipeName, string recipeDescription,
RecipeCategory recipeCategory, Recipe recipe = null)
{
var rcModel = new RCModel(_dbPath);
var recipeCommodityModel = new RecipeCommodityModel(_dbPath);
var recipeModel = new RecipeModel(_dbPath);
var commodityModel = new CommodityModel(_dbPath);
if (recipe == null)
{
recipe = recipeModel.CreateRecipe(recipeName, recipeDescription);
}
rcModel.CreateRC(recipe, recipeCategory);
foreach (var commodityShadow in commodityList)
{
if (commodityShadow.Commodity != null)
{
recipeCommodityModel.CreateRecipeCommodity(recipe, commodityShadow.Commodity, commodityShadow.Value,
commodityShadow.Unit.ToString());
}
else
{
var commodity = commodityModel.CreateCommodity(commodityShadow.Name);
recipeCommodityModel.CreateRecipeCommodity(recipe, commodity, commodityShadow.Value,
commodityShadow.Unit.ToString());
}
}
}
public string SetShoppingCount(string token, int shpId, int spCount)
{
string key = string.Concat(token, "SetShopping");
var uComList = CacheHelp.Get <List <CommodityModel> >(key, DateTimeOffset.Now.AddMonths(3), () => null);
if (uComList == null)
{
uComList = new List <CommodityModel>();
}
var um = uComList.Find(o => o.CommodityId == shpId);
if (um == null)
{
CommodityModel cm = GetComInfo(shpId);
if (cm != null)
{
cm.SpCount = spCount;
uComList.Add(cm);
}
}
else
{
um.SpCount = spCount;
}
var state = CacheHelp.Set(key, DateTimeOffset.Now.AddMonths(3), uComList);
ReturnModel re = new ReturnModel();
if (state)
{
re.state = true;
re.rcount = uComList.Count;
}
return(JsonUtil.Serialize(re));
}
public AddUpdateCommdityFrm(MaintainType type, CommodityModel commodity)
{
InitializeComponent();
this.commdodityModel = commodity;
this.maintainType = type;
this.previousImg = this.commdodityModel.CommodityImg;
InitControls();
}
public ActionResult CommodityListIndex()
{
CommodityModel model = new CommodityModel();
FormMode = string.Empty;
model.CommodityList = GetCommodityList();
return(View("CommodityList", model));
}
/// <summary>
/// 得到文件名
/// </summary>
/// <returns></returns>
public virtual ActionResult Detail(IList <CommodityParamModel> ps)
{
var model = new CommodityModel
{
Params = ps
};
return(View(GetViewPath("~/Views/Commodity/Detail.cshtml"), model));
}
public IActionResult Modified(CommodityModel data)
{
data.ImageData = _cache.Get(data.FileName).Object2Bytes();
_server.AddCommodity(data);
ResponseModel response = new ResponseModel();
response.statusCode = "200";
response.message = "success";
return(Json(response));
}
public void AddCommodity(CommodityModel data)
{
Commodity commodityData = new Commodity();
commodityData.Category = data.Category;
commodityData.Image = data.ImageData;
commodityData.Name = data.Name;
commodityData.Url = data.Url;
dbConn.Insert(commodityData);
}
public IActionResult Post([FromBody] CommodityModel newCommodity)
{
try
{
productService.AddProduct(newCommodity);
return(Ok());
}
catch
{
throw new Exception("No se pudo agregar el producto.");
}
}
public CommodityModel GetCommodity(int id)
{
var data = dbConn.QueryFirstOrDefault <Commodity>("select * from Commodity where ID=@ID", new { ID = id });
CommodityModel commodityData = new CommodityModel();
commodityData.ID = id;
commodityData.Category = data.Category;
commodityData.ImageData = data.Image;
commodityData.Name = data.Name;
commodityData.Url = data.Url;
return(commodityData);
}
public ScrapeVM(string dbPath)
{
_commodityModel = new CommodityModel(dbPath);
_recipeModel = new RecipeModel(dbPath);
_rcModel = new RCModel(dbPath);
_recipeCommodityModel = new RecipeCommodityModel(dbPath);
var recipeCategoryVm = new RecipeCategoryVM(dbPath);
_scrape = new Scrape(this);
_scrape.SetContentCategoryDropdown(recipeCategoryVm.GetRecipeCategories());
_scrape.ShowDialog();
}
private void btnAd_Click(object sender, EventArgs e)
{
CommodityModel newCommodityModel = new CommodityModel();
using (AddUpdateCommdityFrm NewCommodityFrm = new AddUpdateCommdityFrm(MaintainType.New, newCommodityModel))
{
var dialogResult = NewCommodityFrm.ShowDialog();
if (dialogResult == DialogResult.OK)
{
this.InitControls();
}
}
}
//POST
public void AddProduct(CommodityModel newProduct)
{
var newProductRegister = new Products()
{
ProductName = newProduct.Name,
QuantityPerUnit = newProduct.Quantity,
UnitPrice = newProduct.Price,
UnitsInStock = newProduct.Stock
};
dbContext.Products.Add(newProductRegister);
dbContext.SaveChanges();
}
public ActionResult Create(CommodityModel commodity)
{
if (ModelState.IsValid)
{
var repo = new CommodityRepository();
var saved = repo.SaveNewCommodity(commodity);
if (saved)
{
return(RedirectToAction("index", "Home"));
}
}
return(View(commodity));
}
public CommodityModelResponse(CommodityModel model)
{
id = model.ID;
date = model.Date.ToUniversalTime().ToString("o");
contract = model.Contract;
price = model.Price;
position = model.Position;
newTradeAction = model.NewTradeAction;
pnlDaily = model.PnlDaily;
this.model = model.Model;
commodity = model.Commodity;
pnlYtd = model.PnlYtd;
pnlLtd = model.PnlLtd;
mddYtd = model.MddYtd;
}
public void DeleteAllContent()
{
// All Model are initialized
var commodiytModel = new CommodityModel(_dbPath);
var rcModel = new RCModel(_dbPath);
var recipeCategoryModel = new RecipeCategoryModel(_dbPath);
var recipeCommodityModel = new RecipeCommodityModel(_dbPath);
var recipeModel = new RecipeModel(_dbPath);
// All data is wiped
rcModel.DeleteAllRC();
recipeCommodityModel.DeleteAllRecipeCommodities();
recipeCategoryModel.DeleteRecipeCategory();
recipeModel.DeleteRecipes();
commodiytModel.DeleteCommodity();
}
public virtual ActionResult Modify(CommodityModel model)
{
if (model == null)
{
return(null);
}
var dataImages = GetCommodityImages(model.Id.Convert <long>());
var dataTags = GetCommodityTags(model.Id.Convert <long>());
var entity = model.CreateEntity(SaveType.Modify, dataImages, dataTags);
var result = new Dictionary <string, object>();
var rev = this.SaveEntity(entity);
var mess = rev ? "" : entity.Errors?.FirstOrDefault()?.Message;
result.Add("Status", rev);
result.Add("Message", mess);
return(this.Jsonp(result));
}
public List <CommodityModel> GetCommoditys()
{
var datas = dbConn.Query <Commodity>("select * from Commodity");
List <CommodityModel> commoditys = new List <CommodityModel>();
foreach (var item in datas)
{
CommodityModel commodity = new CommodityModel();
commodity.ID = item.ID;
commodity.Category = item.Category;
commodity.ImageData = item.Image;
commodity.Name = item.Name;
commodity.Url = item.Url;
commoditys.Add(commodity);
}
return(commoditys);
}
public BusinessModel GetMarketPrice(CommodityModel obj)
{
IList <CommodityModel> List = new List <CommodityModel>();
BusinessModel objBusinessModel = new BusinessModel();
var baseAddress = "https://data.gov.in/node/86943/datastore/export/json";
using (HttpClient client = InitializeURL(baseAddress))
{
HttpResponseMessage response = client.GetAsync(baseAddress).Result;
if (response.IsSuccessStatusCode)
{
var data = response.Content.ReadAsStringAsync().Result;
List = JsonConvert.DeserializeObject <IList <CommodityModel> >(data);
}
}
objBusinessModel.commodityModels = List.Where(x => (obj.commodity == "" || obj.commodity == null || x.commodity == obj.commodity) && (obj.state == "" || obj.state == null || x.state == obj.state) && (obj.district == "" || obj.district == null || x.district == obj.district) && (obj.market == "" || obj.market == null || x.market == obj.market)).ToList();
return(objBusinessModel);
}
public CommodityViewModel(CommodityModel model)
{
this.Id = model.Id;
this.No = model.No;
this.ChName = model.ChName;
this.EnName = model.EnName;
this.ProductCode = model.ProductCode;
this.Type = model.Type;
this.Unit = model.Unit;
this.TariffRate = model.TariffRate;
this.VatRate = model.VatRate;
this.RefundRate = model.RefundRate;
this.CustomsNo = model.CustomsNo;
this.Remark = model.Remark;
}
public bool SaveNewCommodity(CommodityModel commodity)
{
if (commodity != null)
{
using (var context = new ShukRoutingContext())
{
Commodity Commodity = new Commodity()
{
CommodityID = commodity.CommodityID,
CommodityName = commodity.CommodityName
};
context.Commodities.Add(Commodity);
context.SaveChanges();
}
return(true);
}
return(false);
}
public ActionResult AddCommodityIndex()
{
CommodityModel model = new CommodityModel();
string mode = Request.QueryString["mode"] != null ? Request.QueryString["mode"].ToString() : string.Empty;
var CommodityId = Request.QueryString["commodityid"] != null ? Request.QueryString["commodityid"] : null;
try
{
if (mode == "edit")
{
FormMode = mode;
CommodityClient = new CommodityServiceClient();
CommodityDto cmdto = CommodityClient.GetById(CommodityId != null ? Convert.ToInt32(CommodityId) : 0);
Id = cmdto.CommodityId;
model.CommoditiesInCommodityClass = cmdto.CommoditiesInCommodityClass;
model.CommodityClassId = cmdto.CommoditiesInCommodityClass.CommodityClassId;
model.Name = cmdto.Name;
model.BotanicalName = cmdto.BotanicalName;
model.IsActive = cmdto.IsActive;
model.Image = (((!String.IsNullOrEmpty(cmdto.Image)) ? Constants.IMAGEUPLOADPATHCOMMODITY + (Session["UploadedImageFileName"] = cmdto.Image).ToString() : Constants.BLANKIMAGEPATH)).Replace("~/", "../../");
model.CommodityClassList = GetCommodityClassList();
}
else
{
model.Image = Constants.BLANKIMAGEPATH.Replace("~/", "../../");
model.CommodityClassList = GetCommodityClassList();
}
}
catch (Exception ex)
{
return(View("ErrorPage"));
}
finally
{
if (CommodityClient != null)
{
CommodityClient.Close();
}
}
return(View("AddCommodity", model));
}
/// <summary>
/// 得到文件名
/// </summary>
/// <returns></returns>
public virtual ActionResult Detail(long id, string password)
{
var model = new CommodityModel();
var entity = GetCommodity(id);
if (entity != null && (string.IsNullOrEmpty(entity.Password) || entity.Password == password))
{
model.FileNames = new List <string>
{
entity.FullFileName
};
var query = new QueryInfo();
query.Query <CommodityImageEntity>().Where(it => it.Commodity.Id == id && it.Site.Id == SiteId)
.Select(it => new object[] { it.FileName });
var entities = this.GetEntities <CommodityImageEntity>(query);
if (entities != null)
{
model.FileNames.AddList(entities.Select(it => it.FullFileName).ToArray());
}
}
return(View(GetViewPath("~/Views/Commodity/Detail.cshtml"), model));
}
public bool UpdateCommodity(CommodityModel model)
{
try
{
var check = tRSEntities4.CommodityMasters.Where(x => x.id == model.id && x.IsActive == true).FirstOrDefault();
if (check != null)
{
check.name = model.name;
check.commodityType = model.commodityType;
check.IsPerishable = model.IsPerishable;
check.IsRestricted = model.IsRestricted;
//check.isActive = model.isActive;
tRSEntities4.SaveChanges();
return(true);
}
return(false);
}
catch (Exception e)
{
throw e;
}
}
public virtual ActionResult Add(CommodityModel model)
{
if (model == null)
{
return(null);
}
var entity = model.CreateEntity(SaveType.Add, null, null);
entity.Sequence = GetSequence();
var result = new Dictionary <string, object>();
entity.Site = new SiteEntity {
Id = SiteId
};
var rev = this.SaveEntity(entity);
var mess = rev ? "" : entity.Errors?.FirstOrDefault()?.Message;
result.Add("Status", rev);
result.Add("Id", entity.Id);
result.Add("Sequence", entity.Sequence);
result.Add("Message", mess);
return(this.Jsonp(result));
}
public string Add(CommodityViewModel model)
{
#if DEBUG
SysConfig.CurrentUser = UserModel.SingleOrDefault("3");
#endif
if (ModelState.IsValid)
{
CommodityModel commodity = new CommodityModel();
commodity.No = CommonMethod.GetLatestSerialNo(SysConfig.SerialNo.CommodityNo); //商品编号
commodity.ChName = model.ChName; //中文名称
commodity.EnName = model.EnName; //英文名称
commodity.ProductCode = model.ProductCode; //商品货号
commodity.Type = model.Type; //商品类别
commodity.Unit = model.Unit; //商品单位
commodity.TariffRate = model.TariffRate; //关税率
commodity.VatRate = model.VatRate; //增值税率
commodity.RefundRate = model.RefundRate; //退税率
commodity.CustomsNo = model.CustomsNo; //海关编码
commodity.Remark = model.Remark; //备注
commodity.BelongsMan = CommonMethod.GetBelongsMan( //业务员
SysConfig.CurrentUser.Departmentid.ToString());
commodity.BelongsDepartment = CommonMethod.GetBelongsDepartment( //业务部门
SysConfig.CurrentUser.Departmentid.ToString());
commodity.ApprovalStatus = "4"; //默认生效
commodity.DelFlag = 0; //有效状态
commodity.CreateMan = SysConfig.CurrentUser.Id; //制单人
commodity.CreateTime = DateTime.Now; //制单时间
int result = commodity.Insert().ToInt();
if (result > 0)
{
//更新商品最大序列号
CommonMethod.UpdateSerialNo(SysConfig.SerialNo.CommodityNo);
//记录操作日志
CommonMethod.Log(SysConfig.CurrentUser.Id, "Insert", "Sys_Commodity");
CommonMethod.Log(SysConfig.CurrentUser.Id, "Update", "Sys_SerialNo");
return "1";
}
}
return "0";
}
