public ActionResult Index(int id = 0)
{
var loginer = FormsAuth.GetUserData <LoginerBase>();
SYS_BN_Department department = new SYS_BN_Department();
if (id == 10)
{
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
department = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode));
}
//var dapart=new SYS_BN_DepartmentService().get
var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(loginer.UserCode);
uc = new sys_codeService().Getsys_codeByTypeAndID("BillType", id);
ViewBag.uc = uc;
var model = new
{
urls = new
{
query = "/api/Mms/WMS_BN_BillMain",
remove = "/api/Mms/WMS_BN_BillMain/",
billno = "/api/Mms/WMS_BN_BillMain/getnewbillno",
audit = "/api/Mms/WMS_BN_BillMain/audit/",
edit1 = "/Mms/WMS_BN_BillMain/edit/",
edit2 = "/Mms/WMS_BN_BillMain/customerEdit/?id=newid&type=" + id
},
resx = new
{
detailTitle = uc.Text + "明细",
noneSelect = "请先选择一条单据！",
deleteConfirm = "确定要删除选中的单据吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
dataSource = new
{
//dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
},
form = new
{
BillCode = "",
ContractCode = "",
ProjectName = "",
DepartmentID = department.DepartmentCode ?? "",
DepartmentName = department.DepartmentName ?? "",
SupplierCode = "",
SupplierName = "",
WarehouseCode = "",
WarehouseName = "",
ApproveState = 1
},
idField = "ID"
};
return(View(model));
}
public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
SYS_BN_Warehouse
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BN_WarehouseService();
var result = service.Edit(null, listWrapper, data);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>SYS_BN_Warehouse</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='WarehouseName' cp='like'></field>
<field name='WarehouseType' cp='equal'></field>
<field name='IsEnable' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BN_WarehouseService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>WMS_BN_BillMain</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillCode' cp='like'></field>
<field name='ContractCode' cp='equal'></field>
<field name='DepartmentID' cp='equal'></field>
<field name='SupplierCode' cp='equal'></field>
<field name='WarehouseCode' cp='equal'></field>
<field name='ApproveState' cp='equal'></field>
</where>
</settings>");
var service = new WMS_BN_BillMainService();
//if (WMS_BN_BillMainController.uc.Value =="8")
//{
//var loginer = FormsAuth.GetUserData<LoginerBase>();
//var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(loginer.UserCode);
//var pQuery1 = query.ToParamQuery().AndWhere("ApproveState", 1).AndWhere("BillType","6").AndWhere("WarehouseCode", warehouse.WarehouseCode);
//var result = service.GetDynamicListWithPaging(pQuery1);
//return result;
//}
//else if (WMS_BN_BillMainController.uc.Value == "9")
//{
// var loginer = FormsAuth.GetUserData<LoginerBase>();
// var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(loginer.UserCode);
// var pQuery1 = query.ToParamQuery().AndWhere("ApproveState", 1).AndWhere("BillType", "7").AndWhere("WarehouseCode", warehouse.WarehouseCode);
// var result = service.GetDynamicListWithPaging(pQuery1);
// return result;
//}
//else
var loginer = FormsAuth.GetUserData <LoginerBase>();
var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(loginer.UserCode);
var pQuery = query.ToParamQuery().AndWhere("BillType", WMS_BN_BillMainController.uc.Value);
//.AndWhere("WarehouseCode", warehouse.WarehouseCode);
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetPageData(string id)
{
//var department = new SYS_BN_UserService().GetDepartmentInfo(MmsHelper.GetUserCode());
var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(MmsHelper.GetUserCode());
//if (warehouse == "0")
//{
// MmsHelper.ThrowHttpExceptionWhen(true, "员工" + MmsHelper.GetUserName() + "不是仓储人员，无法进入出入库明细页面！！", 0);
//}
//MmsHelper.ThrowHttpExceptionWhen(warehouse == "0", "请注意，您不是仓储人员，无法进入出入库明细页面！", id);
var masterService = new WMS_BN_BillMainService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var mainData = masterService.GetModel(pQuery);
if (mainData != null)
{
var pQuery2 = ParamQuery.Instance().AndWhere("BillCode", mainData.BillCode);
//mainData.WarehouseName = warehouse.WarehouseName;
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new WMS_BN_BillDetailService().GetDynamicList(pQuery2)
};
return(result);
}
else
{
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = ""
};
return(result);
}
}
public ActionResult Edit(string id = "")
{
//string billCode = new MES_MaterialPickMainService().GetBillCodeByID(id);
var data = new MES_MaterialPickDetailApiController().GetPageData(id);
//string documentNo = MmsHelper.GetOrderNumber("MES_MaterialPickMain", "BillCode", "CJLL", "", "");
var loginer = FormsAuth.GetUserData <LoginerBase>();
var dpartment = new SYS_BN_UserService().GetDepartmentInfo(loginer.UserCode);
SYS_BN_Warehouse warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("ISEnable", 1).AndWhere("WarehouseName", dpartment.DepartmentName));
ViewBag.IsWarehouse = warehouse == null ? 0 : 1;
warehouse = warehouse ?? new SYS_BN_Warehouse();
string departid = "";
var departname = "";
if (dpartment != null)
{
departid = dpartment.DepartmentCode;
departname = dpartment.DepartmentName;
}
string dtNow = DateTime.Now.ToString("yyyy-MM-dd");
var model = new
{
urls = new
{
getdata = "/api/Mms/MES_MaterialPickDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/MES_MaterialPickDetail/edit/", //数据保存api
audit = "/api/Mms/MES_MaterialPickDetail/audit/", //审核api
newkey = "/api/Mms/MES_MaterialPickDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/MES_MaterialPickDetail/PostStorage/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data,
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new MES_MaterialPickMain().Extend(new
{
ID = id,
BillCode = data.form == null ? "系统生成" : data.form.BillCode,
DepartmentID = departid,
DepartmentName = departname,
PickingDate = dtNow,
IsEnable = 1,
BillState = 1,
ContractCode = "",
ProjectName = "",
WarehouseCode = warehouse.WarehouseCode,
WarehouseName = warehouse.WarehouseName
}),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "MainID", "ContractCode", "ProjectName", "InventoryCode", "InventoryName", "RequiredQuantity", "IsEnable", "Model", "Unit", "Material" },
defaults = new { ID = "", MainID = id, ContractCode = "", ProjectName = "", InventoryCode = "", InventoryName = "", RequiredQuantity = "", IsEnable = 1, Model = "", Unit = "", Material = "" }
}
}
};
return(View(model));
}
public ActionResult customerEdit(string id = "", string type = "")
{
uc = new sys_codeService().Getsys_codeByTypeAndID("BillType", int.Parse(type));
ViewBag.uc = uc;
var loginer = FormsAuth.GetUserData <LoginerBase>();
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", loginer.UserCode));
//var department = new SYS_BN_UserService().GetDepartmentInfo(MmsHelper.GetUserCode());
var department = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode));
SYS_BN_Warehouse warehouse = new SYS_BN_Warehouse();
if (department.DepartmentCode == "0107")
{
warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
}
else
{
warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("ISEnable", 1).AndWhere("WarehouseName", department.DepartmentName));
}
//var department=new SYS_BN_DepartmentService().GetIDNameList(MmsHelper.GetUserCode())
warehouse = warehouse ?? new SYS_BN_Warehouse();
ViewBag.user = warehouse.WarehouseCode == null ? 0 : 1;
var data = new WMS_BN_BillDetailApiController().GetPageData(id);
string billCode = new WMS_BN_BillMainService().GetBillCodeByID(id);
//string documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", uc.Description, "", "");
var model = new
{
urls = new
{
getdata = "/api/Mms/WMS_BN_BillDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/WMS_BN_BillDetail/edit/", //数据保存api
audit = "/api/Mms/WMS_BN_BillDetail/audit/", //审核api
newkey = "/api/Mms/WMS_BN_BillDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/WMS_BN_BillDetail/PostStorage/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data,
DepartmentID = department.DepartmentCode,
DepartmentName = department.DepartmentName,
WarehouseCode = warehouse.WarehouseCode,
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new WMS_BN_BillMain().Extend(new { ID = data.scrollKeys.current, BillCode = data.form == null ? "系统生成" : data.form.BillCode, BillType = uc.Value, ContractCode = "", DepartmentID = "", DepartmentName = "", SupplierCode = "", WarehouseCode = warehouse.WarehouseCode, WarehouseName = warehouse.WarehouseName, ApproveState = "1", ApprovePerson = "", ApproveDate = "", ApproveRemark = "", Remark = "", CreatePerson = MmsHelper.GetUserName(), CreateTime = DateTime.Now, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = DateTime.Now }),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "BillCode", "OrderBillCode", "InventoryCode", "InventoryName", "Specs", "Unit", "MateNum", "ConfirmNum", "UnitPrice", "TotalPrice", "PackageCode", "BatchCode", "PBillCode", "AccountabilityCode", "Remark", "CreatePerson", "CreateTime", "ModifyPerson", "ModifyTime", "IsEnable" },
defaults = new { ID = "", BillCode = billCode, InventoryCode = "", InventoryName = "", Unit = "", MateNum = "", ConfirmNum = "", PackageCode = "", BatchCode = "", PBillCode = "", AccountabilityCode = "", Remark = "", CreatePerson = "", CreateTime = "", ModifyPerson = "", ModifyTime = "", IsEnable = 1 }
}
}
};
return(View("Edit", model));
}
