public MaterialPurchase(int depId, HMaterialHelper.ErpPurchase erpPurchase, string createUserId, DateTime now, MaterialPurchaseStateEnum state, MaterialPurchasePriorityEnum priority) { CreateUserId = createUserId; MarkedDateTime = now; Time = DateTime.Parse(erpPurchase.f_date); IsErp = true; ErpId = erpPurchase.f_id; DepartmentId = depId; Purchase = erpPurchase.f_title; Number = erpPurchase.f_name; Name = erpPurchase.f_ygxm; Valuer = erpPurchase.f_hjry ?? ""; Step = erpPurchase.f_bz; State = state; IsDesign = erpPurchase.f_istz == "是"; Priority = priority; }
/// <summary> /// /// </summary> //public static IEnumerable<MaterialPurchase> GetMenus(int categoryId, int nameId, int supplierId, int specificationId, int siteId) //{ // string sql; // if (categoryId != 0 && nameId == 0 && supplierId == 0 && specificationId == 0) // { // sql = // "SELECT a.Price, b.CategoryId, b.Category, b.NameId, b.`Name`, b.SupplierId, b.Supplier, b.Specification, a.SpecificationId, a.SiteId FROM `material_bill` a " + // "JOIN (SELECT a.*, b.CategoryId, b.Category, b.NameId, b.`Name`, b.Supplier FROM `material_specification` a " + // "JOIN (SELECT a.*, b.`Name`, b.CategoryId, b.Category FROM `material_supplier` a " + // "JOIN (SELECT a.*, b.Category FROM `material_name` a " + // "JOIN `material_category` b ON a.CategoryId = b.Id WHERE a.CategoryId = @categoryId) b ON a.NameId = b.Id) b ON a.SupplierId = b.Id) b ON a.SpecificationId = b.Id " + // $"WHERE a.`MarkedDelete` = 0{(siteId == 0 ? "" : " AND a.SiteId = @siteId")};"; // } // else if (nameId != 0 && supplierId == 0 && specificationId == 0) // { // sql = // "SELECT a.Price, b.CategoryId, b.Category, b.NameId, b.`Name`, b.SupplierId, b.Supplier, b.Specification, a.SpecificationId, a.SiteId FROM `material_bill` a " + // "JOIN (SELECT a.*, b.CategoryId, b.Category, b.NameId, b.`Name`, b.Supplier FROM `material_specification` a " + // "JOIN (SELECT a.*, b.`Name`, b.CategoryId, b.Category FROM `material_supplier` a " + // "JOIN (SELECT a.*, b.Category FROM `material_name` a " + // "JOIN `material_category` b ON a.CategoryId = b.Id) b ON a.NameId = b.Id WHERE a.NameId = @nameId) b ON a.SupplierId = b.Id) b ON a.SpecificationId = b.Id " + // $"WHERE a.`MarkedDelete` = 0{(siteId == 0 ? "" : " AND a.SiteId = @siteId")};"; // } // else if (supplierId != 0 && specificationId == 0) // { // sql = // "SELECT a.Price, b.CategoryId, b.Category, b.NameId, b.`Name`, b.SupplierId, b.Supplier, b.Specification, a.SpecificationId, a.SiteId FROM `material_bill` a " + // "JOIN (SELECT a.*, b.CategoryId, b.Category, b.NameId, b.`Name`, b.Supplier FROM `material_specification` a " + // "JOIN (SELECT a.*, b.`Name`, b.CategoryId, b.Category FROM `material_supplier` a " + // "JOIN (SELECT a.*, b.Category FROM `material_name` a " + // "JOIN `material_category` b ON a.CategoryId = b.Id) b ON a.NameId = b.Id) b ON a.SupplierId = b.Id WHERE a.SupplierId = @supplierId) b ON a.SpecificationId = b.Id " + // $"WHERE a.`MarkedDelete` = 0{(siteId == 0 ? "" : " AND a.SiteId = @siteId")};"; // } // else if (specificationId != 0) // { // sql = // "SELECT a.Price, b.CategoryId, b.Category, b.NameId, b.`Name`, b.SupplierId, b.Supplier, b.Specification, a.SpecificationId, a.SiteId FROM `material_bill` a " + // "JOIN (SELECT a.*, b.CategoryId, b.Category, b.NameId, b.`Name`, b.Supplier FROM `material_specification` a " + // "JOIN (SELECT a.*, b.`Name`, b.CategoryId, b.Category FROM `material_supplier` a " + // "JOIN (SELECT a.*, b.Category FROM `material_name` a " + // "JOIN `material_category` b ON a.CategoryId = b.Id) b ON a.NameId = b.Id) b ON a.SupplierId = b.Id) b ON a.SpecificationId = b.Id " + // $"WHERE a.SpecificationId = @specificationId AND a.`MarkedDelete` = 0{(siteId == 0 ? "" : " AND a.SiteId = @siteId")};"; // } // else // { // sql = // "SELECT a.Price, b.CategoryId, b.Category, b.NameId, b.`Name`, b.SupplierId, b.Supplier, b.Specification, a.SpecificationId, a.SiteId FROM `material_bill` a " + // "JOIN (SELECT a.*, b.CategoryId, b.Category, b.NameId, b.`Name`, b.Supplier FROM `material_specification` a " + // "JOIN (SELECT a.*, b.`Name`, b.CategoryId, b.Category FROM `material_supplier` a " + // "JOIN (SELECT a.*, b.Category FROM `material_name` a " + // "JOIN `material_category` b ON a.CategoryId = b.Id) b ON a.NameId = b.Id) b ON a.SupplierId = b.Id) b ON a.SpecificationId = b.Id " + // $"WHERE a.`MarkedDelete` = 0{(siteId == 0 ? "" : " AND a.SiteId = @siteId")};"; // } // return ServerConfig.ApiDb.Query<dynamic>(sql, new { categoryId, nameId, supplierId, specificationId }); //} #endregion #region Add #endregion #region Update public static void Update(IEnumerable <int> pIds, MaterialPurchaseStateEnum state, DateTime time) { ServerConfig.ApiDb.Execute( "UPDATE `material_purchase` SET `MarkedDateTime` = @time, `State` = @state WHERE Id IN @pIds;", new { time, state, pIds }); }