protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        PurchaseAskPriceModel PurchaseAskPriceM = new PurchaseAskPriceModel();

        PurchaseAskPriceM.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        PurchaseAskPriceM.AskNo      = txtAskNo.Value;
        PurchaseAskPriceM.AskTitle   = txtAskTitle.Value;
        PurchaseAskPriceM.FromType   = ddlFromType.Value;
        PurchaseAskPriceM.DeptID     = hidDeptID.Value;
        PurchaseAskPriceM.AskUserID  = hidUserID.Value;
        PurchaseAskPriceM.BillStatus = ddlBillStatus.Value;
        PurchaseAskPriceM.ProviderID = hidProviderID.Value;
        PurchaseAskPriceM.FlowStatus = ddlFlowStatus.Value;
        PurchaseAskPriceM.AskDate    = StartAskDate.Value;
        PurchaseAskPriceM.EndAskDate = EndAskDate.Value;
        PurchaseAskPriceM.EFDesc     = GetBillExAttrControl1.GetExtTxtValue;
        PurchaseAskPriceM.EFIndex    = GetBillExAttrControl1.GetExtIndexValue;

        string    OrderBy = hidOrderBy.Value;
        DataTable dt      = PurchaseAskPriceBus.GetPurchaseAskPrice(PurchaseAskPriceM, OrderBy);


        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "询价单编号", "询价单主题", "供应商", "询价日期", "询价员", "当前询价次数", "金额合计", "税额合计", "含税金额合计", "单据状态", "审批状态" },
                                          new string[] { "AskNo", "AskTitle", "ProviderName", "AskDate", "AskUserName", "AskOrder", "TotalPrice", "TotalTax", "TotalFee", "BillStatusName", "FlowStatusName" },
                                          "采购询价单列表");
    }
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StockAccountModel model = new StockAccountModel();

        model.CompanyCD   = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.ProductNo   = txtProductNo.Value;
        model.ProductName = txtProductName.Value;
        string AlarmType = sltAlarmType.Value;
        string BarCode   = HiddenBarCode.Value.Trim();

        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageProductAlarmBus.GetStorageProductAlarm(AlarmType, model, orderBy, BarCode);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "物品编号", "物品名称", "物品分类", "规格", "单位", "库存下限", "库存上限", "安全库存", "现有存量", "报警类型" },
                                          new string[] { "ProductNo", "ProductName", "TypeID", "Specification", "UnitID", "MinStockNum", "MaxStockNum", "SafeStockNum", "ProductCount", "AlarmType" },
                                          "库存报警列表");
    }
예제 #3
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                            //排序
            string order       = "asc";                                                                                                //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            string CustID        = hiddCustID.Value;     //客户ID
            string CustLinkMan   = txtCustLinkMan.Value; //被联络人
            string LinkDateBegin = txtLinkDateBegin.Value;
            string LinkDateEnd   = txtLinkDateEnd.Value;
            string CompanyCD     = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID     = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();

            DataTable dt = ContactHistoryBus.ExportContactInfo(CanUserID, CustID, CustLinkMan, CompanyCD, LinkDateBegin, LinkDateEnd, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "联络单编号", "联络主题", "客户名称", "我方联络人", "联络时间", "客户联络人" },
                                              new string[] { "ContactNo", "Title", "CustNam", "Linker", "LinkDate", "LinkManName" },
                                              "客户联络列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #4
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        PurchaseApplyModel PurchaseApplyM = new PurchaseApplyModel();

        PurchaseApplyM.CompanyCD      = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        PurchaseApplyM.ApplyNo        = txtapplyno.Value;
        PurchaseApplyM.Title          = txttitle.Value;
        PurchaseApplyM.ApplyUserID    = hidApplyID.Value;
        PurchaseApplyM.ApplyDeptID    = hidDeptID.Value;
        PurchaseApplyM.TypeID         = ddlTypeID.SelectedValue;
        PurchaseApplyM.FromType       = ddlfromtype.Value;
        PurchaseApplyM.StartApplyDate = txtstartapplydate.Value;
        PurchaseApplyM.EndApplyDate   = txtendapplydate.Value;
        PurchaseApplyM.BillStatus     = ddlBillStatus.Value;
        PurchaseApplyM.FlowStatus     = ddlFlowStatus.Value;
        PurchaseApplyM.EFIndex        = GetBillExAttrControl1.GetExtIndexValue;
        PurchaseApplyM.EFDesc         = GetBillExAttrControl1.GetExtTxtValue;

        string    OrderBy = hidOrderBy.Value;
        DataTable dt      = PurchaseApplyBus.SelectPurchaseApply(PurchaseApplyM, OrderBy);


        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "申请单编号", "申请单主题", "采购类别", "源单类型", "申请人", "申请部门", "申请时间", "单据状态", "审批状态" },
                                          new string[] { "ApplyNo", "Title", "TypeName", "FromTypeName", "ApplyUserName", "ApplyDeptName", "ApplyDate", "BillStatusName", "FlowStatusName" },
                                          "采购申请列表");
    }
예제 #5
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        PurchaseOrderModel PurchaseOrderM = new PurchaseOrderModel();

        PurchaseOrderM.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        PurchaseOrderM.OrderNo    = txtOrderNo.Value;
        PurchaseOrderM.Title      = txtOrderTitle.Value;
        PurchaseOrderM.TypeID     = ddlTypeID.SelectedValue;
        PurchaseOrderM.DeptID     = hidDeptID.Value;
        PurchaseOrderM.Purchaser  = hidPurchaseID.Value;
        PurchaseOrderM.FromType   = ddlFromType.Value;
        PurchaseOrderM.ProviderID = hidProviderID.Value;
        PurchaseOrderM.BillStatus = ddlBillStatus.Value;
        PurchaseOrderM.FlowStatus = ddlFlowStatus.Value;
        PurchaseOrderM.ProjectID  = this.hidProjectID.Value;
        PurchaseOrderM.EFIndex    = GetBillExAttrControl1.GetExtIndexValue;
        PurchaseOrderM.EFDesc     = GetBillExAttrControl1.GetExtTxtValue;
        string OrderBy = hidOrderBy.Value;

        DataTable dt = PurchaseOrderBus.GetPurchaseOrder(PurchaseOrderM, OrderBy);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "订单编号", "订单主题", "采购类别", "采购员", "供应商", "金额合计", "税额合计", "含税金额合计", "单据状态", "审批状态", "是否已建单" },
                                          new string[] { "OrderNo", "OrderTitle", "TypeName", "PurchaserName", "ProviderName", "TotalPrice", "TotalTax", "TotalFee", "BillStatusName", "FlowStatusName", "isOpenBillName" },
                                          "采购订单列表");
    }
예제 #6
0
    //导出
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                            //排序
            string order       = "desc";                                                                                               //排序:降序

            string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "asc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            CustCallModel CustCallM = new CustCallModel();
            CustCallM.CustID = hiddCustID.Value == "" ? 0 : Convert.ToInt32(hiddCustID.Value);
            CustCallM.Tel    = txtTel.Value;
            string DateBegin = txtDateBegin.Value.Trim(); //开始时间

            string DateEnd = txtDateEnd.Value.Trim();     //结束时间
            CustCallM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;

            DataTable dt = CustCallBus.GetCustCallByCon(CustCallM, DateBegin, DateEnd, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "客户名称", "来电号码", "来电时间", "来电标题", "来电人", "创建人" },
                                              new string[] { "CustName", "Tel", "CallTime", "Title", "Callor", "EmployeeName" },
                                              "来电记录列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #7
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        PurchasePlanModel PurchasePlanM = new PurchasePlanModel();

        PurchasePlanM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        PurchasePlanM.PlanNo    = txtPlanNo.Value;
        PurchasePlanM.Title     = txtPlanTitle.Value;

        PurchasePlanM.PlanUserID    = PlanUserID.Value;
        PurchasePlanM.PlanMoney     = txtTotalMoneyMin.Value;
        PurchasePlanM.TotalMoneyMax = txtTotalMoneyMax.Value;
        PurchasePlanM.PlanDeptID    = txtDeptID.Value;
        PurchasePlanM.PlanDate      = txtStartPlanDate.Value;
        PurchasePlanM.EndPlanDate   = txtEndPlanDate.Value;
        PurchasePlanM.BillStatus    = ddlFlowStatus.Value;
        PurchasePlanM.FlowStatus    = ddlFlowStatus.Value;
        PurchasePlanM.EFIndex       = GetBillExAttrControl1.GetExtIndexValue;
        PurchasePlanM.EFDesc        = GetBillExAttrControl1.GetExtTxtValue;
        string OrderBy = hidOrderBy.Value;
        //XElement dsXML = ConvertDataTableToXML(PurchasePlanBus.SelectPurchasePlan(PurchasePlanM));
        DataTable dt = PurchasePlanBus.SelectPurchasePlan(PurchasePlanM, OrderBy);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "计划单编号", "计划单主题", "计划员", "预控金额", "计划时间", "单据状态", "审批状态" },
                                          new string[] { "PlanNo", "PlanTitle", "PlanUserName", "PlanMoney", "PlanDate", "BillStatusName", "FlowStatusName" },
                                          "采购计划列表");
    }
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageInProcessModel model = new StorageInProcessModel();
        string EnterDateStart       = string.Empty;
        string EnterDateEnd         = string.Empty;
        string StorageID            = string.Empty;
        string FromBillNo           = string.Empty;

        model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.InNo      = txtInNo.Value;
        model.Title     = txtTitle.Value;

        model.ProcessDept = txtDeptProcessID.Value;
        model.DeptID      = txtDeptID.Value;
        model.BillStatus  = sltBillStatus.Value;
        model.Executor    = txtExecutorID.Value;
        model.Processor   = txtProcessorID.Value;
        EnterDateStart    = txtEnterDateStart.Value;
        EnterDateEnd      = txtEnterDateEnd.Value;
        StorageID         = ddlStorageID.SelectedValue;
        string BatchNo = txtBatchNo.Value;

        FromBillNo = txtFromBillID.Value;

        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageInProcessBus.GetStorageInProcessTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, StorageID, FromBillNo, orderBy);

        if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
                                              "生产完工入库列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatusName" },
                                              "生产完工入库列表");
        }
    }
예제 #9
0
    protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                      //排序
            string order       = "asc";                                                                                          //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            EmployeeSearchModel model = new EmployeeSearchModel();          //获取数据
            model.EmployeeNo   = txtEmployeeNo.Value.Trim();                //编号
            model.EmployeeNum  = txtEmployeeNum.Value.Trim();               //工号
            model.PYShort      = txtPYShort.Value.Trim();                   //拼音缩写
            model.EmployeeName = txtEmployeeName.Value.Trim();              //姓名
            model.ContractKind = "";                                        //request.QueryString["ContractKind"].Trim();//工种
            model.AdminLevelID = "";                                        // request.QueryString["AdminLevel"].Trim(); //行政等级
            model.QuarterID    = ddlQuarter_ddlCodeType.SelectedItem.Value; //岗位
            model.PositionID   = ddlPosition.SelectedValue;                 //职称
            string BeginDate = txtStartDate.Value.Trim();                   //入职开始时间
            string EndDate   = txtEnterEndDate.Value.Trim();

            DataTable dt = EmployeeInfoBus.ExportEmployeeWorkInfo(model, BeginDate, EndDate, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "编号", "工号", "姓名", "拼音缩写", "曾用名", "部门", "英文名", "人员分类",
                                                             "证件类型", "证件号码", "社保卡号", "应聘职务", "岗位", "职称", "岗位职等",
                                                             "所在部门", "入职时间", "性别", "出生日期", "联系电话", "手机号码", "电子邮件", "其他联系方式",
                                                             "籍贯", "婚姻状况", "学历", "毕业院校", "专业", "政治面貌", "宗教信仰",
                                                             "民族", "户口", "户口性质", "国家地区", "身高(厘米)", "体重", "视力",
                                                             "最高学位", "健康状况", "特长", "计算机水平", "参加工作时间", "家庭住址", "外语语种1",
                                                             "外语语种2", "外语语种3", "外语水平1", "外语水平2", "外语水平3",
                                                             "专业描述" },

                                              new string[] { "EmployeeNo", "EmployeeNum", "EmployeeName", "PYShort", "UsedName", "DeptName", "NameEn", "Flag",
                                                             "DocuType", "CardID", "SafeguardCard", "PositionTitle", "QuarterName", "PositionName", "AdminLevelName",
                                                             "DeptName", "EnterDate", "Sex", "Birth", "Telephone", "Mobile", "EMail", "OtherContact",
                                                             "Origin", "MarriageStatus", "CultureLevel", "GraduateSchool", "Professional", "Landscape", "Religion",
                                                             "NationalName", "Account", "AccountNature", "CountryName", "Height", "Weight", "Sight",
                                                             "Degree", "HealthStatus", "Features", "ComputerLevel", "WorkTime", "HomeAddress", "ForeignLanguage11",
                                                             "ForeignLanguage12", "ForeignLanguage13", "ForeignLanguageLevel1", "ForeignLanguageLevel2", "ForeignLanguageLevel3",
                                                             "ProfessionalDes" },

                                              "在职人员列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageOutOtherModel model = new StorageOutOtherModel();
        string OutDateStart        = string.Empty;
        string OutDateEnd          = string.Empty;
        string SendNo = string.Empty;

        model.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.OutNo      = txtOutNo.Value;
        model.Title      = txtTitle.Value;
        model.FromType   = sltFromType.Value;
        model.ReasonType = ddlReason.SelectedValue;
        model.BillStatus = sltBillStatus.Value;
        model.Transactor = txtOuterID.Value;
        OutDateStart     = txtOutDateStart.Value;
        OutDateEnd       = txtOutDateEnd.Value;

        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        string IndexValue = GetBillExAttrControl1.GetExtIndexValue;
        string TxtValue   = GetBillExAttrControl1.GetExtTxtValue;
        string BatchNo    = this.txtBatchNo.Value.ToString();
        string ProjectID  = this.HiddenProjectID.Value.ToString();

        model.ProjectID = ProjectID;

        DataTable dt = StorageOutOtherBus.GetStorageOutOtherTableBycondition(model, IndexValue, TxtValue, OutDateStart, OutDateEnd, BatchNo, orderBy);

        if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "出库单编号", "出库单主题", "源单类型", "出库人", "出库时间", "出库原因", "出库数量", "出库金额", "摘要", "单据状态" },
                                              new string[] { "OutNo", "Title", "FromTypeName", "Transactor", "OutDate", "ReasonTypeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
                                              "其他出库库列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "出库单编号", "出库单主题", "源单类型", "出库人", "出库时间", "出库原因", "出库数量", "摘要", "单据状态" },
                                              new string[] { "OutNo", "Title", "FromTypeName", "Transactor", "OutDate", "ReasonTypeName", "CountTotal", "Summary", "BillStatusName" },
                                              "其他出库库列表");
        }
    }
예제 #11
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageModel model = new StorageModel();

        model.CompanyCD   = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.StorageNo   = txtStorageNo.Value.Trim();
        model.StorageName = txtStorageName.Value.Trim();
        model.StorageType = sltType.Value;
        model.UsedStatus  = sltUsedStatus.Value;
        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageBus.GetStorageListBycondition(model, orderBy);

        foreach (DataRow dr in dt.Rows)
        {
            if (dr["StorageType"].ToString() == "0")
            {
                dr["StorageType"] = "一般库";
            }
            else if (dr["StorageType"].ToString() == "1")
            {
                dr["StorageType"] = "委托代销库";
            }
            else if (dr["StorageType"].ToString() == "2")
            {
                dr["StorageType"] = "贵重物品库";
            }

            if (dr["UsedStatus"].ToString() == "1")
            {
                dr["UsedStatus"] = "已启用";
            }
            else
            {
                dr["UsedStatus"] = "未启用";
            }
        }
        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "仓库编号", "仓库名称", "仓库类型", "仓库状态", "仓管员", "仓库说明" },
                                          new string[] { "StorageNo", "StorageName", "StorageType", "UsedStatus", "CanViewUserName", "Remark" },
                                          "仓库列表");
    }
예제 #12
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageInRedModel model = new StorageInRedModel();

        model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        string EnterDateStart = string.Empty;
        string EnterDateEnd   = string.Empty;

        model.InNo       = txtInNo.Value;
        model.Title      = txtTitle.Value;
        model.ReasonType = ddlReasonType.SelectedValue;
        if (hidFromBillID.Value == "undefined")
        {
            hidFromBillID.Value = "";
        }
        model.FromBillID = hidFromBillID.Value;
        model.DeptID     = txtDeptID.Value;
        model.BillStatus = sltBillStatus.Value;
        model.Executor   = txtExecutorID.Value;
        model.FromType   = sltFromType.Value;
        EnterDateStart   = txtEnterDateStart.Value;
        EnterDateEnd     = txtEnterDateEnd.Value;
        string BatchNo = txtBatchNo.Value;
        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageInRedBus.GetStorageInRedTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, orderBy);

        if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "源单类型", "源单编号", "入库部门", "入库人", "入库时间", "入库原因", "红冲数量", "红冲金额", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "FromType", "FromInNo", "DeptName", "ExecutorName", "EnterDate", "CodeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
                                              "红冲入库列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "源单类型", "源单编号", "入库部门", "入库人", "入库时间", "入库原因", "红冲数量", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "FromType", "FromInNo", "DeptName", "ExecutorName", "EnterDate", "CodeName", "CountTotal", "Summary", "BillStatusName" },
                                              "红冲入库列表");
        }
    }
예제 #13
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageInOtherModel model = new StorageInOtherModel();

        model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        string EnterDateStart = string.Empty;
        string EnterDateEnd   = string.Empty;

        model.InNo       = txtInNo.Value;
        model.Title      = txtTitle.Value;
        model.DeptID     = txtDeptID.Value;
        model.BillStatus = sltBillStatus.Value;
        model.Executor   = txtExecutorID.Value;
        model.Taker      = txtTakerID.Value;
        model.Checker    = txtCheckerID.Value;
        EnterDateStart   = txtEnterDateStart.Value;
        EnterDateEnd     = txtEnterDateEnd.Value;
        string StorageID = sltStorageID.SelectedValue;
        string orderBy   = txtorderBy.Value;
        string BatchNo   = txtBatchNo.Value;

        model.ProjectID = HidProjectID.Value;
        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }

        DataTable dt = StorageInOtherBus.GetStorageInOtherTableBycondition(BatchNo, model, StorageID, EnterDateStart, EnterDateEnd, orderBy);

        if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "入库金额", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
                                              "其他入库列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "Summary", "BillStatusName" },
                                              "其他入库列表");
        }
    }
예제 #14
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageInPurchaseModel model = new StorageInPurchaseModel();
        string EnterDateStart        = string.Empty;
        string EnterDateEnd          = string.Empty;
        string StorageID             = string.Empty;
        string FromBillNo            = string.Empty;

        model.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.InNo       = txtInNo.Value;
        model.Title      = txtTitle.Value;
        model.Taker      = txtTakerID.Value;
        model.Executor   = txtExecutorID.Value;
        model.Checker    = txtCheckerID.Value;
        model.DeptID     = txtDeptID.Value;
        StorageID        = ddlStorageID.SelectedValue;
        model.BillStatus = sltBillStatus.Value;
        EnterDateStart   = txtEnterDateStart.Value;
        EnterDateEnd     = txtEnterDateEnd.Value;
        FromBillNo       = txtFromBillID.Value;
        string BatchNo = txtBatchNo.Value;
        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageInPurchaseBus.GetStorageInPurchaseTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, FromBillNo, StorageID, orderBy);

        if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "入库单编号", "入库单主题", "采购到货单", "交货人", "验货人", "入库部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "ArriveNo", "Taker", "Checker", "DeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatus" },
                                              "采购入库单列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "入库单编号", "入库单主题", "采购到货单", "交货人", "验货人", "入库部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" },
                                              new string[] { "InNo", "Title", "ArriveNo", "Taker", "Checker", "DeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatus" },
                                              "采购入库单列表");
        }
    }
예제 #15
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageLossModel model = new StorageLossModel();

        model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        string LossDateStart   = string.Empty;
        string LossDateEnd     = string.Empty;
        string TotalPriceStart = string.Empty;
        string TotalPriceEnd   = string.Empty;
        string FlowStatus      = string.Empty;

        model.LossNo     = txtLossNo.Value;
        model.Title      = txtTitle.Value;
        model.DeptID     = txtDeptID.Value;
        model.StorageID  = ddlStorage.SelectedValue;
        model.Executor   = txtExecutorID.Value;
        model.ReasonType = ddlReason.SelectedValue;
        model.BillStatus = sltBillStatus.Value;
        FlowStatus       = sltFlowStatus.Value;
        LossDateStart    = txtLossDateStart.Value;
        LossDateEnd      = txtLossDateEnd.Value;
        TotalPriceStart  = txtTotalPriceStart.Value;
        TotalPriceEnd    = txtTotalPriceEnd.Value;

        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        string IndexValue = GetBillExAttrControl1.GetExtIndexValue;
        string TxtValue   = GetBillExAttrControl1.GetExtTxtValue;
        string BatchNo    = this.txtBatchNo.Value.ToString();

        DataTable dt = StorageLossBus.GetStorageLossTableBycondition(model, IndexValue, TxtValue, LossDateStart, LossDateEnd, TotalPriceStart, TotalPriceEnd, FlowStatus, BatchNo, orderBy);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "报损单编号", "报损单主题", "经办人", "报损部门", "报损仓库", "报损时间", "报损原因", "成本金额合计", "单据状态", "审批状态" },
                                          new string[] { "LossNo", "Title", "Executor", "DeptName", "StorageName", "LossDate", "ReasonTypeName", "TotalPrice", "BillStatusName", "FlowStatus" },
                                          "库存报损列表");
    }
예제 #16
0
    protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                      //排序
            string order       = "asc";                                                                                          //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            //获取数据
            TrainingAsseSearchModel searchModel = new TrainingAsseSearchModel();
            //设置查询条件
            //考核编号
            searchModel.AsseNo = txtTrainingAsseNo.Value.Trim();
            //培训编号
            searchModel.TrainingNo = txtTrainingNo.Value.Trim();
            //培训名称
            searchModel.TrainingName = txtTrainingName.Value.Trim();
            //培训方式
            searchModel.TrainingWayID = ddlTrainingWay.SelectedValue;
            //考评人
            searchModel.CheckPerson = txtCheckPerson.Value.Trim();
            //考评时间
            searchModel.AsseDate    = txtAsseDate.Value.Trim();
            searchModel.AsseEndDate = txtAsseEndDate.Value.Trim();

            //查询数据
            DataTable dt = TrainingAsseBus.SearchTrainingAsseInfo(searchModel);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "考核编号", "培训编号", "培训名称", "培训方式", "培训老师", "考评人", "考核方式", "考评时间" },
                                              new string[] { "AsseNo", "TrainingNo", "TrainingName", "TrainingWayName", "TrainingTeacher", "CheckPerson", "AsseWay", "AsseDate" },
                                              "培训考核列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #17
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                            //排序
            string order       = "asc";                                                                                                //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;



            CustComplainModel CustComplainM = new CustComplainModel();
            string            CustID        = hiddCustID.Value;                               //客户ID
            CustComplainM.ComplainType = Convert.ToInt32(ddlComplainType.SelectedItem.Value); //投诉类型
            CustComplainM.Critical     = seleCritical.Value;                                  //紧急程度
            string ComplainBegin = txtComplainBegin.Value.Trim();                             //投诉开始时间
            string ComplainEnd   = txtComplainEnd.Value.Trim();                               //结束时间
            CustComplainM.Title = txtTitle.Value.Trim();                                      //客户投诉主题
            string CustLinkMan = txtCustLinkMan.Value.Trim();                                 //客户联系人
            string DestClerk   = txtEmplNameL.Value.Trim();                                   //接待人
            CustComplainM.State     = seleState.Value;                                        //状态
            CustComplainM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();

            DataTable dt = ComplainBus.ExportComplainInfo(CanUserID, CustID, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "投诉单编号", "投诉主题", "客户名称", "投诉时间", "投诉分类", "紧急程度", "接待人", "处理状态" },
                                              new string[] { "ComplainNo", "title", "custNam", "ComplainDate", "typename", "Critical", "EmployeeName", "state" },
                                              "客户投诉列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #18
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        PurchaseRequireModel PurchaseRequireM = new PurchaseRequireModel();

        PurchaseRequireM.CompanyCD       = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        PurchaseRequireM.ProdTypeID      = txtProductTypeID.Value;
        PurchaseRequireM.ProdID          = txtProductID.Value;
        PurchaseRequireM.CreateCondition = ddlCreate.Value;
        PurchaseRequireM.RequireDate     = txtStartRequireDate.Value;
        PurchaseRequireM.EndRequireDate  = txtEndRequireDate.Value;

        string OrderBy = hidOrderBy.Value;


        DataTable dt = PurchaseRequireBus.GetPurchaseRequireInfo(PurchaseRequireM, OrderBy);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "物料需求计划单编号", "物料编码", "物料名称", "物料分类", "规格", "单位", "订单需求量", "现有存量", "需申购数量", "采购提前期", "已计划数量", "需求日期" },
                                          new string[] { "MRPNo", "ProdNo", "ProductName", "ProductTypeName", "Specification", "UnitName", "NeedCount", "HasNum", "WantingNum", "WaitingDays", "OrderCount", "RequireDate" },
                                          "采购需求列表");
    }
예제 #19
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                               //排序
            string order       = "asc";                                                                                                   //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "linkmanname"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string ord       = " ORDER BY " + orderBy + " " + order;

            LinkManModel LinkManM = new LinkManModel();
            string       CustID   = hiddCustID.Value;//客户ID
            LinkManM.LinkManName = txtLinkManName.Value.Trim();
            LinkManM.Handset     = txtHandset.Value.Trim();
            LinkManM.Important   = seleImportant.Value;
            LinkManM.LinkType    = ddlLinkType.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlLinkType.SelectedItem.Value);
            string DateBegin = txtDateBegin.Value.Trim();
            string DateEnd   = txtDateEnd.Value.Trim();
            LinkManM.WorkTel = txtWorkTel.Value.Trim();

            LinkManM.CompanyCD   = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            LinkManM.CanViewUser = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID

            DataTable dt = LinkManBus.ExportLinkManInfo(CustID, LinkManM, DateBegin, DateEnd, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "联系人姓名", "对应客户", "称谓", "联系人类型", "重要程度", "工作电话", "手机", "QQ", "生日" },
                                              new string[] { "linkmanname", "CustName", "Appellation", "TypeName", "Important", "WorkTel", "Handset", "QQ", "Birthday" },
                                              "联系人列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #20
0
    protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                      //排序
            string order       = "asc";                                                                                          //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            //获取数据
            HRProxyModel searchModel = new HRProxyModel();
            //设置查询条件
            //企业编号
            searchModel.ProxyCompanyCD = txtProxyNo.Value.Trim();
            //企业名称
            searchModel.ProxyCompanyName = txtProxyName.Value.Trim();
            //重要程度
            searchModel.Important = ddlImportant.SelectedItem.Value;
            //合作关系
            searchModel.Cooperation = ddlCooperation.SelectedItem.Value;
            //启用状态
            searchModel.UsedStatus = ddlUsedStatus.SelectedItem.Value;

            DataTable dt = HRProxyBus.SearchProxyInfo(searchModel);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "企业编号", "企业名称", "联系人", "固定电话", "移动电话", "网络通讯", "重要程度", "合作关系", "启用状态" },
                                              new string[] { "ProxyCompanyCD", "ProxyCompanyName", "ContactName", "ContactTel", "ContactMobile", "ContactWeb", "Important", "Cooperation", "UsedStatus" },
                                              "人才代理列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #21
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                             //排序
            string order       = "asc";                                                                                                 //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "BeginDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            //获取检索条件
            string           CustID       = hiddCustID.Value;                          //客户ID
            CustServiceModel CustServiceM = new CustServiceModel();
            CustServiceM.ServeType = Convert.ToInt32(ddlServeType.SelectedItem.Value); //服务类型
            CustServiceM.Fashion   = Convert.ToInt32(ddlFashion.Value);                //服务方式
            string ServiceDateBegin = txtServiceDateBegin.Value;
            string ServiceDateEnd   = txtServiceDateEnd.Value;                         //服务结束时间
            CustServiceM.Title = txtTitle.Value.Trim();                                //客户服务主题
            string Executant   = txtExecutant.Value.Trim();                            //执行人
            string CustLinkMan = txtCustLinkMan.Value.Trim();                          //客户联系人
            CustServiceM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();

            DataTable dt = ServiceBus.ExportServiceInfo(CanUserID, CustID, CustServiceM, ServiceDateBegin, ServiceDateEnd, Executant, CustLinkMan, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "服务单编号", "服务主题", "服务时间", "客户名称", "服务类型", "服务方式", "执行人", "客户联络人" },
                                              new string[] { "ServeNo", "title", "BeginDate", "custnam", "ServeType", "Fashion", "EmployeeName", "LinkManName" },
                                              "客户服务列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #22
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                               //排序
            string order       = "asc";                                                                                                   //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CreatedDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            CustTalkModel CustTalkM = new CustTalkModel();
            string        CustID    = hiddCustID.Value;

            CustTalkM.TalkType = Convert.ToInt32(ddlTalkType.Value); //类型
            CustTalkM.Priority = selePriority.Value;                 //优先级
            string TalkBegin = txtTalkBegin.Value;                   //== "" ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(context.Request.Form["TalkBegin"].ToString());//开始时间
            string TalkEnd   = txtTalkEnd.Value;                     //== "" ? Convert.ToDateTime("9999-12-31") : Convert.ToDateTime(context.Request.Form["TalkEnd"].ToString() + " 23:59:59.000");//结束时间
            CustTalkM.Title  = txtTitle.Value;                       //主题
            CustTalkM.Status = seleStatus.Value;                     //状态

            CustTalkM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();

            DataTable dt = TalkBus.ExportTalkInfo(CanUserID, CustID, CustTalkM, TalkBegin, TalkEnd, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "洽谈编号", "洽谈主题", "客户名称", "客户联系人", "优先级", "洽谈方式", "完成期限", "执行人", "状态", "创建人", "创建日期" },
                                              new string[] { "TalkNo", "title", "custnam", "linkmanname", "PriorityName", "typename", "CompleteDate", "LinkerName", "StatusName", "EmployeeName", "CreatedDate" },
                                              "客户洽谈列表信息");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
    protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                                //排序
            string order       = "asc";                                                                                                    //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            //获取数据
            EmployeeContractModel searchModel = new EmployeeContractModel();
            //设置查询条件
            //编号
            searchModel.ContractNo = txtContractNo.Text.Trim();
            //主题
            searchModel.Title = txtTitle.Text.Trim();
            //员工
            searchModel.EmployeeID = hidEmployeeID.Value;

            //查询数据
            DataTable dt = EmployeeContractBus.SearchEmployeeContractInfo(searchModel);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "合同编号", "合同名称", "员工编号", "员工姓名", "签约时间", "生效时间", "失效时间" },
                                              new string[] { "ContractNo", "Title", "EmployeeNo", "EmployeeName", "SigningDate", "StartDate", "EndDate" },
                                              "合同列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #24
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageInitailModel model = new StorageInitailModel();
        string EnterDateStart     = string.Empty;
        string EnterDateEnd       = string.Empty;

        model.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        model.InNo       = txtInNo.Value;
        model.Title      = txtTitle.Value;
        model.DeptID     = txtDeptID.Value;
        model.StorageID  = sltStorageID.SelectedValue;
        model.Executor   = txtExecutorID.Value;
        model.BillStatus = sltBillStatus.Value;
        EnterDateStart   = txtEnterDateStart.Value;
        EnterDateEnd     = txtEnterDateEnd.Value;
        string BatchNo = txtBatchNo.Value;
        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        DataTable dt = StorageInitailBus.GetStorageInitailTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, orderBy);

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "单据编号", "单据主题", "仓库", "入库部门", "入库人", "入库日期", "入库数量", "入库金额", "单据状态" },
                                          new string[] { "InNo", "Title", "StorageName", "DeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "BillStatus" },
                                          "期初库存录入列表");
    }
예제 #25
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                            //排序
            string order       = "asc";                                                                                                //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LoveDate"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            CustLoveModel CustLoveM = new CustLoveModel();
            string        CustID    = hiddCustID.Value;                           //客户ID
            CustLoveM.LoveType = Convert.ToInt32(ddlLoveType.SelectedItem.Value); //类型
            string LoveBegin   = txtLoveBegin.Value.Trim();                       //开始时间
            string LoveEnd     = txtLoveEnd.Value.Trim();                         //结束时间
            string CustLinkMan = txtCustLinkMan.Value.Trim();                     //客户联系人
            CustLoveM.Title     = txtTitle.Value.Trim();                          //主题
            CustLoveM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();

            DataTable dt = LoveBus.ExportLoveInfo(CanUserID, CustID, CustLoveM, LoveBegin, LoveEnd, CustLinkMan, ord);

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "关怀编号", "关怀主题", "客户名称", "客户联系人", "关怀时间", "关怀类型", "执行人" },
                                              new string[] { "LoveNo", "Title", "CustNam", "LinkManName", "LoveDate", "LoveType", "EmployeeName" },
                                              "客户关怀列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #26
0
    protected void imgOutput_Click(object sender, ImageClickEventArgs e)
    {
        StorageBorrow borrow = new StorageBorrow();

        borrow.BorrowNo   = string.IsNullOrEmpty(tboxBorrowNo.Value.Trim())?string.Empty:("%" + tboxBorrowNo.Value.Trim() + "%");
        borrow.Title      = string.IsNullOrEmpty(tboxTitle.Value.Trim()) ? string.Empty : ("%" + tboxTitle.Value.Trim() + "%");
        borrow.Borrower   = Convert.ToInt32(string.IsNullOrEmpty(txtBorrower.Value.Trim())?"-1":txtBorrower.Value.Trim());
        borrow.DeptID     = Convert.ToInt32(string.IsNullOrEmpty(txtBorrowDeptID.Value.Trim())?"-1":txtBorrowDeptID.Value.Trim());
        borrow.OutDeptID  = Convert.ToInt32(string.IsNullOrEmpty(txtOutDept.Value.Trim())?"-1":txtOutDept.Value.Trim());
        borrow.StorageID  = Convert.ToInt32(string.IsNullOrEmpty(ddlDepot.SelectedItem.Value)?"-1":ddlDepot.SelectedItem.Value);
        borrow.Transactor = Convert.ToInt32(string.IsNullOrEmpty(txtTransactor.Value.Trim())?"-1":txtTransactor.Value.Trim());
        borrow.BillStatus = string.IsNullOrEmpty(ddlBillStatus.SelectedItem.Value)?string.Empty:ddlBillStatus.SelectedItem.Value;
        borrow.CompanyCD  = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        DateTime start        = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowStartTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowStartTime.Text.Trim());
        DateTime end          = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowEndTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowEndTime.Text.Trim());
        int      SubmitStatus = Convert.ToInt32(string.IsNullOrEmpty(ddlSubmitStatus.SelectedItem.Value)?"-1":ddlSubmitStatus.SelectedItem.Value);
        string   orderString  = (string.IsNullOrEmpty(txtOrderBy.Value.Trim()) ? string.Empty : txtOrderBy.Value.Trim());       //排序
        string   order        = "DESC";                                                                                         //排序:升序
        string   orderBy      = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段,如果为空,默认为"ID"

        if (orderString.EndsWith("_a"))
        {
            order = "ASC";//排序:降序
        }
        //扩展属性
        string EFIndex = Request.QueryString["EFIndex"];
        string EFDesc  = Request.QueryString["EFDesc"];

        GetBillExAttrControl1.ExtIndex = EFIndex;
        GetBillExAttrControl1.ExtValue = EFDesc;
        GetBillExAttrControl1.SetExtControlValue();
        orderBy = orderBy + " " + order;

        DataTable dt = XBase.Business.Office.StorageManager.StorageBorrowBus.GetStorageList(EFIndex, EFDesc, borrow, orderBy, start, end, SubmitStatus);

        foreach (DataRow row in dt.Rows)
        {
            if (row["FlowStatus"] == null || row["FlowStatus"].ToString() == "")
            {
                row["FlowStatus"] = "";
            }
            else if (row["FlowStatus"].ToString() == "1")
            {
                row["FlowStatus"] = "待审批";
            }
            else if (row["FlowStatus"].ToString() == "2")
            {
                row["FlowStatus"] = "审批中";
            }
            else if (row["FlowStatus"].ToString() == "3")
            {
                row["FlowStatus"] = "审批通过";
            }
            else if (row["FlowStatus"].ToString() == "4")
            {
                row["FlowStatus"] = "审批不通过";
            }
            else if (row["FlowStatus"].ToString() == "5")
            {
                row["FlowStatus"] = "撤销审批";
            }
        }

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "借货单编号", "借货单主题", "借货部门", "借货人", "被借部门", "被借仓库", "借货数量", "借货金额", "出库人", "出库时间", "单据状态", "审批状态" },
                                          new string[] { "BorrowNo", "Title", "DeptID", "Borrower", "OutDeptID", "StorageID", "CountTotal", "TotalPrice", "Transactor", "OutDate", "BillStatus", "FlowStatus" },
                                          "借货单列表");
    }
예제 #27
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        int pageIndex  = 1;
        int pageCount  = 10000;
        int totalCount = 0;

        string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
        //设置查询条件
        string ddlStorage, ProductID, StartDate, EndDate, ProviderID, BatchNo = "";

        ddlStorage = Request.QueryString["SID"].Trim().ToString();
        ProductID  = Request.QueryString["PID"].Trim().ToString();
        StartDate  = Request.QueryString["SD"].Trim().ToString();
        EndDate    = Request.QueryString["ED"].Trim().ToString();
        ProviderID = Request.QueryString["ProviderID"].Trim().ToString();
        BatchNo    = Request.QueryString["BNo"].ToString();


        DataTable dt = new DataTable();

        if (string.IsNullOrEmpty(ProviderID))
        {
            string QueryStr = "  a.CompanyCD='" + CompanyCD + "' ";
            if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
            {
                QueryStr += " and a.StorageID= '";
                QueryStr += ddlStorage;
                QueryStr += "' ";
            }

            if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
            {
                QueryStr += " and a.ProductID= '";
                QueryStr += ProductID;
                QueryStr += "' ";
            }

            if (StartDate.Trim().Length > 0)
            {
                QueryStr += " and a.HappenDate >='";
                QueryStr += StartDate + " 00:00:00";
                QueryStr += "' ";
            }

            if (EndDate.Trim().Length > 0)
            {
                QueryStr += " and a.HappenDate <='";
                QueryStr += EndDate + " 23:59:59";
                QueryStr += "' ";
            }


            if (BatchNo != "0")
            {
                if (BatchNo == "未设置批次" || string.IsNullOrEmpty(BatchNo))
                {
                    QueryStr += " and ( a.BatchNo is null or a.BatchNo='') ";
                }
                else
                {
                    QueryStr += " and a.BatchNo='" + BatchNo + "' ";
                }
            }



            dt = StrongeJournalBus.GetDetailStrongJournal(QueryStr, pageIndex, pageCount, " ProductID desc ", ref totalCount);
        }
        else
        {
            string QueryStr = " and  a.CompanyCD='" + CompanyCD + "' and c.ProviderID='" + ProviderID + "' ";
            if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
            {
                QueryStr += " and e.StorageID= '";
                QueryStr += ddlStorage;
                QueryStr += "' ";
            }

            if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
            {
                QueryStr += " and e.ProductID= '";
                QueryStr += ProductID;
                QueryStr += "' ";
            }

            if (StartDate.Trim().Length > 0)
            {
                QueryStr += " and a.EnterDate >='";
                QueryStr += StartDate + " 00:00:00";
                QueryStr += "' ";
            }

            if (EndDate.Trim().Length > 0)
            {
                QueryStr += " and a.EnterDate <='";
                QueryStr += EndDate + " 23:59:59";
                QueryStr += "' ";
            }


            if (BatchNo != "0")
            {
                if (BatchNo == "未设置批次")
                {
                    QueryStr += " and ( e.BatchNo is null or e.BatchNo='') ";
                }
                else
                {
                    QueryStr += " and e.BatchNo='" + BatchNo + "' ";
                }
            }
            dt = StrongeJournalBus.GetDetailStrongJournalByPro(QueryStr, pageIndex, pageCount, " ProductID desc ", ref totalCount);
        }

        OutputToExecl.ExportToTableFormat(this, dt,
                                          new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "颜色", "尺寸", "产地", "出入库时间", "出入库数量" },
                                          new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ColorName", "ProductSize", "FromAddr", "EnterDate", "ProductCount" },
                                          "库存流水账明细");
    }
예제 #28
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        int pageIndex  = 1;
        int pageCount  = 10000;
        int totalCount = 0;



        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        string EFindex     = hiddenEFIndex.Value.Trim();
        string EFDesc      = hiddenEFDesc.Value.Trim();
        string EFName      = hiddenEFIndexName.Value;
        string extQueryStr = string.Empty;

        if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
        {
            extQueryStr = "   b.ExtField" + EFindex + " LIKE '%" + EFDesc + "%' " + "@b.ExtField" + EFindex;
        }
        string sidex = "ExtField" + EFindex;
        //设置查询条件
        string ddlStorage, txtProductNo, ProductID, StartDate, EndDate, ProviderID, ckbIsM, SourceNo = "";
        string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;

        ddlStorage = this.ddlStorage.SelectedValue;
        //txtProductName = this.txtProductName.Value;
        txtProductNo = this.txtProductNo.Value;
        ProductID    = this.hiddenProductID.Value;
        StartDate    = this.txtStartDate.Text;
        EndDate      = this.txtEndDate.Text;
        ProviderID   = this.txtProviderID.Value;
        SourceNo     = this.txtSourceNo.Text;
        if (this.ckbIsM.Checked)
        {
            ckbIsM = "1";
        }
        else
        {
            ckbIsM = "0";
        }
        string    BatchNo = this.ddlBatchNo.SelectedValue;
        string    ListID  = StorageBus.GetStorageIDStr(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID, ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD);
        DataTable dt      = new DataTable();

        if (string.IsNullOrEmpty(ProviderID))
        {
            string QueryStr = " and  CompanyCD='" + CompanyCD + "' ";
            if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
            {
                QueryStr += " and StorageID= '";
                QueryStr += ddlStorage;
                QueryStr += "' ";
            }
            if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
            {
                QueryStr += " and ProductID= '";
                QueryStr += ProductID;
                QueryStr += "' ";
            }

            if (StartDate.Trim().Length > 0)
            {
                QueryStr += " and HappenDate >='";
                QueryStr += StartDate + " 00:00:00";
                QueryStr += "' ";
            }

            if (EndDate.Trim().Length > 0)
            {
                QueryStr += " and HappenDate <='";
                QueryStr += EndDate + " 23:59:59";
                QueryStr += "' ";
            }


            if (BatchNo != "0")
            {
                if (BatchNo == "未设置批次")
                {
                    QueryStr += " and ( BatchNo is null or BatchNo='') ";
                }
                else
                {
                    QueryStr += " and BatchNo='" + BatchNo + "' ";
                }
            }



            if (SourceNo.Trim().Length > 0 && SourceNo != "0")
            {
                if (ckbIsM == "0")
                {
                    QueryStr += " and BillNo= '";
                    QueryStr += SourceNo;
                    QueryStr += "' ";
                }
                else
                {
                    QueryStr += " and BillNo like '%";
                    QueryStr += SourceNo;
                    QueryStr += "%' ";
                }
            }



            dt = StrongeJournalBus.GetSumStrongJournal(QueryStr, extQueryStr, pageIndex, pageCount, " ProductID asc ", ref totalCount);
            if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
            {
                OutputToExecl.ExportToTableFormat(this, dt,
                                                  new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", "出库总量", "现有存量", EFName },
                                                  new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "InProductCount", "OutProductCount", "NowProductCount", sidex },
                                                  "库存流水账列表");
            }
            else
            {
                OutputToExecl.ExportToTableFormat(this, dt,
                                                  new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", "出库总量", "现有存量" },
                                                  new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "InProductCount", "OutProductCount", "NowProductCount" },
                                                  "库存流水账列表");
            }
        }
        else
        {
            string QueryStr = " and  a.CompanyCD='" + CompanyCD + "' and c.ProviderID='" + ProviderID + "'  ";
            if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
            {
                QueryStr += " and b.StorageID= '";
                QueryStr += ddlStorage;
                QueryStr += "' ";
            }
            if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
            {
                QueryStr += " and b.ProductID= '";
                QueryStr += ProductID;
                QueryStr += "' ";
            }

            if (StartDate.Trim().Length > 0)
            {
                QueryStr += " and a.EnterDate >='";
                QueryStr += StartDate + " 00:00:00";
                QueryStr += "' ";
            }

            if (EndDate.Trim().Length > 0)
            {
                QueryStr += " and a.EnterDate <='";
                QueryStr += EndDate + " 23:59:59";
                QueryStr += "' ";
            }

            if (BatchNo != "0")
            {
                if (BatchNo == "未设置批次")
                {
                    QueryStr += " and ( b.BatchNo is null or b.BatchNo='') ";
                }
                else
                {
                    QueryStr += " and b.BatchNo='" + BatchNo + "' ";
                }
            }


            //查询数据
            //DataTable dt = AcountBookBus.GetAcountBookInfo(QueryStr);
            dt = StrongeJournalBus.GetStrongJournalByPro(QueryStr, extQueryStr, pageIndex, pageCount, " ProductID asc ", ref totalCount);

            if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
            {
                OutputToExecl.ExportToTableFormat(this, dt,
                                                  new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", EFName },
                                                  new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "ProductCount", sidex },
                                                  "库存流水账列表");
            }
            else
            {
                OutputToExecl.ExportToTableFormat(this, dt,
                                                  new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量" },
                                                  new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "ProductCount" },
                                                  "库存流水账列表");
            }
        }
    }
예제 #29
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            string orderString = hiddExpOrder.Value.Trim();                                                                          //排序
            string order       = "asc";                                                                                              //排序:降序
            string orderBy     = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CustNo"; //要排序的字段,如果为空,默认为"ID"

            if (orderString.EndsWith("_d"))
            {
                order = "desc";//排序:降序
            }
            string ord = " ORDER BY " + orderBy + " " + order;

            CustInfoModel CustInfoM = new CustInfoModel();

            CustInfoM.CustNo    = txtCustNo.Value.Trim();
            CustInfoM.CustNam   = txtCustNam.Value;
            CustInfoM.CustClass = hiddCustClass.Value.Trim() == "" ? 0 : Convert.ToInt32(hiddCustClass.Value.Trim());

            CustInfoM.CustName    = txtCustName.Value.Trim();
            CustInfoM.CustShort   = txtCustShort.Value.Trim();
            CustInfoM.AreaID      = ddlArea.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlArea.SelectedItem.Value);
            CustInfoM.CreditGrade = ddlCreditGrade.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlCreditGrade.SelectedItem.Value);
            CustInfoM.RelaGrade   = seleRelaGrade.Value;
            CustInfoM.UsedStatus  = seleUsedStatus.Value;
            CustInfoM.Tel         = txtTel.Value.Trim();

            string Manager      = txtManager.Value.Trim();
            string CreatedBegin = txtCreatedBegin.Value.Trim();
            string CreatedEnd   = txtCreatedEnd.Value.Trim();
            CustInfoM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
            string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID

            DataTable dt = CustInfoBus.ExportCustInfo(CustInfoM, Manager, CanUserID, CreatedBegin, CreatedEnd, ord);


            //OutputToExecl.ExportToTableFormat(this, dt,
            //    new string[] { "客户编号", "客户名称", "客户大类", "拼音缩写", "客户细分", "客户类别", "所在区域", "分管业务员", "客户优质级别", "客户关系等级", "创建人", "创建日期", "启用状态" },
            //    new string[] { "CustNo", "CustName", "CustBigName", "CustShort", "CodeName", "TypeName", "Area", "Manager", "CreditGrade", "RelaGradeName", "Creator", "CreatedDate", "UsedStatusName" },
            //    "客户档案列表");

            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "客户编号", "客户名称", "客户大类", "客户简称", "拼音缩写", "客户管理分类",
                                                             "客户营销分类", "客户优质级别", "客户时间分类", "客户细分", "客户类别", "建档人", "建档日期",
                                                             "客户简介", "国家地区", "区域", "省", "市(县)", "业务类型", "分管业务员", "联系人", "电话",
                                                             "手机", "传真", "在线咨询", "公司网址", "邮编", "电子邮件", "首次交易日期", "运送方式", "交货方式",
                                                             "联络期限(天)", "收货地址", "经营范围", "允许延期付款", "信用额度(元)", "帐期天数(天)", "结算方式",
                                                             "结算币种", "发票类型", "支付方式", "开户行", "户名", "账号", "单位性质", "资产规模(万元)",
                                                             "成立时间", "注册资本(万元)", "员工总数(个)", "法人代表", "行业", "营业执照号", "注册地址",
                                                             "税务登记号", "是否为一般纳税人", "客户来源", "年销售额(万元)", "年利润额(万元)", "销售模式",
                                                             "上级客户", "价值评估", "阶段", "热点客户", "热度", "关系等级", "启用状态", "关系描述", "备注",
                                                             "最后更新用户", "最后更新日期", "经营理念", "企业口号", "企业文化概述", "发展潜力", "存在问题",
                                                             "市场优劣势", "行业地位", "竞争对手", "合作伙伴", "发展计划", "合作方法", "可查看该客户档案的人员" },

                                              new string[] { "CustNo", "CustName", "BigType", "CustNam", "CustShort", "CustTypeManage",
                                                             "CustTypeSell", "CreditGradeNm", "CustTypeTime", "CustClassName", "CustTypaNm", "CreatorName", "CreatedDate",
                                                             "CustNote", "CountryName", "AreaName", "Province", "City", "BusiType", "ManagerName", "ContactName", "Tel",
                                                             "Mobile", "Fax", "OnLine", "WebSite", "Post", "email", "FirstBuyDate", "CarryTypeNm", "TakeTypeNm",
                                                             "LinkCycleNm", "ReceiveAddress", "SellArea", "CreditManage", "MaxCredit", "MaxCreditDate", "PayTypeNm",
                                                             "CurrencyaNm", "BillTypeNm", "MoneyTypeNm", "OpenBank", "AccountMan", "AccountNum", "CompanyType", "CapitalScale",
                                                             "SetupDate", "SetupMoney", "StaffCount", "ArtiPerson", "Trade", "BusiNumber", "SetupAddress",
                                                             "TaxCD", "IsTax", "Source", "SaleroomY", "ProfitY", "SellMode",
                                                             "CustSupe", "MeritGrade", "Phase", "HotIs", "HotHow", "RelaGrade", "UsedStatus", "Relation", "Remark",
                                                             "ModifiedUserID", "ModifiedDate", "CompanyValues", "CatchWord", "ManageValues", "Potential", "Problem",
                                                             "Advantages", "TradePosition", "Competition", "Collaborator", "ManagePlan", "Collaborate", "CanViewUserName" },

                                              "客户档案列表");
        }
        catch
        {
            ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
        }
    }
예제 #30
0
    protected void btnImport_Click(object sender, ImageClickEventArgs e)
    {
        StorageProductModel model = new StorageProductModel();

        model.CompanyCD = UserInfo.CompanyCD;
        string ProductNo   = string.Empty;
        string ProductName = string.Empty;
        string BarCode     = string.Empty;

        model.StorageID = ddlStorage.SelectedValue;
        XBase.Model.Office.SupplyChain.ProductInfoModel pdtModel = new XBase.Model.Office.SupplyChain.ProductInfoModel();
        pdtModel.ProdNo        = txtProductNo.Value;
        pdtModel.ProductName   = txtProductName.Value;
        pdtModel.BarCode       = HiddenBarCode.Value.Trim();
        pdtModel.Specification = txtSpecification.Value;
        pdtModel.Manufacturer  = txtManufacturer.Value;
        pdtModel.Material      = ddlMaterial.SelectedValue;
        pdtModel.FromAddr      = txtFromAddr.Value;
        pdtModel.ColorID       = sel_ColorID.SelectedValue;
        pdtModel.TypeID        = this.hidTypeID.Value;
        string StorageCount  = txtStorageCount.Value;
        string StorageCount1 = txtStorageCount1.Value;

        model.ProductCount = StorageCount;

        string BatchNo = this.ddlBatchNo.SelectedValue;
        string EFIndex = hiddenEFIndex.Value.Trim();
        string EFDesc  = hiddenEFDesc.Value.Trim();
        string EFName  = hiddenEFIndexName.Value.Trim();
        string sidex   = "ExtField" + EFIndex;
        //ProductNo = txtProductNo.Value;
        //ProductName = txtProductName.Value;
        // BarCode = HiddenBarCode.Value.Trim();

        string orderBy = txtorderBy.Value;

        if (!string.IsNullOrEmpty(orderBy))
        {
            if (orderBy.Split('_')[1] == "a")
            {
                orderBy = orderBy.Split('_')[0] + " asc";
            }
            else
            {
                orderBy = orderBy.Split('_')[0] + " desc";
            }
        }
        //DataTable dt = StorageSearchBus.GetProductStorageTableBycondition(model, ProductNo, ProductName, orderBy, BarCode);
        DataTable dt = StorageSearchBus.GetProductStorageTableBycondition(model, pdtModel, StorageCount1, EFIndex, EFDesc, orderBy, BatchNo);

        if (!string.IsNullOrEmpty(EFIndex) && !string.IsNullOrEmpty(EFDesc))
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "仓库编号", "仓库名称", "批次", "所属部门", "物品编号", "物品名称", "规格", "颜色", "基本单位", "基本数量", "单位", "数量", EFName },
                                              new string[] { "StorageNo", "StorageName", "BatchNo", "DeptName", "ProductNo", "ProductName", "Specification", "ColorName", "UnitID", "ProductCount", "CodeName", "StoreCount", sidex },
                                              "现有库存查询列表");
        }
        else
        {
            OutputToExecl.ExportToTableFormat(this, dt,
                                              new string[] { "仓库编号", "仓库名称", "批次", "所属部门", "物品编号", "物品名称", "规格", "颜色", "基本单位", "基本数量", "单位", "数量" },
                                              new string[] { "StorageNo", "StorageName", "BatchNo", "DeptName", "ProductNo", "ProductName", "Specification", "ColorName", "UnitID", "ProductCount", "CodeName", "StoreCount" },
                                              "现有库存查询列表");
        }
    }