//------------------------------------------------------------------------------------------
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="entity"></param>
public bool Append(Role_resource entity)
{
try
{
bool result = _Role_resourceDal.Append(entity);
ClearCacheData();
return result;
}
catch (Exception ex)
{
DealError(ex);
return false;
}
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity"></param>
public bool Append(Role_resource entity)
{
string sqlCmd = "insert into mp_role_resource (ResourceName ,ParentID ,Sort ,ShowInMenu ,State ,CreateTime ,Url) values (@ResourceName ,@ParentID ,@Sort ,@ShowInMenu ,@State ,@CreateTime ,@Url);SELECT LAST_INSERT_ID();";
MySqlParameter[] pars = new MySqlParameter[7];
pars[0] = new MySqlParameter("@ResourceName",entity.ResourceName);
pars[1] = new MySqlParameter("@ParentID",entity.ParentID);
pars[2] = new MySqlParameter("@Sort",entity.Sort);
pars[3] = new MySqlParameter("@ShowInMenu",entity.ShowInMenu);
pars[4] = new MySqlParameter("@State",entity.State);
pars[5] = new MySqlParameter("@CreateTime",entity.CreateTime);
pars[6] = new MySqlParameter("@Url",entity.Url);
entity.ResourceID = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sqlCmd,pars));
return true;
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="entity"></param>
public bool Update(Role_resource entity)
{
string sqlCmd = "update mp_role_resource set ResourceName = @ResourceName, ParentID = @ParentID, Sort = @Sort, ShowInMenu = @ShowInMenu, State = @State, CreateTime = @CreateTime, Url = @Url where ResourceID = @ResourceID ";
MySqlParameter[] pars = new MySqlParameter[8];
pars[0] = new MySqlParameter("@ResourceID",entity.ResourceID);
pars[1] = new MySqlParameter("@ResourceName",entity.ResourceName);
pars[2] = new MySqlParameter("@ParentID",entity.ParentID);
pars[3] = new MySqlParameter("@Sort",entity.Sort);
pars[4] = new MySqlParameter("@ShowInMenu",entity.ShowInMenu);
pars[5] = new MySqlParameter("@State",entity.State);
pars[6] = new MySqlParameter("@CreateTime",entity.CreateTime);
pars[7] = new MySqlParameter("@Url",entity.Url);
return MySqlHelper.ExecuteNonQuery(CommandType.Text,sqlCmd, pars);
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 把reader转换成Entity
/// </summary>
/// <param name="table">表数据</param>
/// <returns></returns>
private Role_resource DataReaderToEntity(IDataReader reader)
{
Role_resource entity= new Role_resource();
entity.ResourceID = Convert.ToInt32(reader["ResourceID"]) ;
entity.ResourceName = Convert.ToString(reader["ResourceName"]) ;
entity.ParentID = Convert.ToInt32(reader["ParentID"]) ;
entity.Sort = Convert.ToInt32(reader["Sort"]) ;
entity.ShowInMenu = Convert.ToInt32(reader["ShowInMenu"]) ;
entity.State = Convert.ToInt32(reader["State"]) ;
entity.CreateTime = Convert.ToDateTime(reader["CreateTime"]) ;
entity.Url = Convert.ToString(reader["Url"]) ;
return entity;
}
public ActionResult SaveResource()
{
List<Role_resource> newResource = new List<Role_resource>();
List<Role_resource> updateResource = new List<Role_resource>();
foreach (string item in Request.Form.Keys)
{
Match match = Regex.Match(item, @"ResourceName\[(?<id>\d+)\]");
if (match.Success)
{
int id = Convert.ToInt32(match.Groups["id"].Value);
Role_resource res = new Role_resource();
res.ResourceID = id;
res.ResourceName = DTLRequest.GetString(string.Format("ResourceName[{0}]", id));
res.ParentID = DTLRequest.GetInt(string.Format("ParentID[{0}]", id), 0);
res.Url = DTLRequest.GetString(string.Format("Url[{0}]", id));
res.Sort = DTLRequest.GetInt(string.Format("Sort[{0}]", id), 0);
res.State = DTLRequest.GetInt(string.Format("State[{0}]", id), 0);
res.ShowInMenu = DTLRequest.GetInt(string.Format("ShowInMenu[{0}]", id), 0);
updateResource.Add(res);
}
}
if (!string.IsNullOrEmpty(DTLRequest.GetString("new[ResourceName]")))
{
string[] names = DTLRequest.GetString("new[ResourceName]").Split(',');
string[] urls = DTLRequest.GetString("new[Url]").Split(',');
string[] sorts = DTLRequest.GetString("new[Sort]").Split(',');
string[] states = DTLRequest.GetString("new[State]").Split(',');
string[] parents = DTLRequest.GetString("new[ParentID]").Split(',');
string[] showmenus = DTLRequest.GetString("new[ShowInMenu]").Split(',');
for (int i = 0; i < names.Length; i++)
{
try
{
Role_resource res = new Role_resource();
res.ResourceName = names[i];
res.Url = urls[i];
int temp = 0;
if (int.TryParse(sorts[i], out temp))
{
res.Sort = temp;
}
if (int.TryParse(states[i], out temp))
{
res.State = temp;
}
if (int.TryParse(parents[i], out temp))
{
res.ParentID = temp;
}
if (int.TryParse(showmenus[i], out temp))
{
res.ShowInMenu = temp;
}
if (!string.IsNullOrEmpty(res.ResourceName))
{
newResource.Add(res);
}
}
catch (Exception ex)
{
Log.Default.Info(ex);
}
}
}
foreach (var item in newResource)
{
Role_resourceBLL.Current.Append(item);
}
foreach (var item in updateResource)
{
Role_resourceBLL.Current.Update(item);
}
return CommonResult.ShowMessage("保存成功！", Url.Action("resources"));
}