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 });
}
