Example #1
0
    public static DataTable getInfos()
    {
        DataSet   ds = SalesTaskInfoSrv.getInfos();
        DataTable dt = null;

        if (ds != null)
        {
            dt = ds.Tables[0];
        }
        return(dt);
    }
Example #2
0
    public static Dictionary <string, string> ImportInfos(Dictionary <string, string> dict)
    {
        Dictionary <string, string> fieldDict = new Dictionary <string, string>();


        fieldDict.Add("代表", "Sales");
        fieldDict.Add("主管", "Supervisor");
        fieldDict.Add("盈利中心经理", "Manager");
        fieldDict.Add("总监", "Director");
        fieldDict.Add("部门", "Department");
        fieldDict.Add("区域", "Sector");
        fieldDict.Add("医院", "Hospital");
        fieldDict.Add("产品", "Product");

        fieldDict.Add("税金", "TaxCost");
        fieldDict.Add("财务费用金额", "FinancialCost");
        fieldDict.Add("研发费用金额", "RdCost");
        fieldDict.Add("销售总监费用(0.5%)", "SalesDirectorCost");
        fieldDict.Add("开发费用金额", "DevelopmentCost");
        fieldDict.Add("总部管理费用(3.5%)", "HeadOfficeManageCost");
        fieldDict.Add("产品发展基金", "ProductDevelopmentFundCost");
        fieldDict.Add("市场学术费", "MarketCost");
        fieldDict.Add("市场调节基金", "MarketReadjustmentCost");
        fieldDict.Add("PMS/支", "PmsCost");
        fieldDict.Add("包干费6%", "GuestMaintenanceCost");
        fieldDict.Add("商务费用金额", "BusinessCost");
        fieldDict.Add("实验人员奖金金额", "ExperimenterBonusCost");
        fieldDict.Add("工资社保金额", "WageSocialSecurityCost");
        fieldDict.Add("实验费(TF)金额", "TfCost");
        fieldDict.Add("区域中心费用", "RegionalCenterCost");
        fieldDict.Add("区域中心费用VIP维护", "RegionalCenterVipCost");

        fieldDict.Add("医院供货价", "HospitalSupplyPrice");
        fieldDict.Add("公司开票价", "InvoicePrice");
        fieldDict.Add("销售折让", "SalesAllowances");
        fieldDict.Add("考核价", "ExaminePrice");
        fieldDict.Add("采购成本", "PurchasingCost");
        fieldDict.Add("毛利", "GrossProfit");

        int totalYearTask = 0;

        for (int i = 1; i <= 12; i++)
        {
            fieldDict.Add(i + "月", "MonthTask" + i);
            try
            {
                int monthTask = Convert.ToInt32(dict[i + "月"]);
                totalYearTask += monthTask;
            }
            catch { }
        }



        foreach (string key in fieldDict.Keys)
        {
            if (!dict.Keys.Contains(key))
            {
                dict["状态"] = string.Format("文件中未找到“{0}”列", key);
                return(dict);
            }
            string val = dict[key];
            if (!string.IsNullOrEmpty(val) && StringTools.IsNumeric(val) && (!fieldDict[key].Contains("Ratio")))
            {
                val = (Convert.ToDouble(val)).ToString("F2");
            }
            dict.Add(fieldDict[key], val);
        }
        dict.Add("Year", DateTime.Now.Year.ToString());
        dict.Add("YearTask", totalYearTask.ToString());

        string res = SalesTaskInfoSrv.ImportInfos(dict);

        if (!string.IsNullOrEmpty(res))
        {
            if (res.Contains("操作成功"))
            {
                dict["状态"] = "已导入";
            }
            else
            {
                dict["状态"] = res;
            }
        }
        return(dict);
    }