/// <summary>
/// 设定群组对应的用户
/// </summary>
/// <param name="menuID"></param>
/// <param name="groupIDList"></param>
public static void SetMenuGroups(string menuID, List <string> groupIDList)
{
SqlConnection conn = new SqlConnection(Config.ConnectionString);
try
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlHelper.DeleteTable <SysMenuGroup>(trans,
ColumnFilterList.New("menu_id", menuID));
//insert menu_groups
foreach (string groupID in groupIDList)
{
SysMenuGroup entity = new SysMenuGroup(menuID, groupID);
SqlHelper.Insert(trans, entity);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
finally
{
conn.Close();
}
}
public static void DeleteMaster(SysCodeMaster entity)
{
SqlConnection conn = new SqlConnection(Config.ConnectionString);
conn.Open();
try
{
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlHelper.DeleteTable <SysCodeList>(trans, ColumnFilterList.New("main_key", entity.MainKey));
SqlHelper.Delete(trans, entity);
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
finally
{
conn.Close();
}
}
/// <summary>
/// 设定群组对应的用户
/// </summary>
/// <param name="groupID"></param>
/// <param name="empIDList"></param>
public static void SetGroupUsers(string groupID, List <string> empIDList)
{
SqlConnection conn = new SqlConnection(Config.ConnectionString);
try
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlHelper.DeleteTable <SysGroupUser>(trans, ColumnFilterList.New("group_id", groupID));
//insert group_users
foreach (string empID in empIDList)
{
SysGroupUser entity = new SysGroupUser(groupID, empID);
SqlHelper.Insert(trans, entity);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
finally
{
conn.Close();
}
}
public static List <ActiveInfo> GetAll(int formId)
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("form_Id", formId));
return(SqlHelper.QueryTable <ActiveInfo>(Config.ConnectionString, cfl));
}
public static List <ParticipantInfo> GetParticipantByActive(string ActiveId)
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("active_id", ActiveId));
return(SqlHelper.QueryTable <ParticipantInfo>(Config.ConnectionString, cfl));
}
public static List <ConditionSubInfo> GetConditionSubList(string conditionId)
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("Condition_Id", conditionId));
return(SqlHelper.QueryTable <ConditionSubInfo>(Config.ConnectionString, cfl));
}
public static List <SysDeptInfo> GetSubDept(string deptId)
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("parent_id", deptId));
return(SqlHelper.QueryTable <SysDeptInfo>(Config.ConnectionString, cfl));
}
public static List <FormHeaderInfo> GetFormHeader(int formId, int formNo)
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("form_Id", formId));
cfl.Add(new ColumnFilter("form_no", formNo));
return(SqlHelper.QueryTable <FormHeaderInfo>(Config.ConnectionString, cfl));
}
public static List <SysUserInfo> GetEmployee(string deptId)
{
SysDeptInfo dept = GetDept(deptId);
if (dept == null)
{
return(new List <SysUserInfo>());
}
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("dept_code", dept.DeptCode));
return(SqlHelper.QueryTable <SysUserInfo>(Config.ConnectionString, cfl));
}
public static bool DeleteFlow(string formId)
{
using (SqlConnection conn = new SqlConnection(Config.ConnectionString))
{
conn.Open();
try
{
SqlTransaction trans = conn.BeginTransaction();
try
{
ColumnFilterList cfl = new ColumnFilterList();
cfl.Add(new ColumnFilter("form_Id", formId));
SqlHelper.DeleteTable <ConditionInfo>(trans, cfl);
SqlHelper.DeleteTable <ActiveInfo>(trans, cfl);
SqlHelper.DeleteTable <FormInfo>(trans, cfl);
trans.Commit();
return(true);
}
catch (Exception ex)
{
trans.Rollback();
SimpleFlow.SystemFramework.Log.WriteLog("DeleteWorkFlowXML", ex);
return(false);
}
}
finally
{
conn.Close();
}
}
}
/// <summary>
/// 获取Parent下的所有SysMenu
/// </summary>
/// <returns></returns>
public static List <SysMenu> GetChildMenuList(string parentID)
{
return(SqlHelper.QueryTable <SysMenu>(Config.ConnectionString,
ColumnFilterList.New("parent_id", parentID)));
}
public static List <SysCodeList> GetCodeList(string main_key)
{
return(SqlHelper.QueryTable <SysCodeList>(Config.ConnectionString,
ColumnFilterList.New("main_key", main_key)));
}
/// <summary>
/// 获取在职人员列表
/// </summary>
/// <returns>SysUserInfo的列表</returns>
public static List <SysUserInfo> GetActiveUserList()
{
return(SqlHelper.QueryTable <SysUserInfo>(Config.ConnectionString,
ColumnFilterList.New("active", "Y")));
}
public static List <FormHeaderInfo> GetFormHeadersByKind(int form_Id)
{
return(SqlHelper.QueryTable <FormHeaderInfo>(Config.ConnectionString,
ColumnFilterList.New("form_Id", form_Id)));
}
