Exemplo n.º 1
0
        public ActionResult Index()
        {
            var code             = new sys_codeService();
            var WorkshopCodeList = new SYS_WorkGroupService()
                                   .GetModelList(ParamQuery.Instance()
                                                 .Select("DISTINCT b.DepartID")
                                                 .From("SYS_WorkGroupDetail a LEFT JOIN SYS_WorkGroup b ON a.MainID=b.ID")
                                                 .AndWhere("a.UserCode", MmsHelper.GetUserCode()));
            var WorkshopCode = "";

            var deptInfo = new SYS_BN_DepartmentService().GetDeptInfoByUCode(MmsHelper.GetUserCode());

            if (WorkshopCodeList.Count > 0)
            {
                WorkshopCode = WorkshopCodeList.FirstOrDefault().DepartID;
            }
            //ViewBag.WorkshopCode = WorkshopCode;
            ViewBag.WorkshopCode = deptInfo.DepartmentCode;
            var model = new
            {
                dataSource = new
                {
                },
                urls = new
                {
                    query  = "/api/Mms/MES_WorkingTicket",
                    newkey = "/api/Mms/MES_WorkingTicket/getnewkey",
                    edit   = "/api/Mms/MES_WorkingTicket/edit"
                },
                resx = new
                {
                    noneSelect   = "请先选择一条数据!",
                    editSuccess  = "保存成功!",
                    auditSuccess = "单据已审核!"
                },
                form = new
                {
                    WorkTicketCode = "",
                    ApsCode        = "",
                    TeamName       = "",
                    WorkshopName   = deptInfo == null?"": deptInfo.DepartmentName,
                    ProcessName    = "",
                    WorkStepsName  = "",
                    EquipmentName  = "",
                    ApproveState   = ""
                },
                defaultRow = new
                {
                    IsEnable = 1
                },
                setting = new
                {
                    idField        = "ID",
                    postListFields = new string[] { "ID", "WorkTicketCode", "TicketLevel", "ApsCode", "WorkStepsID", "IsEnable", "WorkshopCode", "WorkshopName", "TeamCode", "TeamName", "CreateTime", "CreatePerson", "ModifyTime", "ModifyPerson", "ActualStartTime", "ActualFinishTime", "ApproveState", "ApprovePerson", "ApproveTime", "ProcessCode", "ProcessName", "WorkStepsName", "WorkStepsLineCode", "WorkStepsContent", "EquipmentCode", "EquipmentName", "TurnTargetName", "TurnTargetCode", "PartCode", "WorkQuantity", "ApproveRemark" }
                }
            };

            return(View(model));
        }
        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_Department
     </table>
     <where>
         <field name='ID' cp='equal'></field>
     </where>
 </settings>");
         var service     = new SYS_BN_DepartmentService();
         var result      = service.Edit(null, listWrapper, data);
     }
        public dynamic Get(RequestWrapper query)
        {
            query.LoadSettingXmlString(@"
    <settings defaultOrderBy='ID'>
        <select>*</select>
        <from>SYS_BN_Department</from>
        <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
                <field name='DepartmentName'         cp='like'></field>
                <field name='IsWorkshop'         cp='equal'></field>
                <field name='IsEnable'       cp='equal'></field>
        </where>
    </settings>");
            var service = new SYS_BN_DepartmentService();
            var pQuery  = query.ToParamQuery();
            var result  = service.GetDynamicListWithPaging(pQuery);

            return(result);
        }
        public ActionResult Index()
        {
            var loginer = FormsAuth.GetUserData <LoginerBase>();
            SYS_BN_Department department = new SYS_BN_Department();

            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 model = new
            {
                urls = new
                {
                    query  = "/api/Mms/MES_MaterialReturnMain",
                    remove = "/api/Mms/MES_MaterialReturnMain/",
                    billno = "/api/Mms/MES_MaterialReturnMain/getnewbillno",
                    audit  = "/api/Mms/MES_MaterialReturnMain/audit/",
                    edit1  = "/Mms/MES_MaterialReturnMain/edit/"
                },
                resx = new
                {
                    detailTitle   = "车间退料明细",
                    noneSelect    = "请先选择一条单据!",
                    deleteConfirm = "确定要删除选中的单据吗?",
                    deleteSuccess = "删除成功!",
                    auditSuccess  = "单据已审核!"
                },
                dataSource = new
                {
                    //dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
                },
                form = new
                {
                    BillCode       = "",
                    DepartmentID   = department.DepartmentCode ?? "",
                    DepartmentName = department.DepartmentName ?? ""
                },
                idField = "ID"
            };

            return(View(model));
        }
        public ActionResult Index()
        {
            var code       = new sys_codeService();
            var department = new SYS_BN_DepartmentService();
            var model      = new
            {
                dataSource = new
                {
                    dsData = department.GetIDNameList()
                },
                urls = new
                {
                    query  = "/api/Mms/SYS_BN_Department",
                    newkey = "/api/Mms/SYS_BN_Department/getnewkey",
                    edit   = "/api/Mms/SYS_BN_Department/edit"
                },
                resx = new
                {
                    noneSelect   = "请先选择一条数据!",
                    editSuccess  = "保存成功!",
                    auditSuccess = "单据已审核!"
                },
                form = new
                {
                    DepartmentName = "",
                    IsWorkshop     = "",
                    IsEnable       = ""
                },
                defaultRow = new
                {
                    IsWorkshop = 1,
                    IsEnable   = 1
                },
                setting = new
                {
                    idField        = "ID",
                    postListFields = new string[] { "ID", "DepartmentName", "DepartmentCode", "ParentCode", "ParentName", "IsWorkshop", "IsEnable" }
                }
            };

            return(View(model));
        }
        public ActionResult Index()
        {
            var    user         = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
            string workshopName = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode ?? "")).DepartmentName ?? "";
            var    model        = new
            {
                urls = new
                {
                    query  = "/api/Mms/MES_WorkshopBatching",
                    remove = "/api/Mms/MES_WorkshopBatching/",
                    billno = "/api/Mms/MES_WorkshopBatching/getnewbillno",
                    audit  = "/api/Mms/MES_WorkshopBatching/audit/",
                    edit1  = "/Mms/MES_WorkshopBatching/edit/"
                },
                resx = new
                {
                    detailTitle   = "单据明细",
                    noneSelect    = "请先选择一条单据!",
                    deleteConfirm = "确定要删除选中的单据吗?",
                    deleteSuccess = "删除成功!",
                    auditSuccess  = "单据已审核!"
                },
                dataSource = new
                {
                    //dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
                },
                form = new
                {
                    BatchingCode   = "",
                    ContractCode   = "",
                    DepartmentName = workshopName,
                    //WorkshopCode = "",
                },
                idField = "BatchingCode"
            };

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