/// <summary>
/// 设置表头定义批量公开
/// </summary>
/// <param name="KeyValue">主键值</param>
/// <param name="MenuId">模块菜单主键</param>
/// <returns></returns>
public int BatchIsPublic(string[] KeyValue, string MenuId)
{
StringBuilder[] sqls = new StringBuilder[KeyValue.Length + 1];
object[] objs = new object[KeyValue.Length + 1];
BPMS_TableColumns entity = new BPMS_TableColumns();
entity.MenuId = MenuId;
entity.IsPublic = 0;
sqls[0] = DbCommon.UpdateSql(entity, "MenuId");
objs[0] = DbCommon.GetParameter(entity);
int index = 1;
foreach (string item in KeyValue)
{
if (item.Length > 0)
{
BPMS_TableColumns entityitem = new BPMS_TableColumns();
entityitem.TableColumnsId = item;
entityitem.IsPublic = 1;
entityitem.SortCode = index;
sqls[index] = DbCommon.UpdateSql(entityitem, "TableColumnsId");
objs[index] = DbCommon.GetParameter(entityitem);
index++;
}
}
return(DataFactory.SqlHelper().BatchExecuteBySql(sqls, objs));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public void InitControl()
{
if (!string.IsNullOrEmpty(_key))
{
bpms_tablecolumns = bpms_tablecolumnsibll.GetEntity(_key);
ControlBindHelper.SetWebControls(this.Page, bpms_tablecolumns);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_TableColumns entity)
{
entity.SortCode = CommonHelper.GetInt(this.GetMaxCode());
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_TableColumns>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Update(BPMS_TableColumns entity)
{
#region 获取旧值
var oldEntity = this.GetEntity(BPMS_SysLogDAL.Instance.GetKeyFieldValue <BPMS_TableColumns>(entity).ToString());
#endregion
int IsOk = DataFactory.DbUtils().Update(entity, "TableColumnsId");
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.UpdateTaskLog <BPMS_TableColumns>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 确认事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Accept_Click(object sender, EventArgs e)
{
bool IsOk = false;
bpms_tablecolumns = ControlBindHelper.GetWebControls <BPMS_TableColumns>(this.Page);
bpms_tablecolumns.MenuId = _Menu_Id;
bpms_tablecolumns.IsPublic = IsPublic.Checked ? 1 : 0;
bpms_tablecolumns.IsHidden = IsHidden.Checked ? 1 : 0;
bpms_tablecolumns.Enabled = Enabled.Checked ? 1 : 0;
bpms_tablecolumns.AllowEdit = AllowEdit.Checked ? 1 : 0;
bpms_tablecolumns.AllowDelete = AllowDelete.Checked ? 1 : 0;
if (!string.IsNullOrEmpty(_key))//判断是否编辑
{
bpms_tablecolumns.TableColumnsId = _key;
bpms_tablecolumns.ModifyDate = DateTime.Now;
bpms_tablecolumns.ModifyUserId = RequestSession.GetSessionUser().UserId;
bpms_tablecolumns.ModifyUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_tablecolumnsibll.Update(bpms_tablecolumns);
if (IsOk)
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0006);
}
}
else
{
bpms_tablecolumns.TableColumnsId = CommonHelper.GetGuid;
bpms_tablecolumns.CreateUserId = RequestSession.GetSessionUser().UserId;
bpms_tablecolumns.CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_tablecolumnsibll.Insert(bpms_tablecolumns);
if (IsOk)
{
ShowMsgHelper.AlertCallback(MessageHelper.MSG0005);
}
}
if (!IsOk)
{
ShowMsgHelper.Alert_Error(MessageHelper.MSG0022);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public bool Update(BPMS_TableColumns entity)
{
return(dal.Update(entity) >= 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public bool Insert(BPMS_TableColumns entity)
{
return(dal.Insert(entity) >= 0 ? true : false);
}