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); }