private Entities.BusinessGroup LoadSingleBusinessGroup(DataRow row)
{
Entities.BusinessGroup model = new Entities.BusinessGroup();
if (row["BGID"].ToString() != "")
{
model.BGID = int.Parse(row["BGID"].ToString());
}
model.Name = row["Name"].ToString();
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CDID"].ToString() != "")
{
model.CDID = int.Parse(row["CDID"].ToString());
}
if (row["RegionID"].ToString() != "")
{
model.RegionID = int.Parse(row["RegionID"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["BusinessType"].ToString() != "")
{
model.BusinessType = int.Parse(row["BusinessType"].ToString());
}
return(model);
}
/// 绑定组数据
/// <summary>
/// 绑定组数据
/// </summary>
private void BindGroupData()
{
if (!string.IsNullOrEmpty(BGID))
{
int bgid = CommonFunction.ObjectToInteger(BGID);
Entities.BusinessGroup model = BLL.BusinessGroup.Instance.GetBusinessGroupInfoByBGID(bgid);
//名称
txtBgName.Value = model.Name;
//区域
if (model.RegionID == 1)
{
rdo_areaid_1.Checked = true;
}
else if (model.RegionID == 2)
{
rdo_areaid_2.Checked = true;
}
//设置所属业务
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.CC) == (int)BusinessTypeEnum.CC)
{
this.ckb_businesstype_1.Checked = true;
}
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.IM) == (int)BusinessTypeEnum.IM)
{
this.ckb_businesstype_2.Checked = true;
}
//外显号码(js赋值)
CDID = model.CDID.ToString();
//业务线列表(js赋值)
LineIDs = BLL.BusinessGroup.Instance.GetBusinessLineIDs(bgid);
}
}
private void ChangeBusinessGroupStatus(out string msg)
{
msg = string.Empty;
try
{
Entities.BusinessGroup model = BLL.Util.BindQuery <Entities.BusinessGroup>(HttpContext.Current);
if (model.BGID > 0)
{
if (model.Status == 1)
{
string where = string.Empty;
where += " and BGID=" + model.BGID;
//add by qizq 2014-12-1 取分组下人数加人员在职，部门在配置文件指定的部门及其子部门下
where += " and ui.Status=0 ";
string PartIDs = BitAuto.Utils.Config.ConfigurationUtil.GetAppSettingValue("PartID");
int DepCount = PartIDs.Split(',').Length;
if (DepCount > 0)
{
where += " and (";
for (int i = 0; i < DepCount; i++)
{
if (i != 0)
{
where += " or ";
}
where += " DepartID in (select ID from SysRightsManager.dbo.f_Cid('" + PartIDs.Split(',')[i] + "')) ";
}
where += " )";
}
int totalCount = BLL.EmployeeAgent.Instance.GetUserCountByGroup(where);
if (totalCount > 0)
{
msg = "{result:'no',msg:'此业务组目前正在使用，无法进行停用操作！'}";
return;
}
}
Entities.BusinessGroup info = BLL.BusinessGroup.Instance.GetBusinessGroupInfoByBGID(model.BGID);
if (info != null)
{
info.Status = model.Status;
BLL.BusinessGroup.Instance.Update(info);
msg = "{result:'yes',msg:'保存成功'}";
}
else
{
msg = "{result:'no',msg:'没有找到对应分组信息'}";
}
}
}
catch (Exception ex)
{
msg = "{result:'no',msg:'" + ex.Message + "'}";
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Entities.BusinessGroup model)
{
SqlParameter[] parameters =
{
new SqlParameter("@BGID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CDID", SqlDbType.Int, 4),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@BusinessType", SqlDbType.Int, 4)
};
parameters[0].Value = model.BGID;
parameters[1].Value = model.Name;
parameters[2].Value = model.Status;
parameters[3].Value = model.CDID;
parameters[4].Value = model.RegionID;
parameters[5].Value = model.BusinessType;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, "p_BusinessGroup_Update", parameters);
return((int)parameters[0].Value);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Entities.BusinessGroup model)
{
return(Dal.BusinessGroup.Instance.Update(model));
}
public int Insert(Entities.BusinessGroup model)
{
return(Dal.BusinessGroup.Instance.Insert(model));
}
/// 新增或者修改分组
/// <summary>
/// 新增或者修改分组
/// </summary>
/// <param name="msg"></param>
private void DisposeBusinessGroup(out string msg)
{
msg = string.Empty;
try
{
Entities.BusinessGroup model = BLL.Util.BindQuery <Entities.BusinessGroup>(HttpContext.Current);
if (model.BGID > 0)
{
//修改逻辑
Entities.BusinessGroup info = BLL.BusinessGroup.Instance.GetBusinessGroupInfoByBGID(model.BGID);
if (info != null)
{
info.Name = model.Name;
info.RegionID = model.RegionID;
info.BusinessType = model.BusinessType;
//业务包含cc，才有外显号码
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.CC) == (int)BusinessTypeEnum.CC)
{
info.CDID = model.CDID;
}
else
{
info.CDID = -2;
}
//修改组数据
BLL.BusinessGroup.Instance.Update(info);
//业务包含im时
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.IM) == (int)BusinessTypeEnum.IM)
{
//清空业务线数据
BLL.BusinessGroupLineMapping.Instance.Delete(model.BGID);
//插入业务线数据
InsertBusinessGroupLineMapping(model.BGID, model.LineIDs);
}
else
{
//清空业务线数据
BLL.BusinessGroupLineMapping.Instance.Delete(model.BGID);
}
msg = "{result:'yes',BGID:'" + model.BGID + "',AreaID:'" + AreaID + "',msg:'保存成功'}";
}
else
{
msg = "{result:'no',BGID:'" + model.BGID + "',AreaID:'" + AreaID + "',msg:'没有找到对应分组信息'}";
}
}
else
{
//新增逻辑
model.CreateTime = DateTime.Now;
model.Status = 0;
//业务包含cc，才有外显号码
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.CC) != (int)BusinessTypeEnum.CC)
{
model.CDID = -2;
}
//插入组数据
int id = BLL.BusinessGroup.Instance.Insert(model);
//业务包含im时
if ((CommonFunction.ObjectToInteger(model.BusinessType) & (int)BusinessTypeEnum.IM) == (int)BusinessTypeEnum.IM)
{
//插入业务线数据
InsertBusinessGroupLineMapping(id, model.LineIDs);
}
//创建分类
Entities.SurveyCategory categoryModel = new Entities.SurveyCategory();
categoryModel.BGID = id;
categoryModel.Status = -3;
categoryModel.CreateTime = DateTime.Now;
categoryModel.CreateUserID = BLL.Util.GetLoginUserID();
categoryModel.Name = "工单分类";
categoryModel.TypeId = 2;
int scId = BLL.SurveyCategory.Instance.Insert(categoryModel);
//创建业务线url地址
string webBaseUrl = ConfigurationUtil.GetAppSettingValue("ExitAddress");
webBaseUrl = webBaseUrl + "/WorkOrder/WorkOrderView.aspx?OrderID={0}";
BLL.CallRecord_ORIG_Business.Instance.AddBusinessUrl(id, scId, webBaseUrl);
msg = "{result:'yes',BGID:'" + id + "',AreaID:'" + AreaID + "',msg:'保存成功'}";
}
}
catch (Exception ex)
{
msg = "{result:'no',BGID:'',AreaID:'',msg:'" + ex.Message + "'}";
}
}
