public object GetProductSize(int page, int rows, string queryString, string value)
{
string id = "", productCode = "";
if (queryString == "id")
{
id = value;
}
else
{
productCode = value;
}
IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable();
int Id = Convert.ToInt32(id);
var productSize = productSizeQuery.Where(p => p.ID == Id && p.ProductCode.Contains(productCode))
.OrderBy(p => p.ID).AsEnumerable().
Select(p => new
{
p.ID,
p.ProductCode,
p.SizeNo,
p.AreaNo
});
int total = productSize.Count();
productSize = productSize.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = productSize.ToArray() });
}
public bool Save(ProductSize productSize, out string strResult)
{
strResult = string.Empty;
bool result = false;
var pro = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSize.ID);
if (pro != null)
{
try
{
pro.ID = productSize.ID;
pro.ProductCode = productSize.ProductCode;
pro.SizeNo = productSize.SizeNo;
pro.AreaNo = productSize.AreaNo;
ProductSizeRepository.SaveChanges();
result = true;
}
catch (Exception ex)
{
strResult = "原因：" + ex.Message;
}
}
else
{
strResult = "原因：未找到当前需要修改的数据！";
}
return(result);
}
public System.Data.DataTable GetProductSize(int page, int rows, string productCode)
{
IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable();
var productSize = productSizeQuery.Where(p => p.ProductCode.Contains(productCode))
.OrderBy(p => p.ID).AsEnumerable()
.Select(p => new
{
p.ID,
p.ProductCode,
p.SizeNo,
p.AreaNo
});
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("商品ID", typeof(string));
dt.Columns.Add("商品代码", typeof(string));
dt.Columns.Add("件烟尺寸编号", typeof(string));
dt.Columns.Add("存储库区号", typeof(string));
foreach (var item in productSize)
{
dt.Rows.Add
(
item.ID,
item.ProductCode,
item.SizeNo,
item.AreaNo
);
}
return(dt);
}
public bool Delete(int productSizeId, out string strResult)
{
strResult = string.Empty;
bool result = false;
var si = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSizeId);
if (si != null)
{
try
{
ProductSizeRepository.Delete(si);
ProductSizeRepository.SaveChanges();
result = true;
}
catch (Exception)
{
strResult = "原因：已在使用";
}
}
else
{
strResult = "原因：未找到当前需要删除的数据！";
}
return(result);
}
public System.Data.DataTable GetProductSize(int page, int rows, ProductSize productSize)
{
IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable();
IQueryable <Product> productQuery = ProductRepository.GetQueryable();
var productSizeDetail = productSizeQuery.Where(p =>
p.ProductCode.Contains(productSize.ProductCode))
.OrderBy(p => p.ID);
//var productSize_Detail = productSizeDetail.ToArray().Select(p => new
// {
// p.ID,
// p.ProductCode,
// p.ProductNo,
// p.ProductName,
// p.SizeNo,
// p.AreaNo
// });
var productSize_Detail = productSizeDetail.Join(productQuery,
ps => ps.ProductCode,
p => p.ProductCode,
(ps, p) => new { ps.ID, ps.ProductCode, ps.ProductNo, ps.SizeNo, ps.AreaNo, p.ProductName })
.Where(p => p.ProductCode.Contains(productSize.ProductCode))
.OrderBy(p => p.ID).AsEnumerable().Select(p => new
{
p.ID,
p.ProductCode,
p.ProductName,
p.ProductNo,
p.SizeNo,
p.AreaNo
});
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("商品ID", 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 item in productSize_Detail)
{
dt.Rows.Add
(
item.ID,
item.ProductCode,
item.ProductNo,
item.ProductName,
item.SizeNo,
item.AreaNo
);
}
return(dt);
}
public bool Save(ProductSize productSize)
{
var pro = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSize.ID);
pro.ID = productSize.ID;
pro.ProductCode = productSize.ProductCode;
pro.ProductNo = productSize.ProductNo;
pro.SizeNo = productSize.SizeNo;
pro.AreaNo = productSize.AreaNo;
ProductSizeRepository.SaveChanges();
return(true);
}
public bool Delete(int productSizeId)
{
var si = ProductSizeRepository.GetQueryable().FirstOrDefault(s => s.ID == productSizeId);
if (si != null)
{
ProductSizeRepository.Delete(si);
ProductSizeRepository.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public object GetDetails(int page, int rows, string ProductCode, string SizeNo, string AreaNo)
{
IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable();
var productSize = productSizeQuery.Where(p => p.ProductCode.Contains(ProductCode))
.OrderBy(p => p.ID).AsEnumerable()
.Select(p => new
{
p.ID,
p.ProductCode,
p.SizeNo,
p.AreaNo
});
int sizeno = -1, areano = -1;
if ((SizeNo != "" && SizeNo != null) && (AreaNo == "" || AreaNo == null))
{
try { sizeno = Convert.ToInt32(SizeNo); }
catch { sizeno = -1; }
finally { productSize = productSize.Where(p => p.SizeNo == sizeno); }
}
if ((SizeNo == "" || SizeNo == null) && (AreaNo != "" && AreaNo != null))
{
try { areano = Convert.ToInt32(AreaNo); }
catch { areano = -1; }
finally { productSize = productSize.Where(p => p.AreaNo == areano); }
}
if ((SizeNo != "" && SizeNo != null) && (AreaNo != "" && AreaNo != null))
{
try { sizeno = Convert.ToInt32(SizeNo); areano = Convert.ToInt32(AreaNo); }
catch { areano = -1; }
finally { productSize = productSize.Where(p => p.SizeNo == sizeno && p.AreaNo == areano); }
}
productSize = productSize.OrderBy(p => p.ID).AsEnumerable()
.Select(p => new
{
p.ID,
p.ProductCode,
p.SizeNo,
p.AreaNo
});
int total = productSize.Count();
productSize = productSize.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = productSize.ToArray() });
}
public object GetDetails(int page, int rows, ProductSize productSize)
{
IQueryable <ProductSize> productSizeQuery = ProductSizeRepository.GetQueryable();
IQueryable <Product> productQuery = ProductRepository.GetQueryable();
var productSizeDetail = productSizeQuery.Where(p =>
p.ProductCode.Contains(productSize.ProductCode)).OrderBy(p => p.ID);
var productSizeDetail1 = productSizeDetail;
if (productSize.SizeNo != null && productSize.SizeNo != 0)
{
productSizeDetail1 = productSizeDetail.Where(p => p.SizeNo == productSize.SizeNo).OrderBy(p => p.ID);
}
var productSizeDetail2 = productSizeDetail1;
if (productSize.ProductNo != null && productSize.ProductNo != 0)
{
productSizeDetail2 = productSizeDetail1.Where(p => p.ProductNo == productSize.ProductNo).OrderBy(p => p.ID);
}
var productSizeDetail3 = productSizeDetail2;
if (productSize.AreaNo != null && productSize.AreaNo != 0)
{
productSizeDetail3 = productSizeDetail2.Where(p => p.AreaNo == productSize.AreaNo).OrderBy(p => p.ID);
}
int total = productSizeDetail3.Count();
var productSizeDetails = productSizeDetail3.Skip((page - 1) * rows).Take(rows);
var productSize_Detail = productSizeDetails.Join(productQuery,
ps => ps.ProductCode,
p => p.ProductCode,
(ps, p) => new { ps.ID, ps.ProductCode, ps.ProductNo, ps.SizeNo, ps.AreaNo, p.ProductName })
.Where(p => p.ProductCode.Contains(productSize.ProductCode))
.OrderBy(p => p.ID).AsEnumerable().Select(p => new
{
p.ID,
p.ProductCode,
p.ProductName,
p.ProductNo,
p.SizeNo,
p.AreaNo
});
return(new { total, rows = productSize_Detail.ToArray() });
}
