//批量设置序号
protected void btnSave_Click(object sender, EventArgs e)
{
IList <EyouSoft.Model.MQStructure.IMSuperCluster> list = new List <EyouSoft.Model.MQStructure.IMSuperCluster>();
EyouSoft.Model.MQStructure.IMSuperCluster model = null;
for (int i = 0; i < Utils.GetFormValues("chkId").Length; i++)
{
for (int j = 0; j < Utils.GetFormValues("sort").Length; j++)
{
if (Utils.GetInt(Utils.GetFormValues("chkId")[i]) == Utils.GetInt(Utils.GetFormValues("hidid")[j]))
{
model = new EyouSoft.Model.MQStructure.IMSuperCluster()
{
Num = Utils.GetInt(Utils.GetFormValues("sort")[j]),
Id = Utils.GetInt(Utils.GetFormValues("chkId")[i])
};
list.Add(model);
break;
}
}
}
if (list.Count > 0)
{
EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().SetNums(list);
}
Bind();
}
/// <summary>
/// 获取所有的同业中心
/// </summary>
/// <returns>同业中心列表</returns>
public IList <EyouSoft.Model.MQStructure.IMSuperCluster> GetAllClusters()
{
var lst = new List <EyouSoft.Model.MQStructure.IMSuperCluster>(); // 同业中心实体
var strSql = new StringBuilder(); // SQL编辑器
strSql.Append(" SELECT");
strSql.Append(" id");
strSql.Append(" ,title");
strSql.Append(" FROM");
strSql.Append(" tbl_SuperCluster");
DbCommand cmd = this._database.GetSqlStringCommand(strSql.ToString()); // SQL执行
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._database))
{
while (dr.Read())
{
// 同业中心实体
var model = new EyouSoft.Model.MQStructure.IMSuperCluster()
{
// 超级群ID
Id = dr.GetInt32(dr.GetOrdinal("id")),
// 超级群名称
Title = dr.IsDBNull(dr.GetOrdinal("title")) ? string.Empty : dr.GetString(dr.GetOrdinal("title"))
};
// 追加到实体列表
lst.Add(model);
}
}
// 返回同业中心实体列表
return(lst);
}
/// <summary>
/// 更新同业中心
/// </summary>
/// <param name="model">同业中心实体</param>
/// <returns>True：成功 False：失败</returns>
public bool Upd(EyouSoft.Model.MQStructure.IMSuperCluster model)
{
DbCommand dc = null; // 命令基类
dc = this._database.GetStoredProcCommand("proc_SuperCluster_UpdCluster"); // 执行存储过程
this._database.AddInParameter(dc, "@ID", DbType.Int32, model.Id); // 超级群ID
this._database.AddInParameter(dc, "@Title", DbType.String, model.Title); // 名称
this._database.AddInParameter(dc, "@Master", DbType.Int32, model.Master); // 总管理员
this._database.AddInParameter(dc, "@SelectType", DbType.Int32, model.SelectType); // 成员构成导入类型【1：选择省市 2：选择会员ID】
this._database.AddInParameter(dc, "@SelectValue", DbType.String, model.SelectValue.TrimEnd(',').TrimStart(',')); // 用【，】隔开导入省份或者会员ID数据
this._database.AddInParameter(dc, "@Num", DbType.Int32, model.Num); // 序号
this._database.AddInParameter(dc, "@PassWord", DbType.String, model.PassWord); // 密码
this._database.AddInParameter(dc, "@Opertor", DbType.String, model.Opertor); // 操作人
this._database.AddInParameter(dc, "@OperateTime", DbType.DateTime, model.OperateTime); // 操作时间
try
{
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
catch (Exception de)
{
throw de;
}
}
/// <summary>
/// 根据同业中心ID获取同业中心实体
/// </summary>
/// <param name="id">同业中心ID</param>
/// <returns>同业中心实体</returns>
public EyouSoft.Model.MQStructure.IMSuperCluster GetSuperClusterByID(int id)
{
var model = new EyouSoft.Model.MQStructure.IMSuperCluster(); // 同业中心实体
var strSql = new StringBuilder(); // SQL编辑器
strSql.Append(" SELECT");
strSql.Append(" title"); // 名称
strSql.Append(" ,master"); // 总管理员
strSql.Append(" ,Num"); // 序号
strSql.Append(" ,SelectType"); // 成员构成导入类型
strSql.Append(" ,SelectValue"); // 用【，】隔开导入省份或者会员ID数据
strSql.Append(" ,PassWord"); // 密码
strSql.Append(" ,Opertor"); // 操作人
strSql.Append(" ,OperateTime"); // 操作时间
strSql.Append(" FROM");
strSql.Append(" tbl_SuperCluster");
strSql.Append(" WHERE");
strSql.Append(" ID = @ID");
DbCommand cmd = this._database.GetSqlStringCommand(strSql.ToString()); // SQL执行
this._database.AddInParameter(cmd, "@ID", DbType.Int32, id); // 同业中心ID
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._database))
{
while (dr.Read())
{
// 名称
model.Title = dr.IsDBNull(dr.GetOrdinal("title")) ? string.Empty : dr.GetString(dr.GetOrdinal("title"));
// 总管理员
model.Master = dr.IsDBNull(dr.GetOrdinal("master")) ? 0 : dr.GetInt32(dr.GetOrdinal("master"));
// 序号
model.Num = dr.IsDBNull(dr.GetOrdinal("Num")) ? 0 : dr.GetInt32(dr.GetOrdinal("Num"));
// 成员构成导入类型
model.SelectType = dr.IsDBNull(dr.GetOrdinal("SelectType")) ? EyouSoft.Model.MQStructure.SelectType.择省市 : (EyouSoft.Model.MQStructure.SelectType)dr.GetInt32(dr.GetOrdinal("SelectType"));
// 用【，】隔开导入省份或者会员ID数据
model.SelectValue = dr.IsDBNull(dr.GetOrdinal("SelectValue")) ? string.Empty : dr.GetString(dr.GetOrdinal("SelectValue"));
// 密码
model.PassWord = dr.IsDBNull(dr.GetOrdinal("PassWord")) ? string.Empty : dr.GetString(dr.GetOrdinal("PassWord"));
// 发布人
model.Opertor = dr.IsDBNull(dr.GetOrdinal("Opertor")) ? string.Empty : dr.GetString(dr.GetOrdinal("Opertor"));
// 发布时间
model.OperateTime = dr.IsDBNull(dr.GetOrdinal("OperateTime")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("OperateTime"));
}
}
// 返回同业中心实体
return(model);
}
/// <summary>
/// 更新同业中心
/// </summary>
/// <param name="model">同业中心实体</param>
/// <returns>True：成功 False：失败</returns>
public bool Upd(EyouSoft.Model.MQStructure.IMSuperCluster model)
{
if (model != null)
{
return(this.dal.Upd(model));
}
else
{
return(false);
}
}
//初始化
private void Bind()
{
int id = Utils.GetInt(Utils.GetQueryStringValue("id"));
if (id != 0)
{
EyouSoft.Model.MQStructure.IMSuperCluster model = EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().GetSuperClusterByID(id);
if (model != null)
{
//同业中心名称
txtTongyeCenterName.Value = model.Title;
//会员导入方式
if (model.SelectType == EyouSoft.Model.MQStructure.SelectType.择省市)
{
selProvince.Checked = true;
//导入的省市
hidProCityIDs.Value = model.SelectValue;
}
else if (model.SelectType == EyouSoft.Model.MQStructure.SelectType.择会员ID)
{
radByIds.Checked = true;
//导入的会员ID
hidMemberIDs.Value = model.SelectValue;
}
//排序号
txtSort.Value = model.Num.ToString();
//总管理员ID
txtIDs.Value = model.Master.ToString();
//总管理员密码
txtPassword.Value = model.PassWord;
//操作人
txtOper.Value = MasterUserInfo.ContactName;
//操作时间
txtDate.Value = model.OperateTime.ToString();
}
}
else
{
txtOper.Value = MasterUserInfo.ContactName;
txtDate.Value = DateTime.Now.ToString();
}
//获得所有已选的省市
IList <EyouSoft.Model.SystemStructure.ProvinceBase> list = null;
list = EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().GetSelectedProvincesByID(id);
if (list != null)
{
foreach (var item in list)
{
hidProCityIDsEd.Value += item.ProvinceId + ",";
}
}
}
/// <summary>
/// 绑定
/// </summary>
private void Bind()
{
//时间
int Stime = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("Stime"));
//同中中心编号
int SuperID = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("SuperID"));
//根据同业中心编号得到其省份
string Province = "0";
EyouSoft.Model.MQStructure.IMSuperCluster model = EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().GetSuperClusterByID(SuperID);
if (model != null)
{
if (model.SelectType == EyouSoft.Model.MQStructure.SelectType.择省市)
{
Province = model.SelectValue;
}
}
string SearchText = EyouSoft.Common.Utils.GetFormValue("textfield") == "请输入关键字" ? "" : EyouSoft.Common.Utils.GetFormValue("textfield");
exList = EyouSoft.BLL.CommunityStructure.ExchangeList.CreateInstance().GetList(Province, Stime, SearchText);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (CheckData())
{
//同业中心编号
int id = Utils.GetInt(Utils.GetQueryStringValue("id"));
EyouSoft.Model.MQStructure.IMSuperCluster model = new EyouSoft.Model.MQStructure.IMSuperCluster();
//同业中心名称
model.Title = txtTongyeCenterName.Value;
//会员导入方式
if (selProvince.Checked)
{
//导入的省市
model.SelectType = EyouSoft.Model.MQStructure.SelectType.择省市;
model.SelectValue = hidProCityIDs.Value.Trim(',');
}
if (radByIds.Checked)
{
//导入的会员ID
model.SelectType = EyouSoft.Model.MQStructure.SelectType.择会员ID;
hidMemberIDs.Value = System.Text.RegularExpressions.Regex.Replace(hidMemberIDs.Value, ",+", ",");
model.SelectValue = hidMemberIDs.Value.Trim(',');
}
//排序号
model.Num = Utils.GetInt(txtSort.Value);
//总管理员ID
model.Master = Utils.GetInt(txtIDs.Value);
//总管理员密码
model.PassWord = txtPassword.Value;
//操作人
model.Opertor = txtOper.Value;
//操作时间
model.OperateTime = Utils.GetDateTime(txtDate.Value);
//修改
if (id != 0)
{
if (EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().IsExist(model.Title, id))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "alert('该同业中心已存在!')");
return;
}
model.Id = id;
if (EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().Upd(model))
{
Utils.ShowAndRedirect("修改成功", "TongyeCenterManager.aspx");
}
else
{
Utils.ShowAndRedirect("修改失败", "TongyeCenterManager.aspx");
}
}
//添加
else
{
if (EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().IsExist(model.Title, 0))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "alert('该同业中心已存在!')");
return;
}
if (EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().Add(model))
{
Utils.ShowAndRedirect("添加成功", "TongyeCenterManager.aspx");
}
else
{
Utils.ShowAndRedirect("添加失败", "TongyeCenterManager.aspx");
}
}
}
}
private void Post()
{
//同业中心编号
int SuperID = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("SuperID"));
//同心中心所选省份
EyouSoft.Model.MQStructure.IMSuperCluster IMSuperCluster = EyouSoft.BLL.MQStructure.IMSuperCluster.CreateInstance().GetSuperClusterByID(SuperID);
System.Collections.Generic.IList <int> ProvinceIds = null;
if (IMSuperCluster != null)
{
if (IMSuperCluster.SelectType == EyouSoft.Model.MQStructure.SelectType.择省市)
{
string[] strProvinceIds = IMSuperCluster.SelectValue.Split(',');
if (strProvinceIds != null && strProvinceIds.Length > 0)
{
ProvinceIds = new System.Collections.Generic.List <int>();
for (int i = 0; i < strProvinceIds.Length; i++)
{
if (!string.IsNullOrEmpty(strProvinceIds[i]) && EyouSoft.Common.Function.StringValidate.IsInteger(strProvinceIds[i]))
{
ProvinceIds.Add(int.Parse(strProvinceIds[i]));
}
}
}
}
}
EyouSoft.Model.CommunityStructure.ExchangeList model = new EyouSoft.Model.CommunityStructure.ExchangeList();
if (content.Value.Length == 0)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "document.getElementById(\"showMsg\").innerHTML=\"请输入求购内容\";");
return;
}
if (content.Value.Length > 500)
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "document.getElementById(\"showMsg\").innerHTML=\"求购内容最多500字\";");
return;
}
if (content.Value.Length > 15)
{
model.ExchangeTitle = content.Value.Substring(0, 15);
}
else
{
model.ExchangeTitle = content.Value;
}
model.CityId = SiteUserInfo.CityId;
model.CompanyId = SiteUserInfo.CompanyID;
model.CompanyName = SiteUserInfo.CompanyName;
model.ContactName = SiteUserInfo.ContactInfo.ContactName;
model.ContactTel = SiteUserInfo.ContactInfo.Tel;
model.ExchangeCategory = EyouSoft.Model.CommunityStructure.ExchangeCategory.求;
model.ExchangeTag = EyouSoft.Model.CommunityStructure.ExchangeTag.无;
model.ExchangeText = content.Value;
model.IsCheck = IsCompanyCheck;
model.IssueTime = DateTime.Now;
model.IsTop = false;
model.OperatorId = SiteUserInfo.ID;
model.OperatorMQ = SiteUserInfo.ContactInfo.MQ;
model.OperatorName = SiteUserInfo.ContactInfo.ContactName;
model.ProvinceId = SiteUserInfo.ProvinceId;
model.AttatchPath = "";
model.TopicClassID = EyouSoft.Model.CommunityStructure.ExchangeType.业MQ;
bool Result = EyouSoft.BLL.CommunityStructure.ExchangeList.CreateInstance().AddExchangeList(model, ProvinceIds == null ? null : ProvinceIds.ToArray());
if (Result)
{
content.Value = "";
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "document.getElementById(\"showMsg\").innerHTML=\"发布成功\";");
}
else
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "document.getElementById(\"showMsg\").innerHTML=\"发布失败\";");
}
}
/// <summary>
/// 根据同业中心ID获取同业中心实体列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <returns>同业中心实体列表</returns>
public IList <Model.MQStructure.IMSuperCluster> GetList(int pageSize, int pageIndex, ref int recordCount)
{
var lst = new List <EyouSoft.Model.MQStructure.IMSuperCluster>(); // 同业中心实体列表
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount
, "tbl_SuperCluster", "ID", "ID,Num,Title,CASE SelectType WHEN 1 THEN (SELECT D.ProvinceName,(SELECT COUNT(DISTINCT A.user_id) FROM tbl_SuperClusterUser AS A JOIN tbl_CompanyUser AS B ON B.Id = A.user_id AND B.ProvinceId = C.items AND B.IsEnable = 1) AS CountNum FROM (SELECT items FROM dbo.fn_Split(SelectValue ,',')) AS C INNER JOIN tbl_SysProvince AS D ON D.ID = C.items FOR XML PATH('Value'),ROOT('Values')) WHEN 2 THEN (SELECT '其他成员' AS ProvinceName,(SELECT COUNT(*) FROM (SELECT items FROM dbo.fn_Split(SelectValue ,',')) AS AA) AS CountNum FOR XML PATH('Value'),ROOT('Values')) END AS CountValue,master,PassWord,Opertor,OperateTime"
, String.Empty
, "Num ASC,OperateTime DESC"))
{
while (dr.Read())
{
// 成员构成初期化
var strCountValue = string.Empty;
if (!dr.IsDBNull(dr.GetOrdinal("CountValue")))
{
// 实例化xml
var xml = new XmlDocument();
// 读取xml文件
xml.LoadXml(dr.GetString(dr.GetOrdinal("CountValue")));
foreach (XmlNode nodeP in xml.ChildNodes[0].ChildNodes)
{
var strTmp = string.Empty;
foreach (XmlNode nodeT in nodeP.ChildNodes)
{
switch (nodeT.Name)
{
case "ProvinceName":
strTmp = nodeT.InnerText + "（<b style='color: red;'>{0}</b>人）,";
break;
case "CountNum":
strTmp = string.Format(strTmp, nodeT.InnerText);
break;
}
}
strCountValue = strCountValue + strTmp;
}
}
// 公告信息实体
var model = new EyouSoft.Model.MQStructure.IMSuperCluster
{
// 同业中心ID
Id = dr.GetInt32(dr.GetOrdinal("ID")),
// 名称
Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? string.Empty : dr.GetString(dr.GetOrdinal("Title")),
// 序号
Num = dr.IsDBNull(dr.GetOrdinal("Num")) ? 0 : dr.GetInt32(dr.GetOrdinal("Num")),
// 成员构成
CountValue = strCountValue.TrimEnd(','),
// 总管理员
Master = dr.IsDBNull(dr.GetOrdinal("Master")) ? 0 : dr.GetInt32(dr.GetOrdinal("Master")),
// 密码
PassWord = dr.IsDBNull(dr.GetOrdinal("PassWord")) ? string.Empty : dr.GetString(dr.GetOrdinal("PassWord")),
// 发布人
Opertor = dr.IsDBNull(dr.GetOrdinal("Opertor")) ? string.Empty : dr.GetString(dr.GetOrdinal("Opertor")),
// 发布时间
OperateTime = dr.IsDBNull(dr.GetOrdinal("OperateTime")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("OperateTime"))
};
// 追加到同业中心实体列表
lst.Add(model);
}
}
// 返回同业中心实体列表
return(lst);
}
