protected override void On_ActionEdit(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtDirName.Value.Trim( ))) { lblMessage.InnerHtml = "请输入分类名称"; return; } SysTakeawayDirectory dir = SysTakeawayDirectory.FetchByID(DirId); if (dir == null) { if (string.IsNullOrEmpty(txtCompanyTel.Value)) { lblMessage.InnerHtml = "请输入商家账号."; return; } var company = CompanyBLL.GetCompanyByTel(txtCompanyTel.Value); if (company == null) { lblMessage.InnerHtml = "你输入的商家账号不存在."; return; } dir = new SysTakeawayDirectory( ); dir.CompanyID = company.Id; } dir.DirName = txtDirName.Value.Trim( ); dir.Save( ); lblMessage.InnerHtml = "保存成功"; if (DirId <= 0) txtDirName.Value = string.Empty; }
public void Insert(string DirName,int? CompanyID,bool? IsDelete) { SysTakeawayDirectory item = new SysTakeawayDirectory(); item.DirName = DirName; item.CompanyID = CompanyID; item.IsDelete = IsDelete; item.Save(UserName); }
public void Update(int Id,string DirName,int? CompanyID,bool? IsDelete) { SysTakeawayDirectory item = new SysTakeawayDirectory(); item.MarkOld(); item.IsLoaded = true; item.Id = Id; item.DirName = DirName; item.CompanyID = CompanyID; item.IsDelete = IsDelete; item.Save(UserName); }
private static int GetMenuDirByName(int companyId, string dirName) { var companyMenuDirId = CompanyMenuDirId.GetCompanyMenuDirId(companyId, dirName); if (MenuDirMapping.ContainsKey(companyMenuDirId)) return MenuDirMapping[companyMenuDirId]; SysTakeawayDirectory dir = DB.Select( ).From<SysTakeawayDirectory>( ) .Where(SysTakeawayDirectory.DirNameColumn).IsEqualTo(dirName) .And(SysTakeawayDirectory.CompanyIDColumn).IsEqualTo(companyId) .ExecuteSingle<SysTakeawayDirectory>( ); if (dir == null) { dir = new SysTakeawayDirectory( ); dir.DirName = dirName; dir.CompanyID = companyId; dir.IsDelete = false; dir.Save( ); } else if (dir.IsDelete.HasValue && dir.IsDelete.Value) { dir.IsDelete = false; dir.Save(); } MenuDirMapping.Add(companyMenuDirId, dir.Id); return dir.Id; }
public static IEnumerable<SysTakeawayDirectory> LoadMenuDirectory(int companyID) { var query = DB.Select( ).From<SysTakeawayDirectory>( ) .Where(SysTakeawayDirectory.CompanyIDColumn).IsEqualTo(companyID); using (var dr = query.ExecuteReader( )) { while (dr.Read( )) { SysTakeawayDirectory dir = new SysTakeawayDirectory( ); dir.Load(dr); yield return dir; } } }
public static IEnumerable<SysTakeawayDirectory> LoadMenuDirectory( ) { using (var dr = SysTakeawayDirectory.FetchAll( )) { while (dr.Read( )) { SysTakeawayDirectory dir = new SysTakeawayDirectory( ); dir.Load(dr); yield return dir; } } }