public string QueryPm()
{
gcMgr = new GroupCallerMgr(connectionString);
paraMgr = new ParameterMgr(connectionString);
fgMgr = new FgroupMgr(connectionString);
muMgr = new ManageUserMgr(connectionString);
groupCaller gc = new groupCaller();
Fgroup fg = new Fgroup();
string json = string.Empty;
try
{
List<Parametersrc> parstore = paraMgr.QueryUsed(new Parametersrc { ParameterType = "vendor_pm" }).ToList();
if (parstore.Count != 0)
{
fg.groupCode = parstore[0].ParameterCode;
// fg.groupName = parstore[0].parameterName;//parameterName是可變的不可依此查詢 edit by shuangshuang0420j 2015.07.28 09:48
Fgroup pmfg = fgMgr.GetSingle(fg);
if (pmfg != null)
{
gc.groupId = pmfg.rowid;
string pm = gcMgr.QueryCallidById(gc);
StringBuilder stb = new StringBuilder("");
stb.Append("{");
stb.Append("success:true,item:[");
//stb.Append("{");
//stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", 0, "請選擇");
//stb.Append("}");
string nameStr = string.Empty;
string[] pmar = pm.Split(',').ToArray();
foreach (var item in pmar)
{
int total = 0;
ManageUserQuery mu = muMgr.GetManageUserList(new ManageUserQuery { user_email = item, search_status = "-1" }, out total).FirstOrDefault();
if (total == 1 && mu != null)
{
stb.Append("{");
stb.AppendFormat("\"userId\":\"{0}\",\"userName\":\"{1}\"", mu.user_id, mu.user_username);
stb.Append("}");
}
}
stb.Append("]}");
json = stb.ToString().Replace("}{", "},{");
}
//else
//{
// json = "{success:false,error:1}";
//}
}
//else
//{
// json = "{success:false,error:0}";
//}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "[]";
}
return json;
}
public string QueryCallidById()
{
gcMgr = new GroupCallerMgr(mySqlConnectionString);
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Form["groupId"]))
{
gc.groupId = Convert.ToInt32(Request.Form["groupId"]);
}
json = gcMgr.QueryCallidById(gc);
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "[]";
}
return json;
}