public string PostStorage(dynamic data)
{
string msg = "";
var result = new APS_ProductPurchaseDetailService().AuditBillCode(data["mainID"].ToString(), out msg);
return(msg);
}
//todo 改成支持多个Tab
// 地址：GET api/mms/@(controller)/getnewrowid 预取得新的明细表的行号
public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new APS_ProductPurchaseDetailService();
return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal)));
default:
return("");
}
}
public string PostSetType(dynamic data)
{
string msg = "";
string ids = data["ids"].ToString();
ids = ids.Remove(ids.Length - 2, 1);
if (data["UserCode"] == null || data["SaleMan"] == null)
{
msg = "请选择采购员";
}
var result = new APS_ProductPurchaseDetailService().SetType(ids, data["UserCode"].ToString(), data["SaleMan"].ToString(), out msg);
return(msg);
}
public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
APS_ProductPurchaseDetail
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new APS_ProductPurchaseDetailService();
var result = service.Edit(null, listWrapper, data);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>V_ProductPurchaseDetailAndMain</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='ContractCode' cp='equal'></field>
<field name='WarehouseName' cp='like'></field>
<field name='PurchaseDate' cp='equal'></field>
<field name='UserCode' cp='equal'></field>
</where>
</settings>");
var service = new APS_ProductPurchaseDetailService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public string GetDelete(string id)
{
string msg = "删除成功！";
var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", id);
var re = new APS_ProductPurchaseMainService().GetModel(pQuery);
if (re == null || re.BillState == 2)
{
msg = "已审核不能删除！";
}
else
{
var result = new APS_ProductPurchaseMainService().GetDelete(id);
var pQuery2 = ParamQuery.Instance().Select("*").AndWhere("MainID", id);
var services = new APS_ProductPurchaseDetailService();
var list = services.GetModelList(pQuery2);
foreach (var item in list)
{
services.GetDelete(item.ID.ToString());
}
}
return(msg);
}