public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new WMS_BN_TakeStockDetailService();
return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal)));
default:
return("");
}
}
public void Audit(string id, JObject data)
{
var pUpdate = ParamUpdate.Instance()
.Update("WMS_BN_TakeStockDetail")
.Column("ApproveState", data["status"])
.Column("ApproveRemark", data["comment"])
.Column("ApprovePerson", FormsAuth.GetUserData().UserName)
.Column("ApproveDate", DateTime.Now)
.AndWhere("ID", id);
var service = new WMS_BN_TakeStockDetailService();
var rowsAffected = service.Update(pUpdate);
MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}]，请重试或联系管理员！", id);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>WMS_BN_TakeStockDetail</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='BillCode' cp='like'></field>
</where>
</settings>");
var service = new WMS_BN_TakeStockDetailService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public dynamic GetPageData(string id)
{
var masterService = new WMS_BN_TakeStockMainService();
var masterServiceDetial = new WMS_BN_TakeStockDetailService();
var pQuery = ParamQuery.Instance().AndWhere("ID", id);
var data = masterService.GetModel(pQuery);
var pQuery2 = ParamQuery.Instance().AndWhere("BillCode", data.BillCode);
//var pQuery2 = ParamQuery.Instance().AndWhere("BillCode", id);
string orderby = data.TakeStockType == 1 ? "InventoryCode" : "WarehouseCode";
var result = new
{
//主表数据
form = data,
scrollKeys = masterService.ScrollKeys("ID", id),
//明细数据
tab0 = masterServiceDetial.GetDynamicList(pQuery2.OrderBy(orderby)),
};
return(result);
}
public void Edit(dynamic data)
{
var serviceMain = new WMS_BN_TakeStockMainService();
var formWrapperMain = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
WMS_BN_TakeStockMain
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var formWrapperDetail = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
WMS_BN_TakeStockDetail
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
//.GetNewKey("ID", "maxplus");
//判断当前是否首次保存首次保存产生单号
//var currentID = data["form"]["ID"];
//var pQuery = ParamQuery.Instance().AndWhere("ID", currentID);
//var currentInfo = serviceMain.GetModel(pQuery);
//dynamic qm = new
//{
// month = data["form"]["TakeStockYear"],
// year = data["form"]["TakeStockYear"]
//};
//if (currentInfo == null)
//{
// var code = serviceMain.GetMaxBillCode(qm);
// data["form"]["BillCode"] = code;
//}
//判断是否是新增，是的话就判断一个月只能保存一条盘点数据
dynamic qm = new
{
month = data["form"]["TakeStockMonth"],
year = data["form"]["TakeStockYear"]
};
if (qm.month != null || qm.year != null)
{
if (serviceMain.GetTakeStock(Convert.ToInt32(qm.year), Convert.ToInt32(qm.month)) > 0)
{
MmsHelper.ThrowHttpExceptionWhen(true, "一个月只能生成一次盘点！", "");
}
}
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(formWrapperDetail);
var service = new WMS_BN_TakeStockDetailService();
var result = service.EditPage(data, formWrapperMain, tabsWrapper);
}
