예제 #1
0
        private void MainForm_Load(object sender, System.EventArgs e)
        {
            CreateMainMenu();                     //创建菜单栏

            CreateToolbar();                      //创建工具栏

            CreateSplitter();                     //创建一个分割条

            SetButtonEnabled();                   //设置工具栏上按钮的活动状态

            SubscribeInfoManager.ClearTempInfo(); //清楚临时表中的数据

            this.Text = this.Text + "     当前用户:  " + this.currentManager.Name;
        }
예제 #2
0
        void ImportDataToDatabase(DataTable sourceTable)
        {
            SubscribeInfoManager.ClearTempInfo();

            foreach (DataRow row in sourceTable.Rows)
            {
                DateTime startDate = DateTime.Parse("1900-1-1");
                DateTime endDate   = DateTime.Parse("1900-1-1");
                DateTime giveDate  = DateTime.Parse("1900-1-1");

                int    number     = -1;
                int    monthCount = -1;
                int    totalMoney = -1;
                string name;
                string localAddress;
                string company;
                string subscription;
                string post;
                string region;
                string address;
                string postcode;
                string mobilePhone;
                string telephone;
                string inscribe;
                string source;
                string payment;
                string invoice;
                string client;
                string operator1;
                string bonus;

                if (row["起始日期"] != DBNull.Value)
                {
                    startDate = DateTime.Parse(row["起始日期"].ToString().Trim());                    //注意:这里一定能够转换,因为如果格式不正确则它的值必定为DBNull.Value
                }
                if (row["结束日期"] != DBNull.Value)
                {
                    endDate = DateTime.Parse(row["结束日期"].ToString().Trim());                    //同上
                }
                if (row["付款日期"] != DBNull.Value)
                {
                    giveDate = DateTime.Parse(row["付款日期"].ToString().Trim());                    //同上
                }
                if (row["份数"] != DBNull.Value)
                {
                    number = Int32.Parse(row["份数"].ToString());                    //同上
                }
                if (row["期数"] != DBNull.Value)
                {
                    monthCount = Int32.Parse(row["期数"].ToString());                    //同上
                }
                if (row["金额"] != DBNull.Value)
                {
                    totalMoney = Int32.Parse(row["金额"].ToString());                    //同上
                }

                name         = row["姓名"].ToString().Trim() == String.Empty ? "  " : row["姓名"].ToString().Trim();
                localAddress = row["县级地区"].ToString().Trim() == String.Empty ? "  " : row["县级地区"].ToString().Trim();
                region       = row["地区"].ToString().Trim() == String.Empty ? "  " : row["地区"].ToString().Trim();
                company      = row["公司"].ToString().Trim() == String.Empty ? "  " : row["公司"].ToString().Trim();
                subscription = row["订阅形式"].ToString().Trim() == String.Empty ? "  " : row["订阅形式"].ToString().Trim();
                post         = row["职位"].ToString().Trim() == String.Empty ? "  " : row["职位"].ToString().Trim();
                address      = row["地址"].ToString().Trim() == String.Empty ? "  " : row["地址"].ToString().Trim();
                postcode     = row["邮编"].ToString().Trim() == String.Empty ? "  " : row["邮编"].ToString().Trim();
                mobilePhone  = row["手机"].ToString().Trim() == String.Empty ? "  " : row["手机"].ToString().Trim();
                telephone    = row["电话"].ToString().Trim() == String.Empty ? "  " : row["电话"].ToString().Trim();
                inscribe     = row["落款"].ToString().Trim() == String.Empty ? "  " : row["落款"].ToString().Trim();
                source       = row["来源"].ToString().Trim() == String.Empty ? "  " : row["来源"].ToString().Trim();
                payment      = row["支付方式"].ToString().Trim() == String.Empty ? "  " : row["支付方式"].ToString().Trim();
                invoice      = row["发票号"].ToString().Trim() == String.Empty ? "  " : row["发票号"].ToString().Trim();
                client       = row["客户类别"].ToString().Trim() == String.Empty ? "  " : row["客户类别"].ToString().Trim();
                operator1    = row["业务员"].ToString().Trim() == String.Empty ? "  " : row["业务员"].ToString().Trim();
                bonus        = row["奖金提取"].ToString().Trim() == String.Empty ? "  " : row["奖金提取"].ToString().Trim();

                SubscribeInfoManager.CreateSubscribeInfo(name, post, company, address, region, postcode, telephone, mobilePhone, startDate, endDate, giveDate, number, monthCount, totalMoney, inscribe, source, payment, invoice, client, operator1, bonus, localAddress, subscription);
            }
        }