//向StatInfoTable表中插入一条记录
public static void InsertIntoStatInfoTable(string name, string post, string company, string region, string source, string invoice, string telephone, string mobilephone, int number, int monthCount, int totalMoney, int averageMoney, int monthMoney, DateTime startDate, DateTime endDate, DateTime giveDate)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ImportExportDataCatalog"];
currentContainerMapping.CurrentCommandName = "InsertIntoStatInfoTable";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.NewName = name;
subscribeInfo.Post = post;
subscribeInfo.NewCompany = company;
subscribeInfo.Region = region;
subscribeInfo.Source = source;
subscribeInfo.Invoice = invoice;
subscribeInfo.Telephone = telephone;
subscribeInfo.MobilePhone = mobilephone;
subscribeInfo.Number = number;
subscribeInfo.MonthCount = monthCount;
subscribeInfo.TotalMoney = totalMoney;
subscribeInfo.AverageMoney = averageMoney;
subscribeInfo.MonthMoney = monthMoney;
subscribeInfo.StartDate = startDate;
subscribeInfo.EndDate = endDate;
subscribeInfo.GiveDate = giveDate;
spc.Execute(subscribeInfo);
}
//清空StatInfoTable表中的所有内容
public static void ClearStatInfoTable()
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ImportExportDataCatalog"];
currentContainerMapping.CurrentCommandName = "ClearStatInfoTable";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
spc.Execute(subscribeInfo);
}
//从临时表检索数据
public static DataSet RetriveDataFromTempInfo()
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "RetrieveDataFromTempInfo";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
spc.Execute(subscribeInfo);
return(subscribeInfo.ResultSet);
}
public static DataTable RetrieveAllManagers()
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ManagerCatalog"];
currentContainerMapping.CurrentCommandName = "GetManagers";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Manager manager = new Manager();
spc.Execute(manager);
return(manager.ResultSet.Tables[0]);
}
public static void DeleteEmployee(int id)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["EmployeeCatalog"];
currentContainerMapping.CurrentCommandName = "DeleteEmployee";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Employee employee = new Employee();
employee.Id = id;
spc.Execute(employee);
}
//检索所有的地区
public static DataTable RetrieveRegions()
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "GetRegions";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Region regions = new Region();
spc.Execute(regions);
return(regions.ResultSet.Tables[0]);
}
public static DataTable RetrieveAllEmployees()
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["EmployeeCatalog"];
currentContainerMapping.CurrentCommandName = "GetEmployees";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Employee employee = new Employee();
spc.Execute(employee);
return(employee.ResultSet.Tables[0]);
}
public static void DeleteManager(string id)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ManagerCatalog"];
currentContainerMapping.CurrentCommandName = "DeleteManager";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Manager manager = new Manager();
manager.Id = id;
spc.Execute(manager);
}
//删除一个地区
public static void DeleteRegion(int id)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "DeleteRegion";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Region region = new Region();
region.Id = id;
spc.Execute(region);
}
public static void UpdateManagerProperty(string id, int property)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ManagerCatalog"];
currentContainerMapping.CurrentCommandName = "UpdateManagerProperty";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Manager manager = new Manager();
manager.Id = id;
manager.Property = property;
spc.Execute(manager);
}
//删除一条订阅信息
public static void DeleteSubscribeInfo(string name, string company)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "DeleteInfo";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.OldName = name;
subscribeInfo.OldCompany = company;
spc.Execute(subscribeInfo);
}
public static void UpdateManagerName(string id, string name)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ManagerCatalog"];
currentContainerMapping.CurrentCommandName = "UpdateManagerName";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Manager manager = new Manager();
manager.Id = id;
manager.Name = name;
spc.Execute(manager);
}
//添加一个地区
public static int CreateRegion(string name)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "CreateRegion";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Region region = new Region();
region.Name = name;
spc.Execute(region);
return(region.ReturnValue);
}
//根据日期统计本月的总收入
public static DataTable RetrieveInfoByDateOnly(DateTime inputDate)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "RetrieveInfoByDateOnly";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.StartDate = inputDate;
spc.Execute(subscribeInfo);
return(subscribeInfo.ResultSet.Tables[0]);
}
public static int CreateEmployee(string name)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["EmployeeCatalog"];
currentContainerMapping.CurrentCommandName = "CreateEmployee";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Employee employee = new Employee();
employee.Name = name;
spc.Execute(employee);
return(employee.ReturnValue);
}
//将OutputTemp表中的数据导出到Excel文档中
public static void OutputDataToExcel(string path, string fileName, string tableName)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ImportExportDataCatalog"];
currentContainerMapping.CurrentCommandName = "p_exporttb";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.Path = path;
subscribeInfo.FileName = fileName;
subscribeInfo.TableName = tableName;
spc.Execute(subscribeInfo);
}
public static int ValidateManager(string id, string password)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["ManagerCatalog"];
currentContainerMapping.CurrentCommandName = "ValidateManager";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
Manager manager = new Manager();
manager.Id = id;
manager.Password = password;
spc.Execute(manager);
return(manager.ReturnValue);
}
//从主表中检查某条记录是否存在
public static int CheckSubscribeExist(string name, string company)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "CheckSubscribeExist";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.OldName = name;
subscribeInfo.OldCompany = company;
spc.Execute(subscribeInfo);
return(subscribeInfo.Id);
}
//更新一条订阅信息
public static int UpdateSubscribeInfo(string oldName, string newName, string post, string oldCompany, string newCompany, string address, string region, string postCode, string telephone, string mobilephone, DateTime startDate, DateTime endDate, DateTime giveDate, int number, int monthCount, int totalMoney, string inscribe, string source, string payment, string invoice, string client, string operator1, string bonus, string localAddress, string subscription)
{
ContainerMapping currentContainerMapping = CMPConfigurationHandler.ContainerMaps["SubscribeInfoCatalog"];
currentContainerMapping.CurrentCommandName = "UpdateInfo";
SqlPersistenceContainer spc = new SqlPersistenceContainer(currentContainerMapping);
SubscribeInfo subscribeInfo = new SubscribeInfo();
subscribeInfo.Post = post;
subscribeInfo.Address = address;
subscribeInfo.PostCode = postCode;
subscribeInfo.Telephone = telephone;
subscribeInfo.MobilePhone = mobilephone;
subscribeInfo.Inscribe = inscribe;
subscribeInfo.Source = source;
subscribeInfo.Payment = payment;
subscribeInfo.Invoice = invoice;
subscribeInfo.Client = client;
subscribeInfo.Operator = operator1;
subscribeInfo.Bonus = bonus;
subscribeInfo.Region = region;
subscribeInfo.OldName = oldName;
subscribeInfo.NewName = newName;
subscribeInfo.Number = number;
subscribeInfo.MonthCount = monthCount;
subscribeInfo.TotalMoney = totalMoney;
subscribeInfo.OldCompany = oldCompany;
subscribeInfo.NewCompany = newCompany;
subscribeInfo.StartDate = startDate;
subscribeInfo.EndDate = endDate;
subscribeInfo.GiveDate = giveDate;
subscribeInfo.LocalAddress = localAddress;
subscribeInfo.Subscription = subscription;
spc.Execute(subscribeInfo);
return(subscribeInfo.Id);
}