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;
}
}
}
