private static void ExprotPayHistroy() { SqlConnection conn = new SqlConnection("Server=.;Initial Catalog=E_Commerce_DB;User ID=sa;Password=dq123456"); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append(@"select * from Test003 "); conn.Open(); SqlCommand comm = new SqlCommand(sqlstr.ToString(), conn); SqlDataReader sdr = comm.ExecuteReader(); contractEntity list = new contractEntity(); List <contractEntity> conlists = new List <contractEntity>(); while (sdr.Read()) { list = new contractEntity { projectname = sdr[0].ToString(), ecommercename = sdr[1].ToString(), ecommercegroupname = sdr[2].ToString(), platfromrate = Convert.ToDecimal(sdr[3]), contractname = sdr[4].ToString(), ControllerAmount = Convert.ToDecimal(sdr[5]), FlowAmount = Convert.ToDecimal(sdr[6]), ActualControllerAmount = Convert.ToDecimal(sdr[7]) }; conlists.Add(list); if (!sdr.HasRows) { list = new contractEntity { projectname = "", }; conlists.Add(list); } } sdr.Close(); conn.Close(); }
private static void ExprotContract() { SqlConnection conn = new SqlConnection("Server=.;Initial Catalog=E_Commerce_DB;User ID=sa;Password=dq123456"); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append(@"select * from Test003 "); conn.Open(); SqlCommand comm = new SqlCommand(sqlstr.ToString(), conn); SqlDataReader sdr = comm.ExecuteReader(); contractEntity list = new contractEntity(); List <contractEntity> conlists = new List <contractEntity>(); while (sdr.Read()) { list = new contractEntity { projectname = sdr[0].ToString(), ecommercename = sdr[1].ToString(), ecommercegroupname = sdr[2].ToString(), platfromrate = Convert.ToDecimal(sdr[3]), contractname = sdr[4].ToString(), ControllerAmount = Convert.ToDecimal(sdr[5]), FlowAmount = Convert.ToDecimal(sdr[6]), ActualControllerAmount = Convert.ToDecimal(sdr[7]) }; conlists.Add(list); if (!sdr.HasRows) { list = new contractEntity { projectname = "", }; conlists.Add(list); } } sdr.Close(); conn.Close(); Base_ProjectInfoBLL bpbbll = new Base_ProjectInfoBLL(); EcommerceBLL ecombll = new EcommerceBLL(); EcommerceGroupBLL ecomgroupbll = new EcommerceGroupBLL(); List <EcommerceGroupEntity> ecomgrouplists = new List <EcommerceGroupEntity>(); List <EcommerceEntity> ecomlists = new List <EcommerceEntity>(); List <EcommerceProjectRelationEntity> ecomprorelists = new List <EcommerceProjectRelationEntity>(); int count = 0; foreach (var item in conlists) { count++; var data = bpbbll.GetList("").ToList().Where(t => t.ProjecName == item.projectname).ToList(); if (data.Count == 0) { Console.WriteLine("找不到对应的项目数据'" + item.projectname + "'"); Console.ReadKey(); return; } EcommerceProjectRelationEntity ecom = new EcommerceProjectRelationEntity(); ecom.EcommerceProjectRelationID = Guid.NewGuid().ToString(); var ecomgroupdata = ecomgroupbll.GetList("").Where(t => t.EcommerceGroupName == item.ecommercegroupname).ToList(); if (ecomgroupdata.Count == 0) { EcommerceGroupEntity ecomgroupentity = new EcommerceGroupEntity(); ecomgroupentity.EcommerceGroupID = Guid.NewGuid().ToString(); ecomgroupentity.EcommerceGroupName = item.ecommercegroupname; ecomgroupentity.DeleteMark = 0; var t2 = new SqlDatabase("BaseDb").Connection.Insertable(ecomgroupentity).ExecuteCommand(); //if (!ecomgrouplists.Any(t => t.EcommerceGroupName == ecomgroupentity.EcommerceGroupName)) //{ // ecomgrouplists.Add(ecomgroupentity); //} EcommerceEntity ecomentity = new EcommerceEntity(); ecomentity.EcommerceName = item.ecommercename; ecomentity.EcommerceID = Guid.NewGuid().ToString(); ecomentity.EcommerceGroupID = ecomgroupentity.EcommerceGroupID; ecomentity.EcommerceCode = count.ToString(); ecomentity.EcommerceGroupName = ecomgroupentity.EcommerceGroupName; ecomentity.DeleteMark = 0; ecomentity.EcommerceType = 0; ecomentity.PlatformRate = item.platfromrate; ecomentity.CooperateStartTime = Convert.ToDateTime("2018-01-01"); ecomentity.CooperateEndTime = Convert.ToDateTime("2018-06-30"); var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomentity).ExecuteCommand(); //if (!ecomlists.Any(t => t.EcommerceName == ecomentity.EcommerceName)) //{ // ecomlists.Add(ecomentity); //} ecom.EcommerceGroupID = ecomgroupentity.EcommerceGroupID; ecom.EcommerceGroupName = ecomgroupentity.EcommerceGroupName; ecom.EcommerceID = ecomentity.EcommerceID; ecom.EcommerceName = ecomentity.EcommerceName; ecom.EcommerceCode = ecomentity.EcommerceCode; ecom.PartyB = ecomentity.EcommerceName; } else { ecom.EcommerceGroupID = ecomgroupdata[0].EcommerceGroupID; ecom.EcommerceGroupName = ecomgroupdata[0].EcommerceGroupName; var ecomdata = ecombll.GetList("").Where(t => t.EcommerceName == item.ecommercename).ToList(); if (ecomdata.Count == 0) { EcommerceEntity ecomentity = new EcommerceEntity(); ecomentity.EcommerceName = item.ecommercename; ecomentity.EcommerceID = Guid.NewGuid().ToString(); ecomentity.EcommerceCode = count.ToString(); ecomentity.EcommerceGroupID = ecomgroupdata[0].EcommerceGroupID; ecomentity.EcommerceGroupName = ecomgroupdata[0].EcommerceGroupName; ecomentity.PlatformRate = item.platfromrate; ecomentity.DeleteMark = 0; ecomentity.EcommerceType = 0; ecomentity.CooperateStartTime = Convert.ToDateTime("2018-01-01"); ecomentity.CooperateEndTime = Convert.ToDateTime("2018-06-30"); var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomentity).ExecuteCommand(); //if (!ecomlists.Any(t => t.EcommerceName == ecomentity.EcommerceName)) //{ // ecomlists.Add(ecomentity); //} ecom.EcommerceGroupID = ecomentity.EcommerceGroupID; ecom.EcommerceGroupName = ecomentity.EcommerceGroupName; ecom.EcommerceID = ecomentity.EcommerceID; ecom.EcommerceName = ecomentity.EcommerceName; ecomentity.EcommerceCode = ecomentity.EcommerceCode; ecom.PartyB = ecomentity.EcommerceName; } else { ecom.EcommerceID = ecomdata[0].EcommerceID; ecom.EcommerceName = ecomdata[0].EcommerceName; ecom.EcommerceCode = ecomdata[0].EcommerceCode; ecom.PartyB = ecomdata[0].EcommerceName; } } ecom.PlatformRate = item.platfromrate; ecom.ContractName = item.contractname; ecom.EcommerceType = 0; ecom.EcommerceTypeName = EnumHelper.ToDescription((EcommerceTypeEnum)0); ecom.Agent = "金涛"; ecom.CooperateStartTime = Convert.ToDateTime("2018-01-01"); ecom.CooperateEndTime = Convert.ToDateTime("2018-06-30"); ecom.ForceContractAmount = 100000; ecom.DeleteMark = 0; ecom.CityCode = data[0].CityCode; ecom.CityID = data[0].CityID; ecom.CityName = data[0].CityName; ecom.ProjectID = data[0].ProjectID; ecom.ProjectCode = data[0].ProjectCode; ecom.ProjecName = item.projectname; ecom.CompanyId = data[0].CompanyCode; ecom.CompanyCode = data[0].CompanyCode; ecom.CompanyName = data[0].CompanyName; ecom.ProjectType = 0; ecom.ApprovalState = 4; ecom.FlowNopayTotalAmount = 0; ecom.ContractNature = 0; ecom.IsStandard = 1; ecom.PartyA = "阳光城集团股份有限公司"; ecom.BiddingMethod = 0; ecom.IsStamp = 1; ecom.ContractTypeName = "主合同"; ecom.CreateDate = Convert.ToDateTime("2018-06-30"); ecom.ControlTotalAmount = item.ControllerAmount * 0; ecom.FlowNopayTotalAmount = item.FlowAmount * 10000; ecom.ActualControlTotalAmount = item.ActualControllerAmount * 10000; ecom.IsTrunk = 1; if (!ecomprorelists.Any(t => t.EcommerceID == ecom.EcommerceID && t.ProjectID == ecom.ProjectID)) { ecomprorelists.Add(ecom); } } var t1 = new SqlDatabase("BaseDb").Connection.Insertable(ecomprorelists).ExecuteCommand(); //var t2 = new SqlDatabase("BaseDb").Connection.Insertable(ecomgrouplists).ExecuteCommand(); //var t3 = new SqlDatabase("BaseDb").Connection.Insertable(ecomlists).ExecuteCommand(); Console.ReadKey(); }