private void MainForm_Load(object sender, System.EventArgs e)
{
CreateMainMenu(); //创建菜单栏
CreateToolbar(); //创建工具栏
CreateSplitter(); //创建一个分割条
SetButtonEnabled(); //设置工具栏上按钮的活动状态
SubscribeInfoManager.ClearTempInfo(); //清楚临时表中的数据
this.Text = this.Text + " 当前用户: " + this.currentManager.Name;
}
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);
}
}