public List<groupCaller> QueryCallidById(groupCaller gc) { SqlParameter[] paras = new SqlParameter[]{ new SqlParameter("@groupId",gc.groupId) }; return _access.getDataTableForObj<groupCaller>("sp_GroupCaller_QueryCallidById_xuanzi0404h", paras); }
public int Delete(groupCaller gc) { SqlParameter[] paras = new SqlParameter[]{ new SqlParameter("@groupId",gc.groupId) }; return _access.execCommand("sp_GroupCaller_Delete_xuanzi0404h", paras); }
public int Delete(groupCaller gc) { try { return _gcDao.Delete(gc); } catch (Exception ex) { throw new Exception("GroupCallerMgr-->Delete-->" + ex.Message, ex); } }
public int Save(groupCaller gc) { try { return _gcDao.Save(gc); } catch (Exception ex) { throw new Exception("GroupCallerMgr-->SingleCompareSave-->" + ex.Message, ex); } }
public string QueryCallidById(groupCaller gc) { try { List<groupCaller> gcResult = _gcDao.QueryCallidById(gc); StringBuilder stb = new StringBuilder(); foreach (groupCaller gcs in gcResult) { stb.Append(string.Format("{0}", gcs.callid)); stb.Append(","); } return stb.ToString().Length > 0 ? stb.ToString().Substring(0, stb.ToString().Length - 1) : ""; } catch (Exception ex) { throw new Exception("GroupCallerMgr-->QueryCallidById-->" + ex.Message, ex); } }
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 int Delete(groupCaller gc) { return _access.execCommand("delete from t_groupcaller where groupid=" + gc.groupId); }
public int Save(groupCaller gc) { return _access.execCommand("insert into t_groupcaller(groupid,callid) values('"+gc.groupId+"','"+gc.callid+"')"); }
public List<groupCaller> QueryCallidById(groupCaller gc) { return _access.getDataTableForObj<groupCaller>("select callid from t_groupcaller where groupid = " + gc.groupId); }