/// <summary>Implements <see cref="ISys_FunctionRespository.Find"/></summary>
public Sys_Function Find(Int32 id)
{
String stmtId = "Sys_Function.Find";
Sys_Function result = SqlMapper.QueryForObject <Sys_Function>(stmtId, id);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
Sys_FunctionRepository repository = new Sys_FunctionRepository();
if (Attributes["param"] != null)
{
string URL = Attributes["param"];
id = Util.GetParam(URL, "id");
if (string.IsNullOrEmpty(id))
{
id = "0";
}
if (id != "0")
{
Sys_Function entity = repository.GetById(int.Parse(id));
txtName.Text = entity.TenChucNang;
txtMa.Text = entity.Ma;
txtIcon.Text = entity.Icon;
txtHref.Text = entity.Href;
txtOrder.Text = entity.ThuTu != null?entity.ThuTu.ToString() : "0";
try
{
txtParent.Text = new xRPDataContext().Sys_Functions.FirstOrDefault(x => x.ID == entity.ParentID).TenChucNang;
}
catch
{
txtParent.Text = "";
}
hdfParentID.Value = entity.ParentID != null?entity.ParentID.Value.ToString() : "0";
}
}
}
/// <summary>Implements <see cref="ISys_FunctionService.Insert"/></summary>
public void Insert(Sys_Function obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
_repository.Insert(obj);
}
/// <summary>Implements <see cref="ISys_FunctionService.Delete"/></summary>
public void Delete(Sys_Function obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
_repository.Delete(obj);
}
/// <summary>Implements <see cref="ISys_FunctionRespository.Delete"/></summary>
public void Delete(Sys_Function obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
String stmtId = "Sys_Function.Delete";
SqlMapper.Delete(stmtId, obj);
}
/// <summary>Implements <see cref="ISys_FunctionRespository.Insert"/></summary>
public void Insert(Sys_Function obj)
{
if (obj == null)
{
throw new ArgumentNullException("obj");
}
String stmtId = "Sys_Function.Insert";
SqlMapper.Insert(stmtId, obj);
}
public static string AddOrUpdateFunctionItem(string id, string ma, string name, string parentID, string href, string icon, string thutu)
{
AjaxResponse response = new AjaxResponse();
xRPDataContext dts = new xRPDataContext();
var user = (from u in dts.aspnet_Users where u.UserName == HttpContext.Current.User.Identity.Name select u).FirstOrDefault();
try
{
string message = string.Empty;
int groupdID = 0;
string role = string.Empty;
bool isExistName = false;//
Sys_FunctionRepository repository = new Sys_FunctionRepository();
//response.IsSuccess = true;
//response.Message = "Cập nhật thành công";
Sys_Function entity = new Sys_Function();
if (id != "")
{
entity = repository.GetById(int.Parse(id));
}
else
{
entity.NgayTao = DateTime.Now;
entity.MaNguoiTao = user.UserId;
}
entity.NgayThayDoi = DateTime.Now;
entity.MaNguoiThayDoi = user.UserId;
entity.Ma = ma;
entity.TenChucNang = name;
entity.ParentID = int.Parse(parentID);
entity.Href = href;
entity.Icon = icon;
entity.Position = 1;
entity.PhanHeID = 1;
entity.ThuTu = int.Parse(thutu);
if (id == "0")
{
repository.InsertOnSubmit(entity);
}
repository.SubmitChanges();
response.IsSuccess = true;
response.Message = "Cập nhật thành công";
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = (ex.Message + ex.StackTrace).EncodeJsString();
}
return(JsonConvert.SerializeObject(response));
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Update(Sys_Function model)
{
bool result = false;
var e = new ModelExceptions();
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
return(result);
}
private void FindRoleChild(Sys_Function model, List <Sys_Function> all, ref List <Sys_Function> ResultList)
{
var child = all.Where(o => o.Fun_PCode == model.Fun_Code);
if (child.Count() == 0)
{
return;
}
foreach (var item in child)
{
ResultList.Add(item);
FindRoleChild(item, all, ref ResultList);
}
}
private void GenerateChild(Sys_Function dict, List <Sys_Function> allData)
{
dict.Childrens = allData.Where(o => o.Fun_PCode == dict.Fun_Code).ToList();
if (dict.Childrens.Count == 0)
{
return;
}
foreach (var d in dict.Childrens)
{
GenerateChild(d, allData);
}
}
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Function GetModel(string strCondition)
{
List <Sys_Function> list = instance.GetListByWhere(strCondition);
Sys_Function model = new Sys_Function();
if (list != null && list.Count > 0)
{
model = list[0];
}
else
{
model = null;
}
return(model);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <param name='model'>是否完成验证</param>
/// <returns>bool</returns>
public bool Insert(Sys_Function model, bool IsValid)
{
var e = new ModelExceptions();
bool result = false;
if (e.IsValid && IsValid)
{
//完成了验证，开始更新数据库了
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 逻辑删除数据
/// </summary>
/// <param name='model'>model</param>
/// <returns>bool</returns>
public bool Delete(string Condition)
{
bool result = false;
List <Sys_Function> list = instance.GetListByWhere(Condition);
if (list.Count > 0)
{
Sys_Function model = list[0];
model.Stat = 1;
int _rseult = instance.Update(model);
if (_rseult > 0)
{
result = true;
}
}
return(result);
}
protected List <Sys_Function> GetListChildFunction(Guid roleID, Sys_Function function, List <Sys_Function> list, int POSITION)
{
List <Sys_Function> listChildFunction = new List <Sys_Function>();
listChildFunction = functionRepository.GetFunctionBy2(roleID, PHANHE, function.ID).OrderBy(x => x.ThuTu).ToList();
if (listChildFunction.Count > 0)
{
list.Add(function);
foreach (Sys_Function child in listChildFunction)
{
GetListChildFunction(roleID, child, list, POSITION);
}
}
else
{
list.Add(function);
}
return(list);
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name='model'>实体</param>
/// <returns>bool</returns>
public bool Insert(Sys_Function model)
{
bool result = false;
try
{
int _result = instance.Add(model);
if (_result > 0)
{
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public void SynFunction(Bse_Area area)
{
var model = fInstance.GetListByWhere(string.Format("AND Fun_Code='{0}' AND Fun_PCode='{1}'", area.Area_Code, area.Area_PCode)).FirstOrDefault();
if (model == null)
{
Sys_Function fun = new Sys_Function();
fun.Fun_Code = area.Area_Code;
fun.Fun_Name = area.Area_Name;
fun.Fun_PCode = area.Area_PCode;
fun.Fun_PName = area.Area_PName;
fun.Fun_iType = "Area";
fInstance.Add(fun);
}
else
{
model.Fun_Name = area.Area_Name;
fInstance.Update(model);
}
}
/// <summary>
/// 权限点同步
/// </summary>
public void SynFunction(Bse_Station station)
{
var model = fInstance.GetListByWhere(string.Format("AND Fun_Code='{0}' AND Fun_PCode='{1}'", station.SN_Code, station.SN_AreaCode)).FirstOrDefault();
if (model == null)
{
Sys_Function function = new Sys_Function();
function.Fun_Code = station.SN_Code;
function.Fun_Name = station.SN_Name;
function.Fun_PCode = station.SN_AreaCode;
function.Fun_PName = station.SN_AreaName;
function.Fun_iType = "Station";
fInstance.Add(function);
}
else
{
model.Fun_Name = station.SN_Name;
fInstance.Update(model);
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string Save(Sys_Function model)
{
db.Commit(() =>
{
if (model.Function_ID.ToGuid() == Guid.Empty)
{
model.Function_ID = db.Insert(model).ToGuid();
if (model.Function_ID.ToGuid() == Guid.Empty)
{
throw new MessageBox(this.ErrorMessage);
}
}
else
{
if (db.UpdateById(model) == 0)
{
throw new MessageBox(this.ErrorMessage);
}
}
});
return(model.Function_ID.ToGuidStr());
}
/// <summary>Implements <see cref="ISys_FunctionService.Find"/></summary>
public Sys_Function Find(Int32 id)
{
Sys_Function result = _repository.Find(id);
return(result);
}
public async Task<ApiResult> FindListAsync(int Page, int Rows, [FromBody] Sys_Function Search)
=> this.ResultOk(await this.service.FindListAsync(Page, Rows, Search));
public async Task<ApiResult> SaveAsync([FromBody]Sys_Function Model)
=> this.ResultOk(await this.service.SaveAsync(Model));
/// <summary>
/// 获取实体数据
/// </summary>
/// <param name='strCondition'>条件(AND Code='11')</param>
/// <returns>model</returns>
public Sys_Function GetModel(int id)
{
Sys_Function model = instance.GetByKey(id);
return(model);
}
public IActionResult Save(Sys_Function model)
{
this.FormKey = _Logic.Save(model);
return(Json());
}
public ActionResult Save(Sys_Function model)
{
this.KeyID = _Logic.Save(model);
return(this.Success(new { status = 1, ID = KeyID }));
}
/// <summary>
/// 更新Sys_Function对象(即:一条记录
/// </summary>
public int Update(Sys_Function sys_Function)
{
StringBuilder sbParameter = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(@"UPDATE Sys_Function SET ");
if (sys_Function.Fun_RCode_IsChanged)
{
sbParameter.Append("Fun_RCode=@Fun_RCode, ");
}
if (sys_Function.Fun_Code_IsChanged)
{
sbParameter.Append("Fun_Code=@Fun_Code, ");
}
if (sys_Function.Fun_Name_IsChanged)
{
sbParameter.Append("Fun_Name=@Fun_Name, ");
}
if (sys_Function.Fun_PCode_IsChanged)
{
sbParameter.Append("Fun_PCode=@Fun_PCode, ");
}
if (sys_Function.Fun_Order_IsChanged)
{
sbParameter.Append("Fun_Order=@Fun_Order, ");
}
if (sys_Function.Fun_iType_IsChanged)
{
sbParameter.Append("Fun_iType=@Fun_iType, ");
}
if (sys_Function.Fun_UDef1_IsChanged)
{
sbParameter.Append("Fun_UDef1=@Fun_UDef1, ");
}
if (sys_Function.Fun_UDef2_IsChanged)
{
sbParameter.Append("Fun_UDef2=@Fun_UDef2, ");
}
if (sys_Function.Fun_UDef3_IsChanged)
{
sbParameter.Append("Fun_UDef3=@Fun_UDef3, ");
}
if (sys_Function.Fun_UDef4_IsChanged)
{
sbParameter.Append("Fun_UDef4=@Fun_UDef4, ");
}
if (sys_Function.Fun_UDef5_IsChanged)
{
sbParameter.Append("Fun_UDef5=@Fun_UDef5, ");
}
if (sys_Function.Fun_UDef6_IsChanged)
{
sbParameter.Append("Fun_UDef6=@Fun_UDef6, ");
}
if (sys_Function.Fun_Stat_IsChanged)
{
sbParameter.Append("Fun_Stat=@Fun_Stat, ");
}
if (sys_Function.Stat_IsChanged)
{
sbParameter.Append("Stat=@Stat, ");
}
if (sys_Function.CreateDate_IsChanged)
{
sbParameter.Append("CreateDate=@CreateDate, ");
}
if (sys_Function.UpdateDate_IsChanged)
{
sbParameter.Append("UpdateDate=@UpdateDate, ");
}
if (sys_Function.DeleteDate_IsChanged)
{
sbParameter.Append("DeleteDate=@DeleteDate ");
}
sb.Append(sbParameter.ToString().Trim().TrimEnd(','));
sb.Append(" WHERE 1=1 AND ((Stat is null) or (Stat=0)) and Fun_ID=@Fun_ID; ");
string sql = sb.ToString();
if (sys_Function.Fun_RCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_RCode))
{
idb.AddParameter("@Fun_RCode", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_RCode", sys_Function.Fun_RCode);
}
}
if (sys_Function.Fun_Code_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_Code))
{
idb.AddParameter("@Fun_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Code", sys_Function.Fun_Code);
}
}
if (sys_Function.Fun_Name_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_Name))
{
idb.AddParameter("@Fun_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Name", sys_Function.Fun_Name);
}
}
if (sys_Function.Fun_PCode_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_PCode))
{
idb.AddParameter("@Fun_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_PCode", sys_Function.Fun_PCode);
}
}
if (sys_Function.Fun_Order_IsChanged)
{
if (sys_Function.Fun_Order == 0)
{
idb.AddParameter("@Fun_Order", 0);
}
else
{
idb.AddParameter("@Fun_Order", sys_Function.Fun_Order);
}
}
if (sys_Function.Fun_iType_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_iType))
{
idb.AddParameter("@Fun_iType", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_iType", sys_Function.Fun_iType);
}
}
if (sys_Function.Fun_UDef1_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef1))
{
idb.AddParameter("@Fun_UDef1", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef1", sys_Function.Fun_UDef1);
}
}
if (sys_Function.Fun_UDef2_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef2))
{
idb.AddParameter("@Fun_UDef2", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef2", sys_Function.Fun_UDef2);
}
}
if (sys_Function.Fun_UDef3_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef3))
{
idb.AddParameter("@Fun_UDef3", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef3", sys_Function.Fun_UDef3);
}
}
if (sys_Function.Fun_UDef4_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef4))
{
idb.AddParameter("@Fun_UDef4", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef4", sys_Function.Fun_UDef4);
}
}
if (sys_Function.Fun_UDef5_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef5))
{
idb.AddParameter("@Fun_UDef5", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef5", sys_Function.Fun_UDef5);
}
}
if (sys_Function.Fun_UDef6_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_UDef6))
{
idb.AddParameter("@Fun_UDef6", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef6", sys_Function.Fun_UDef6);
}
}
if (sys_Function.Fun_Stat_IsChanged)
{
if (string.IsNullOrEmpty(sys_Function.Fun_Stat))
{
idb.AddParameter("@Fun_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Stat", sys_Function.Fun_Stat);
}
}
if (sys_Function.Stat_IsChanged)
{
if (sys_Function.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Function.Stat);
}
}
if (sys_Function.CreateDate_IsChanged)
{
if (sys_Function.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", sys_Function.CreateDate);
}
}
if (sys_Function.UpdateDate_IsChanged)
{
if (sys_Function.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", sys_Function.UpdateDate);
}
}
if (sys_Function.DeleteDate_IsChanged)
{
if (sys_Function.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", sys_Function.DeleteDate);
}
}
idb.AddParameter("@Fun_ID", sys_Function.Fun_ID);
return(idb.ExeCmd(sql));
}
public async Task <object> InsertReturnIdentity(Sys_Function ent)
{
return(_logic.GetDbClient().GetSimpleClient <Sys_Function>().InsertReturnIdentity(ent));
}
/// <summary>
/// 添加Sys_Function对象(即:一条记录)
/// </summary>
public int Add(Sys_Function sys_Function)
{
string sql = "INSERT INTO Sys_Function (Fun_RCode,Fun_Code,Fun_Name,Fun_PCode,Fun_Order,Fun_iType,Fun_UDef1,Fun_UDef2,Fun_UDef3,Fun_UDef4,Fun_UDef5,Fun_UDef6,Fun_Stat,Stat,CreateDate,UpdateDate,DeleteDate) VALUES (@Fun_RCode,@Fun_Code,@Fun_Name,@Fun_PCode,@Fun_Order,@Fun_iType,@Fun_UDef1,@Fun_UDef2,@Fun_UDef3,@Fun_UDef4,@Fun_UDef5,@Fun_UDef6,@Fun_Stat,@Stat,@CreateDate,@UpdateDate,@DeleteDate)";
if (string.IsNullOrEmpty(sys_Function.Fun_RCode))
{
idb.AddParameter("@Fun_RCode", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_RCode", sys_Function.Fun_RCode);
}
if (string.IsNullOrEmpty(sys_Function.Fun_Code))
{
idb.AddParameter("@Fun_Code", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Code", sys_Function.Fun_Code);
}
if (string.IsNullOrEmpty(sys_Function.Fun_Name))
{
idb.AddParameter("@Fun_Name", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Name", sys_Function.Fun_Name);
}
if (string.IsNullOrEmpty(sys_Function.Fun_PCode))
{
idb.AddParameter("@Fun_PCode", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_PCode", sys_Function.Fun_PCode);
}
if (sys_Function.Fun_Order == 0)
{
idb.AddParameter("@Fun_Order", 0);
}
else
{
idb.AddParameter("@Fun_Order", sys_Function.Fun_Order);
}
if (string.IsNullOrEmpty(sys_Function.Fun_iType))
{
idb.AddParameter("@Fun_iType", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_iType", sys_Function.Fun_iType);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef1))
{
idb.AddParameter("@Fun_UDef1", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef1", sys_Function.Fun_UDef1);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef2))
{
idb.AddParameter("@Fun_UDef2", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef2", sys_Function.Fun_UDef2);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef3))
{
idb.AddParameter("@Fun_UDef3", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef3", sys_Function.Fun_UDef3);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef4))
{
idb.AddParameter("@Fun_UDef4", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef4", sys_Function.Fun_UDef4);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef5))
{
idb.AddParameter("@Fun_UDef5", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef5", sys_Function.Fun_UDef5);
}
if (string.IsNullOrEmpty(sys_Function.Fun_UDef6))
{
idb.AddParameter("@Fun_UDef6", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_UDef6", sys_Function.Fun_UDef6);
}
if (string.IsNullOrEmpty(sys_Function.Fun_Stat))
{
idb.AddParameter("@Fun_Stat", DBNull.Value);
}
else
{
idb.AddParameter("@Fun_Stat", sys_Function.Fun_Stat);
}
if (sys_Function.Stat == 0)
{
idb.AddParameter("@Stat", 0);
}
else
{
idb.AddParameter("@Stat", sys_Function.Stat);
}
if (sys_Function.CreateDate == DateTime.MinValue)
{
idb.AddParameter("@CreateDate", DBNull.Value);
}
else
{
idb.AddParameter("@CreateDate", sys_Function.CreateDate);
}
if (sys_Function.UpdateDate == DateTime.MinValue)
{
idb.AddParameter("@UpdateDate", DBNull.Value);
}
else
{
idb.AddParameter("@UpdateDate", sys_Function.UpdateDate);
}
if (sys_Function.DeleteDate == DateTime.MinValue)
{
idb.AddParameter("@DeleteDate", DBNull.Value);
}
else
{
idb.AddParameter("@DeleteDate", sys_Function.DeleteDate);
}
return(idb.ExeCmd(sql));
}
/// <summary>
/// Đệ quy lấy danh mục chức năng cấp con
/// </summary>
/// <param name="function"></param>
/// <returns></returns>
protected string BindChildMenu(Sys_Function function)
{
string result = "";
string temp_li_active = @"<li class='selected'><a href='{0}'>{1}</a></li>";
string temp_li = @"<li><a href='{0}'>{1}</a></li>";
string temp_li_blank = @"<li><a target='_blank' href='{0}'>{1}</a></li>";
string temp_li_parent_selected = @"<li class='selected'><a href='{0}'>{1}</a>{2}</li>";
string temp_li_parent = @"<li><a href='{0}'>{1}</a>{2}</li>";
string temp_li_parent_blank = @"<li><a target='_blank' href='{0}'>{1}</a>{2}</li>";
string temp_ul = "<ul>{0}</ul>";
string buildUl = "";
List <Sys_Function> listiPubFunction = new List <Sys_Function>();
listiPubFunction = functionRepository.GetFunctionByTenPhanHe(PHANHE, function.ID, POSITION);
if (listiPubFunction.Count > 0)
{
foreach (Sys_Function childFunction in listiPubFunction)
{
if (childFunction.Icon != "NOT-MENU")
{
string buildListLi = "";
if (functionRepository.GetFunctionByTenPhanHe(PHANHE, childFunction.ID, POSITION).Count > 0)
{
buildListLi += BindChildMenu(childFunction);
if (childFunction.Href == "javascript:void(0);")
{
buildUl += string.Format(temp_li_parent, childFunction.Href, childFunction.TenChucNang, buildListLi);
}
else
{
if (!string.IsNullOrEmpty(childFunction.NodeID))
{
buildUl += string.Format(temp_li_parent_blank, childFunction.Href, childFunction.TenChucNang, buildListLi);
}
else
{
buildUl += string.Format(temp_li_parent, childFunction.Href, childFunction.TenChucNang, buildListLi);
}
}
}
else
{
if (childFunction.Href == "javascript:void(0);")
{
buildUl += string.Format(temp_li, childFunction.Href, childFunction.TenChucNang);
}
else
{
if (!string.IsNullOrEmpty(childFunction.NodeID))
{
buildUl += string.Format(temp_li_blank, childFunction.Href, childFunction.TenChucNang);
}
else
{
buildUl += string.Format(temp_li, childFunction.Href, childFunction.TenChucNang);
}
}
}
}
}
return(string.Format(temp_ul, buildUl));
}
else
{
if (function.Href == "")
{
return(string.Format(temp_li, function.Href, function.TenChucNang));
}
else
{
return(string.Format(temp_li, function.Href, function.TenChucNang));
}
}
}
/// <summary>
/// 获取所有的Sys_Function对象(即:一条记录
/// </summary>
public List <Sys_Function> GetAll()
{
List <Sys_Function> ret = new List <Sys_Function>();
string sql = "SELECT Fun_ID,Fun_RCode,Fun_Code,Fun_Name,Fun_PCode,Fun_Order,Fun_iType,Fun_UDef1,Fun_UDef2,Fun_UDef3,Fun_UDef4,Fun_UDef5,Fun_UDef6,Fun_Stat,Stat,CreateDate,UpdateDate,DeleteDate FROM Sys_Function where 1=1 AND ((Stat is null) or (Stat=0) ) ";
SqlDataReader dr = null;
try {
dr = (SqlDataReader)idb.ReturnReader(sql);
while (dr.Read())
{
Sys_Function sys_Function = new Sys_Function();
if (dr["Fun_ID"] != DBNull.Value)
{
sys_Function.Fun_ID = Convert.ToDecimal(dr["Fun_ID"]);
}
if (dr["Fun_RCode"] != DBNull.Value)
{
sys_Function.Fun_RCode = Convert.ToString(dr["Fun_RCode"]);
}
if (dr["Fun_Code"] != DBNull.Value)
{
sys_Function.Fun_Code = Convert.ToString(dr["Fun_Code"]);
}
if (dr["Fun_Name"] != DBNull.Value)
{
sys_Function.Fun_Name = Convert.ToString(dr["Fun_Name"]);
}
if (dr["Fun_PCode"] != DBNull.Value)
{
sys_Function.Fun_PCode = Convert.ToString(dr["Fun_PCode"]);
}
if (dr["Fun_Order"] != DBNull.Value)
{
sys_Function.Fun_Order = Convert.ToInt32(dr["Fun_Order"]);
}
if (dr["Fun_iType"] != DBNull.Value)
{
sys_Function.Fun_iType = Convert.ToString(dr["Fun_iType"]);
}
if (dr["Fun_UDef1"] != DBNull.Value)
{
sys_Function.Fun_UDef1 = Convert.ToString(dr["Fun_UDef1"]);
}
if (dr["Fun_UDef2"] != DBNull.Value)
{
sys_Function.Fun_UDef2 = Convert.ToString(dr["Fun_UDef2"]);
}
if (dr["Fun_UDef3"] != DBNull.Value)
{
sys_Function.Fun_UDef3 = Convert.ToString(dr["Fun_UDef3"]);
}
if (dr["Fun_UDef4"] != DBNull.Value)
{
sys_Function.Fun_UDef4 = Convert.ToString(dr["Fun_UDef4"]);
}
if (dr["Fun_UDef5"] != DBNull.Value)
{
sys_Function.Fun_UDef5 = Convert.ToString(dr["Fun_UDef5"]);
}
if (dr["Fun_UDef6"] != DBNull.Value)
{
sys_Function.Fun_UDef6 = Convert.ToString(dr["Fun_UDef6"]);
}
if (dr["Fun_Stat"] != DBNull.Value)
{
sys_Function.Fun_Stat = Convert.ToString(dr["Fun_Stat"]);
}
if (dr["Stat"] != DBNull.Value)
{
sys_Function.Stat = Convert.ToInt32(dr["Stat"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
sys_Function.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["UpdateDate"] != DBNull.Value)
{
sys_Function.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]);
}
if (dr["DeleteDate"] != DBNull.Value)
{
sys_Function.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]);
}
ret.Add(sys_Function);
}
}catch (System.Exception ex) { throw ex; } finally { if (dr != null)
{
dr.Close();
}
if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open)
{
idb.GetConnection().Close();
}
}
return(ret);
}
public async Task <object> Update(Sys_Function ent)
{
return(_logic.GetDbClient().GetSimpleClient <Sys_Function>().Update(ent));
}
