public dynamic GetPageData(string id)
{
var masterService = new QMS_GoodsCheckService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var mainData = masterService.GetModel(pQuery);
if (mainData != null)
{
var pQuery2 = ParamQuery.Instance().AndWhere("MainID", mainData.ID);
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = new QMS_GoodsInspectionItemService().GetDynamicList(pQuery2)
};
return(result);
}
else
{
var result = new
{
//主表数据
form = mainData,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = ""
};
return(result);
}
}
public void Audit(string id, JObject data)
{
var pUpdate = ParamUpdate.Instance()
.Update("QMS_GoodsCheck")
.Column("ApproveState", data["status"])
.Column("ApproveRemark", data["comment"])
.Column("ApprovePerson", FormsAuth.GetUserData().UserName)
.Column("ApproveDate", DateTime.Now)
.AndWhere("ID", id);
var service = new QMS_GoodsCheckService();
var rowsAffected = service.Update(pUpdate);
MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
}
public string PostStorage(dynamic data)
{
string msg = "";
string BillCode = data["BillCode"];
var result = new QMS_GoodsInspectionItemService().AuditBillCode(BillCode, out msg);
//生成物料条码：外购件
var QMS_GoodsCheckModel = new QMS_GoodsCheckService().GetModel(ParamQuery.Instance().AndWhere("BillCode", BillCode));
if (QMS_GoodsCheckModel != null)
{
string InnerFactoryBatch = QMS_GoodsCheckModel.BatchCode; //厂内批次
string OuterFactoryBatch = QMS_GoodsCheckModel.OuterFactoryBatch; //厂外批次
string InventoryCode = QMS_GoodsCheckModel.InventoryCode; //存货编码
var SysPartModel = new SYS_PartService().GetModel(ParamQuery.Instance().AndWhere("InventoryCode", InventoryCode));
if (SysPartModel != null)
{
string InventoryName = SysPartModel.InventoryName;
string PartCode = SysPartModel.PartCode;
string PartName = SysPartModel.PartName;
string PartFigureCode = SysPartModel.FigureCode;
//string CorrespondingBarcode = SysPartModel.CorrespondingBarcode; //无用字段
var SYS_MaterialBatchModel = new SYS_MaterialBatchService().GetModel(ParamQuery.Instance()
.AndWhere("PartCode", PartCode)
.AndWhere("InnerFactoryBatch", InnerFactoryBatch)
.AndWhere("OuterFactoryBatch", OuterFactoryBatch));
if (SYS_MaterialBatchModel == null)
{
var model = new SYS_MaterialBatchService();
string MateBarCode = model.CreateMateBarCode(0);
model.Insert(ParamInsert.Instance()
.Insert("SYS_MaterialBatch")
.Column("MateBarCode", MateBarCode)
.Column("InventoryCode", InventoryCode)
.Column("InventoryName", InventoryName)
.Column("PartCode", PartCode)
.Column("PartFigureCode", PartFigureCode)
.Column("PartName", PartName)
.Column("InnerFactoryBatch", InnerFactoryBatch)
.Column("OuterFactoryBatch", OuterFactoryBatch));
}
}
}
return(msg);
}
public void Edit(dynamic data)
{
var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
QMS_GoodsCheck
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>QMS_GoodsInspectionItem</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
if (data.form["BillCode"] == "系统生成")
{
string documentNo = MmsHelper.GetOrderNumber("QMS_GoodsCheck", "BillCode", "LLJY", "", "");
data.form["BillCode"] = documentNo;
foreach (JToken tab in data["tabs"].Children())
{
foreach (JProperty item in tab.Children())
{
if (item.Name == "inserted")
{
foreach (var row in item.Value.Children())
{
row["BillCode"] = documentNo;
}
}
}
}
}
var service = new QMS_GoodsCheckService();
var result = service.EditPage(data, formWrapper, tabsWrapper);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>QMS_GoodsCheck</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillCode' cp='like'></field>
<field name='ProjectName' cp='equal'></field>
<field name='ArrivalDate' cp='daterange'></field>
</where>
</settings>");
var service = new QMS_GoodsCheckService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
