private string saveData()
    {
        int    year   = Int32.Parse(Request.Form["year"]);
        int    month  = Int32.Parse(Request.Form["month"]);
        float  num    = float.Parse(Request.Form["num"]);
        string type   = Request.Form["type"];
        string sector = Request.Form["sector"];

        string itemnm = "";

        if (Int32.Parse(type) == 1)
        {
            itemnm = "FixedAssetsCost";
        }
        else if (Int32.Parse(type) == 2)
        {
            itemnm = "FinancialCost";
        }
        else if (Int32.Parse(type) == 3)
        {
            itemnm = "RdCost";
        }
        else if (Int32.Parse(type) == 4)
        {
            itemnm = "HeadOfficeManageCost";
        }
        else if (Int32.Parse(type) == 5)
        {
            itemnm = "IncomeTax";
        }
        else if (Int32.Parse(type) == 6)
        {
            itemnm = "ValueAddedTax";
        }
        else if (Int32.Parse(type) == 7)
        {
            itemnm = "AdditionalTax";
        }
        else if (Int32.Parse(type) == 8)
        {
            itemnm = "StampTax";
        }

        return(ItemSettingManage.saveOrUpdateFinancialData(year, month, itemnm, num, sector));
    }
    private string getSector()
    {
        JArray    jArray = new JArray();
        DataTable dt     = ItemSettingManage.getSector();
        int       count  = dt.Rows.Count;

        if (dt == null || count == 0)
        {
            return("出错");
        }
        else
        {
            for (int i = 0; i < count; i++)
            {
                DataRow dr      = dt.Rows[i];
                JObject jObject = new JObject();
                jObject.Add("sector", dr["Sector"].ToString());

                jArray.Add(jObject);
            }
        }
        return(jArray.ToString());
    }
Beispiel #3
0
    public static string DataArchive(DataRow dataRow, int year, int month)
    {
        string feeDetail   = dataRow["feedetail"].ToString();
        string relatSector = dataRow["feearea"].ToString();
        float  money       = float.Parse(dataRow["money"].ToString());
        // 找到数据库中保存的报销项目
        string    feeAccount = "";
        DataTable dt         = getRelativeAccount(feeDetail);

        if (dt == null || dt.Rows.Count == 0)
        {
            return("");
        }
        else
        {
            feeAccount = dt.Rows[0]["feeAccount"].ToString();

            if ("开发费用金额".Equals(feeAccount))
            {
                feeAccount = "DevelopmentCost";
            }
            else if ("销售总监费用".Equals(feeAccount))
            {
                feeAccount = "SalesDirectorCost";
            }
            else if ("市场学术费".Equals(feeAccount))
            {
                feeAccount = "MarketCost";
            }
            else if ("市场调节基金".Equals(feeAccount))
            {
                feeAccount = "MarketReadjustmentCost";
            }
            else if ("区域中心费用".Equals(feeAccount))
            {
                feeAccount = "RegionalCenterCost";
            }
            else if ("区域中心费用VIP".Equals(feeAccount))
            {
                feeAccount = "RegionalCenterVipCost";
            }
            else if ("商务费用金额".Equals(feeAccount))
            {
                feeAccount = "BusinessCost";
            }
            else if ("产品发展基金".Equals(feeAccount))
            {
                feeAccount = "ProductDevelopmentFundCost";
            }
            else if ("实验费(TF)金额".Equals(feeAccount))
            {
                feeAccount = "TfCost";
            }
        }
        // 找到数据库中对应的盈利中心
        string sector = "";

        dt = getRelativeSector(relatSector);
        if (dt == null || dt.Rows.Count == 0)
        {
            return("");
        }
        else
        {
            sector = dt.Rows[0]["sector"].ToString();
        }

        DataTable oldMoneyDt = ItemSettingManage.getOldMoney(feeAccount, year, month, sector);

        float oldmoney = 0;

        if (oldMoneyDt != null && oldMoneyDt.Rows.Count != 0)
        {
            object feeAccountObj = oldMoneyDt.Rows[0][feeAccount];

            if (feeAccountObj != null)
            {
                oldmoney = float.Parse(feeAccountObj.ToString());
            }
        }

        SqlExceRes sqlRes = new SqlExceRes(ItemSettingInfoSrc.saveOrUpdateFinancialData(year, month, feeAccount, money + oldmoney, sector));

        return(sqlRes.GetResultString("提交成功!", "提交失败", "提交失败"));
    }
 private string dataArchive(DataRow dataRow, int year, int month)
 {
     return(ItemSettingManage.DataArchive(dataRow, year, month));
 }
    private string getData()
    {
        string sector = Request.Form["sector"];
        // 区分是财务部还是人事部
        //UserInfo user = (UserInfo)Session["user"];
        UserInfo user   = (UserInfo)Session["user"];
        DataSet  ds     = UserInfoSrv.GetDepartmentPostList(user);
        JArray   jArray = new JArray();

        if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows[0]["departmentId"] != null)
        {
            int departmentId = Int32.Parse(ds.Tables[0].Rows[0]["departmentId"].ToString());

            DateTime  time  = DateTime.Now;
            DataTable table = ItemSettingManage.getData(time.Year, time.Month, sector);

            // 如果是财务部
            if (departmentId == 1)
            {
                JObject jObject = new JObject();
                jObject.Add("index", 1);
                jObject.Add("item", "固定资产分摊");
                jObject = HandleEmptyJObject(jObject, "FixedAssetsCost", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 2);
                jObject.Add("item", "财务费用金额");
                jObject = HandleEmptyJObject(jObject, "FinancialCost", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 3);
                jObject.Add("item", "研发费用金额");
                jObject = HandleEmptyJObject(jObject, "RdCost", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 4);
                jObject.Add("item", "总部管理费用");
                jObject = HandleEmptyJObject(jObject, "HeadOfficeManageCost", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 5);
                jObject.Add("item", "所得税");
                jObject = HandleEmptyJObject(jObject, "IncomeTax", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 6);
                jObject.Add("item", "增值税");
                jObject = HandleEmptyJObject(jObject, "ValueAddedTax", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 7);
                jObject.Add("item", "附加税");
                jObject = HandleEmptyJObject(jObject, "AdditionalTax", table);
                jArray.Add(jObject);

                jObject = new JObject();
                jObject.Add("index", 8);
                jObject.Add("item", "印花税");
                jObject = HandleEmptyJObject(jObject, "StampTax", table);
                jArray.Add(jObject);
            }
            // 或者是人事部
            else if (departmentId == 101)
            {
                JObject jObject = new JObject();
                jObject.Add("index", 1);
                jObject.Add("item", "工资社保金额");
                jObject.Add("num", 0);
                jArray.Add(jObject);
            }
            else
            {
                return("该用户权限不足");
            }
        }
        else
        {
            return("查询数据为空");
        }

        return(jArray.ToString());
    }