public bool Update(Model.Products products) { String sql = "update Products set ProductName='{0}',Unit='{1}',UnitPrice={2},UpdatePerson='{3}',UpdateTime='{4}',State={5} where Id='{6}'"; sql = String.Format(sql, products.ProductName, products.Unit, products.UnitPrice, products.UpdatePerson, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), products.State, products.Id); return(DataBase.Base_cmd(sql)); }
public bool Update(Model.Orders orders, OleDbTransaction tr) { String sql = "update Orders set State=0 where Id='" + orders.Id + "';"; String sql2 = "update OrdersDetail set State=0 where OrdersId='" + orders.Id + "'"; DataBase.Base_cmd(sql + sql2, tr); return(true); }
public void UpdateForJisuan(List <Agents> agentsList, OleDbTransaction tr) { foreach (Agents agents in agentsList) { String sql = @"UPDATE [dbo].[Agents] SET [Name] = '{0}' ,[Province] = '{1}' ,[City] = '{2}' ,[Village] = '{3}' ,[Birthday] = '{4}' ,[CareerStatus] = '{5}' ,[JoinDate] = '{6}' ,[Rank] = '{7}' ,[RefereeId] = '{8}' ,[RefereeName] = '{9}' ,[AgencyId] = '{10}' ,[AgencyName] = '{11}' ,[AccountBank] = '{12}' ,[AccountBankBranch] = '{13}' ,[Account] = '{14}' ,[Address] = '{15}' ,[ZipCode] = '{16}' ,[Phone] = '{17}' ,[CreateTime] = '{18}' ,[CreatePerson] = '{19}' ,[UpdateTime] = '{20}' ,[UpdatePerson] = '{21}' ,[State] = {22} ,[AgentsStatus] = {23} WHERE Id='" + agents.Id + "'"; sql = String.Format(sql, agents.Name , agents.Province , agents.City , agents.Village , agents.Birthday , agents.CareerStatus , agents.JoinDate , agents.Rank , agents.RefereeId , agents.RefereeName , agents.AgencyId , agents.AgencyName , agents.AccountBank , agents.AccountBankBranch , agents.Account , agents.Address , agents.ZipCode , agents.Phone , agents.CreateTime , agents.CreatePerson , DateTime.Now , agents.UpdatePerson , agents.State , agents.AgentsStatus); DataBase.Base_cmd(sql, tr); } }
public bool Insert(Model.Agents agents) { String sql = @"INSERT INTO [dbo].[Agents] ([Id] ,[Name] ,[Province] ,[City] ,[Village] ,[Birthday] ,[CareerStatus] ,[JoinDate] ,[Rank] ,[RefereeId] ,[RefereeName] ,[AgencyId] ,[AgencyName] ,[AccountBank] ,[AccountBankBranch] ,[Account] ,[Address] ,[ZipCode] ,[Phone] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson] ,[State],[AgentsStatus]) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}')"; sql = String.Format(sql, agents.Id , agents.Name , agents.Province , agents.City , agents.Village , agents.Birthday , agents.CareerStatus , agents.JoinDate , agents.Rank , agents.RefereeId , agents.RefereeName , agents.AgencyId , agents.AgencyName , agents.AccountBank , agents.AccountBankBranch , agents.Account , agents.Address , agents.ZipCode , agents.Phone , agents.CreateTime , agents.CreatePerson , agents.UpdateTime , agents.UpdatePerson , agents.State, agents.AgentsStatus); return(DataBase.Base_cmd(sql)); }
public bool Insert(Model.Products products) { String sql = "insert into Products ([Id],[ProductName],[Unit] ,[UnitPrice],[CreatePerson],[CreateTime],[UpdatePerson],[UpdateTime],[State]) values ("; sql += "'" + products.Id + "',"; sql += "'" + products.ProductName + "',"; sql += "'" + products.Unit + "',"; sql += "" + products.UnitPrice + ","; sql += "'" + products.CreatePerson + "',"; sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; sql += "'" + products.UpdatePerson + "',"; sql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',"; sql += products.State + ")"; return(DataBase.Base_cmd(sql)); }
public void Insert(Model.LogMonthCreate logMonthCreate) { String sql = @"INSERT INTO [dbo].[LogMonthCreate] ([Id] ,[YearMonth] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson] ,[State]) VALUES ('{0}' ,'{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,{6})"; sql = String.Format(sql, logMonthCreate.Id, logMonthCreate.YearMonth, logMonthCreate.CreateTime, logMonthCreate.CreatePerson, logMonthCreate.UpdateTime, logMonthCreate.UpdatePerson, logMonthCreate.State); DataBase.Base_cmd(sql); }
public bool Insert(Model.OrdersDetail ordersdetail) { if (!String.IsNullOrWhiteSpace(ordersdetail.CreatePerson)) { String sql = @"INSERT INTO [dbo].[OrdersDetail] ([Id] ,[OrdersId] ,[ProductId] ,[ProductName] ,[UnitPrice] ,[Num] ,[Price] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson],[State]) VALUES ('{0}','{1}','{2}','{3}',{4},{5},{6},'{7}','{8}','{9}','{10}',{11} );"; sql = String.Format(sql, ordersdetail.Id, ordersdetail.OrdersId, ordersdetail.ProductId, ordersdetail.ProductName, ordersdetail.UnitPrice, ordersdetail.Num, ordersdetail.Price, ordersdetail.CreateTime, ordersdetail.CreatePerson, ordersdetail.UpdateTime, ordersdetail.UpdatePerson, ordersdetail.State); return(DataBase.Base_cmd(sql)); } return(false); }
public bool Update(Model.Agents agents) { String sql = @"UPDATE [dbo].[Agents] SET [Name] = '{0}' ,[Province] = '{1}' ,[City] = '{2}' ,[Birthday] = '{3}' ,[JoinDate] = '{4}' ,[RefereeId] = '{5}' ,[RefereeName] = '{6}' ,[AccountBank] = '{7}' ,[AccountBankBranch] = '{8}' ,[Account] = '{9}' ,[Address] = '{10}' ,[ZipCode] = '{11}' ,[Phone] = '{12}' ,[UpdateTime] = '{13}' ,[UpdatePerson] = '{14}' WHERE Id='{15}'"; sql = String.Format(sql, agents.Name , agents.Province , agents.City , agents.Birthday , agents.JoinDate , agents.RefereeId , agents.RefereeName , agents.AccountBank , agents.AccountBankBranch , agents.Account , agents.Address , agents.ZipCode , agents.Phone , agents.UpdateTime , agents.UpdatePerson, agents.Id); return(DataBase.Base_cmd(sql)); }
public void InsertOrUpdateIncome(OleDbTransaction tr, Model.Income income, bool isInsert) { if (isInsert) { String sql = @"INSERT INTO [dbo].[Income] ([YearMonth] ,[AgentId] ,[AgentName] ,[CareerStatus] ,[Rank] ,[RefereeId] ,[RefereeName] ,[AgencyId] ,[AgencyName] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson] ,[State] ,[AllMonthMoney] ,[LastMonthMoney] ,[NearlyThreeMonthsMoney] ,[NearlySixMonthsMoney] ,[SalesMoney] ,[SalesServiceMoney] ,[PersonalMoney] ,[PersonalServiceMoney] ,[MarketMoney] ,[MarketServiceMoney] ,[OneMoney] ,[TwoMoney] ,[ThreeMoney] ,[RegionServiceMoney] ,[RegionYum] ,[RegionServiceYum] ,[IncomeMoney],[AllSalesMoney]) VALUES ({0} ,'{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}' ,'{11}','{12}',{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29},{30},{31});"; sql = String.Format(sql, income.YearMonth , income.AgentId , income.AgentName , income.CareerStatus , income.Rank , income.RefereeId , income.RefereeName , income.AgencyId , income.AgencyName , income.CreateTime , income.CreatePerson , income.UpdateTime , income.UpdatePerson , income.State , income.AllMonthMoney , income.LastMonthMoney , income.NearlyThreeMonthsMoney , income.NearlySixMonthsMoney , income.SalesMoney , income.SalesServiceMoney , income.PersonalMoney , income.PersonalServiceMoney , income.MarketMoney , income.MarketServiceMoney , income.OneMoney , income.TwoMoney , income.ThreeMoney , income.RegionServiceMoney , income.RegionYum , income.RegionServiceYum , income.IncomeMoney, income.AllSalesMoney); DataBase.Base_cmd(sql, tr); } else { String sql = @"UPDATE [dbo].[Income] SET [AgentName] = '{0}' ,[CareerStatus] = '{1}' ,[Rank] = '{2}' ,[RefereeId] = '{3}' ,[RefereeName] = '{4}' ,[AgencyId] = '{5}' ,[AgencyName] = '{6}' ,[CreateTime] = '{7}' ,[CreatePerson] = '{8}' ,[UpdateTime] = '{9}' ,[UpdatePerson] = '{10}' ,[State] = {11} ,[AllMonthMoney] = {12} ,[LastMonthMoney] = {13} ,[NearlyThreeMonthsMoney] = {14} ,[NearlySixMonthsMoney] = {15} ,[SalesMoney] = {16} ,[SalesServiceMoney] = {17} ,[PersonalMoney] = {18} ,[PersonalServiceMoney] = {19} ,[MarketMoney] = {20} ,[MarketServiceMoney] = {21} ,[OneMoney] = {22} ,[TwoMoney] = {23} ,[ThreeMoney] = {24} ,[RegionServiceMoney] = {25} ,[RegionYum] = {26} ,[RegionServiceYum] = {27} ,[IncomeMoney] = {28} ,[AllSalesMoney]={29} WHERE YearMonth=" + income.YearMonth + " and AgentId='" + income.AgentId + "'"; sql = String.Format(sql, income.AgentName , income.CareerStatus , income.Rank , income.RefereeId , income.RefereeName , income.AgencyId , income.AgencyName , income.CreateTime , income.CreatePerson , income.UpdateTime , income.UpdatePerson , income.State , income.AllMonthMoney , income.LastMonthMoney , income.NearlyThreeMonthsMoney , income.NearlySixMonthsMoney , income.SalesMoney , income.SalesServiceMoney , income.PersonalMoney , income.PersonalServiceMoney , income.MarketMoney , income.MarketServiceMoney , income.OneMoney , income.TwoMoney , income.ThreeMoney , income.RegionServiceMoney , income.RegionYum , income.RegionServiceYum , income.IncomeMoney, income.AllSalesMoney); DataBase.Base_cmd(sql, tr); } }
public void UpdateState(String id) { String sql = "update [dbo].[LogMonthCreate] set State=1 where Id='" + id + "'"; DataBase.Base_cmd(sql); }
public bool UpdateAgents(Model.Agents agents) { String sql = "update [dbo].[Agents] set Rank='" + agents.Rank + "',CareerStatus='" + agents.CareerStatus + "',State='" + agents.State + "' where Id='" + agents.Id + "'"; return(DataBase.Base_cmd(sql)); }
public bool Delete(String id) { String sql = "delete [dbo].[OrdersDetail] where Id='" + id + "'"; return(DataBase.Base_cmd(sql)); }