public object GetDetails(int page, int rows, Size size)
{
IQueryable <Size> sizeQuery = SizeRepository.GetQueryable();
var SizeDetail = sizeQuery.Where(s => s.SizeName.Contains(size.SizeName)).OrderBy(s => s.ID);
var SizeDetail1 = SizeDetail;
if (size.SizeNo != null && size.SizeNo != 0)
{
SizeDetail1 = SizeDetail.Where(s => s.SizeNo == size.SizeNo).OrderBy(s => s.ID);
}
int total = SizeDetail.Count();
var sRMDetails = SizeDetail1.Skip((page - 1) * rows).Take(rows);
var sRM_Detail = sRMDetails.ToArray().Select(s => new
{
s.ID,
s.SizeName,
s.Length,
s.SizeNo,
s.Width,
s.Height
});
return(new { total, rows = sRM_Detail.ToArray() });
}
public object GetSize(int page, int rows, string queryString, string value)
{
string id = "", sizeName = "";
if (queryString == "id")
{
id = value;
}
else
{
sizeName = value;
}
IQueryable <Size> sizeQuery = SizeRepository.GetQueryable();
//int Id = Convert.ToInt32(id);
var size = sizeQuery.Where(si => si.SizeName.Contains(sizeName))
.OrderBy(si => si.ID).AsEnumerable().
Select(si => new
{
si.ID,
si.SizeName,
si.SizeNo
});
int total = size.Count();
size = size.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = size.ToArray() });
}
public bool Save(Size size, out string strResult)
{
strResult = string.Empty;
bool result = false;
var si = SizeRepository.GetQueryable().FirstOrDefault(s => s.ID == size.ID);
if (si != null)
{
try
{
si.SizeName = size.SizeName;
si.SizeNo = size.SizeNo;
si.Length = size.Length;
si.Width = size.Width;
si.Height = size.Height;
SizeRepository.SaveChanges();
result = true;
}
catch (Exception ex)
{
strResult = "原因：" + ex.Message;
}
}
else
{
strResult = "原因：未找到当前需要修改的数据！";
}
return(result);
}
public bool Delete(int sizeId, out string strResult)
{
strResult = string.Empty;
bool result = false;
var si = SizeRepository.GetQueryable().FirstOrDefault(s => s.ID == sizeId);
if (si != null)
{
try
{
SizeRepository.Delete(si);
SizeRepository.SaveChanges();
result = true;
}
catch (Exception)
{
strResult = "原因：已在使用";
}
}
else
{
strResult = "原因：未找到当前需要删除的数据！";
}
return(result);
}
public bool Save(Size size)
{
var si = SizeRepository.GetQueryable().FirstOrDefault(s => s.ID == size.ID);
si.ID = size.ID;
si.Height = size.Height;
si.Length = size.Length;
si.Width = size.Width;
si.SizeNo = size.SizeNo;
si.SizeName = size.SizeName;
SizeRepository.SaveChanges();
return(true);
}
public bool Delete(int sizeId)
{
var size = SizeRepository.GetQueryable().FirstOrDefault(s => s.ID == sizeId);
if (size != null)
{
SizeRepository.Delete(size);
SizeRepository.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public object GetDetails(int page, int rows, string SizeName, string SizeNo)
{
IQueryable <Size> sizeQuery = SizeRepository.GetQueryable();
var size = sizeQuery.Where(s => s.SizeName.Contains(SizeName))
.OrderBy(s => s.ID).AsEnumerable()
.Select(s => new
{
s.ID,
s.SizeName,
s.SizeNo,
s.Length,
s.Width,
s.Height
});
if (SizeNo != "" && SizeNo != null)
{
int sizeno = -1;
try { sizeno = Convert.ToInt32(SizeNo); }
catch { sizeno = -1; }
finally
{
size = size.Where(s => s.SizeNo == sizeno)
.OrderBy(s => s.ID).AsEnumerable()
.Select(s => new
{
s.ID,
s.SizeName,
s.SizeNo,
s.Length,
s.Width,
s.Height
});
}
}
int total = size.Count();
size = size.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = size.ToArray() });
}
public System.Data.DataTable GetSize(int page, int rows, Size size)
{
IQueryable <Size> sizeQuery = SizeRepository.GetQueryable();
var sizeDetail = sizeQuery.Where(s =>
s.SizeName.Contains(size.SizeName))
.OrderBy(ul => ul.SizeName);
var size_Detail = sizeDetail.ToArray().Select(s => new
{
s.ID,
s.SizeName,
s.SizeNo,
s.Length,
s.Width,
s.Height
});
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 size_Detail)
{
dt.Rows.Add
(
item.ID,
item.SizeName,
item.SizeNo,
item.Length,
item.Width,
item.Height
);
}
return(dt);
}
public System.Data.DataTable GetSize(int page, int rows, string sizeName)
{
IQueryable <Size> sizeQuery = SizeRepository.GetQueryable();
var size = sizeQuery.Where(si => si.SizeName.Contains(sizeName))
.OrderBy(si => si.ID).AsEnumerable()
.Select(si => new
{
si.ID,
si.SizeName,
si.SizeNo,
si.Length,
si.Width,
si.Height
});
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 size)
{
dt.Rows.Add
(
item.ID,
item.SizeName,
item.SizeNo,
item.Length,
item.Width,
item.Height
);
}
return(dt);
}