public object GetDetial(string id)
{
using (var db = new MmsContext())
{
return(db.mms_receiveDetail.AsNoTracking().Where(r => r.BillNo == id).LeftJoin(db.mms_material, r => r.MaterialCode, m => m.MaterialCode, (r, m) => new
{
r.BillNo,
r.RowId,
r.MaterialCode,
r.Unit,
r.CheckNum,
r.Num,
r.RemainNum,
r.UnitPrice,
r.Money,
r.PrePay,
r.SrcBillType,
r.SrcBillNo,
r.SrcRowId,
r.CreatePerson,
r.UpdatePerson,
r.CreateDate,
r.UpdateDate,
m.MaterialName,
m.Model
}).ToList());
}
}
public object Get()
{
using (var db = new MmsContext())
{
var qr = new PageRequest();
return(qr.ToPageList(db.mms_receive.LeftJoin(db.mms_merchants, r => r.SupplierCode, m => m.MerchantsCode, (r, m) => new
{
r.BillNo,
SupplierName = m.MerchantsName,
r.SupplyType,
r.ContractCode,
r.ReceiveDate,
r.TotalMoney,
r.WarehouseCode,
r.OriginalNum,
r.DoPerson,
r.Remark
}).LeftJoin(db.mms_warehouse, r => r.WarehouseCode, w => w.WarehouseCode, (r, w) => new
{
r.BillNo,
r.SupplierName,
r.SupplyType,
r.ContractCode,
r.ReceiveDate,
r.TotalMoney,
w.WarehouseName,
r.OriginalNum,
r.DoPerson,
r.Remark
}), "BillNo", "desc"));
}
}
public object Delete(string id)
{
using (var db = new MmsContext())
{
db.mms_receiveDetail.Remove(r => r.BillNo == id);
db.mms_receive.Remove(r => r.BillNo == id);
db.SaveChanges();
}
return(true);
}
public object GetNames()
{
string q = HttpContext.Current.Request.QueryString["q"];
using (var db = new MmsContext()) {
IQueryable <mms_merchants> names = db.mms_merchants.OrderBy(m => m.MerchantsName);
if (!string.IsNullOrEmpty(q))
{
names = names.Where(m => m.MerchantsName.StartsWith(q));
}
return(names.Take(10).Select(m => m.MerchantsName).ToList());
}
}
public IList <string> GetBillNo()
{
using (var db = new MmsContext())
{
var q = HttpContext.Current.Request.QueryString["q"];
IQueryable <mms_receive> queryable = db.mms_receive;
if (!string.IsNullOrEmpty(q))
{
queryable = queryable.Where(r => r.BillNo.StartsWith(q));
}
return(queryable.OrderBy(r => r.BillNo).Take(10).Select(r => r.BillNo).ToList());
}
}
public object Get()
{
var pageReq = new PageRequest();
using (var db = new MmsContext())
{
IQueryable <mms_check> query = db.mms_check.AsNoTracking();
int total;
query = pageReq.ApplyQuery <mms_check>(query, "BillNo", "desc", out total);
dynamic result = new System.Dynamic.ExpandoObject();
result.rows = query.ToList();
result.total = total;
return(result);
}
}
public object Get(string id)
{
using (var db = new MmsContext())
{
var form = db.mms_receive.Find(id);
if (form == null)
{
form = new mms_receive {
BillNo = id
};
}
var grid = form.mms_receiveDetail.ToList();
return(new { form, grid });
}
}
public ActionResult Edit(string id)
{
mms_check form = null;
List <ComboItem> WarehouseName = null;
using (var db = new MmsContext())
{
WarehouseName = db.mms_warehouse.Select(i => new ComboItem {
Text = i.WarehouseName, Value = i.WarehouseCode
}).ToList();
form = db.mms_check.Find(id);
}
if (form == null)
{
form = new mms_check {
BillNo = id
};
}
return(View(new { form = form, dataSource = new { WarehouseName } }));
}
public string NewBillNo()
{
using (var db = new MmsContext())
{
string head = DateTime.Now.ToString("yyyyMMdd");
var no = db.mms_receive.OrderByDescending(r => r.BillNo).Select(r => r.BillNo).FirstOrDefault();
if (no == null || !no.StartsWith(head))
{
return(head + "0001");
}
else
{
int i = int.Parse(no.Substring(8)) + 1;
if (i > 9999)
{
throw new Exception("意外的超出了可用订单位数！");
}
return(head + i.ToString("D4"));
}
}
}
public ActionResult Edit(string id)
{
mms_receive form = null;
List <ComboItem> warehouseItems = null, payKinds = null, supplyType = null;
using (var db = new MmsContext())
{
form = db.mms_receive.Find(id);
warehouseItems = db.mms_warehouse.OrderBy(w => w.WarehouseName).Select(w => new ComboItem
{
Text = w.WarehouseName,
Value = w.WarehouseCode
}).ToList();
}
using (var db = new SysContext())
{
payKinds = db.sys_code.Where(c => c.CodeType == "PayKind").OrderBy(c => c.Seq).Select(c => new ComboItem
{
Text = c.Text,
Value = c.Code
}).ToList();
supplyType = db.sys_code.Where(c => c.CodeType == "SupplyType").OrderBy(c => c.Seq).Select(c => new ComboItem
{
Text = c.Text,
Value = c.Code
}).ToList();
}
if (form == null)
{
form = new mms_receive {
BillNo = id
};
}
return(View(new { form = form, @readonly = form.ApproveState != null, dataSource = new { warehouseItems, payKinds, supplyType } }));
}
