public int Save(Fgroup fg)
{
fg.Replace4MySQL();
if (fg.rowid == 0)
{
if (_access.getDataTable(string.Format("select rowid from t_fgroup where (groupname='{0}' or groupcode='{1}')", fg.groupName, fg.groupCode)).Rows.Count > 0)
{
return -1;//群組名稱或群組編碼已存在
}
else
{
_access.execCommand(string.Format("insert into t_fgroup(groupname,groupcode,remark,kuser,kdate) values('{0}','{1}','{2}','{3}',now())", fg.groupName, fg.groupCode, fg.remark, fg.kuser));
return 1;//新增成功
}
}
else
{
if (_access.getDataTable(string.Format("select rowid from t_fgroup where (groupname='{1}' or groupcode='{2}') and rowid <> {0}", fg.rowid, fg.groupName, fg.groupCode)).Rows.Count > 0)
{
return -1;//群組名稱或群組編碼已存在
}
else
{
_access.execCommand(string.Format("update t_fgroup set groupname='{1}',groupcode='{2}',remark='{3}' where rowid={0}", fg.rowid, fg.groupName, fg.groupCode, fg.remark));
return 2;//修改成功
}
}
}
public int Delete(Fgroup fg)
{
fg.Replace4MySQL();
SqlParameter[] paras = new SqlParameter[]{
new SqlParameter("@rowid",fg.rowid)
};
return _access.execCommand("sp_Fgroup_Delete_xuanzi0404h", paras);
}
public int Delete(Fgroup fg)
{
try
{
return _fgDao.Delete(fg);
}
catch (Exception ex)
{
throw new Exception("FgroupMgr-->Delete-->" + ex.Message, ex);
}
}
public int Delete(Fgroup fg)
{
fg.Replace4MySQL();
strSql = string.Format(@"delete from t_groupcaller where groupid={0}", fg.rowid);
_access.execCommand(strSql);
strSql = string.Format(@"delete from t_functiongroup where groupid={0}", fg.rowid);
_access.execCommand(strSql);
strSql = string.Format(@"delete from t_fgroup where rowid={0}", fg.rowid);
_access.execCommand(strSql);
return 1;
}
public int Save(Fgroup fg)
{
fg.Replace4MySQL();
SqlParameter[] paras = new SqlParameter[6];
paras[0] = new SqlParameter("@rowid", fg.rowid);
paras[1] = new SqlParameter("@groupName", fg.groupName);
paras[2] = new SqlParameter("@groupCode", fg.groupCode);
paras[3] = new SqlParameter("@remark", fg.remark);
paras[4] = new SqlParameter("@kuser", fg.kuser);
paras[5] = new SqlParameter();
paras[5].Direction = ParameterDirection.ReturnValue;
_access.execCommand("sp_Fgroup_Save_xuanzi0404h", paras);
return Int32.Parse(paras[5].Value.ToString());
}
public Fgroup GetSingle(Fgroup model) //add by mengjuan0826j 獲取單個model 根據groupname和groupcode
{
throw new NotImplementedException();
}
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 Fgroup GetSingle(Fgroup model)
{
try
{
return _fgDao.GetSingle(model);
}
catch (Exception ex)
{
throw new Exception("FgroupMgr-->GetSingle-->" + ex.Message, ex);
}
}
public Fgroup GetSingle(Fgroup model)//add by mengjuan0826j 獲取單個model 根據groupname和groupcode
{
model.Replace4MySQL();
StringBuilder strSql = new StringBuilder();
try
{
strSql.Append("select rowid,groupName,groupCode,remark,kuser,kdate ");
strSql.Append(" from t_fgroup ");
strSql.Append(" where 1=1 ");
//if (!string.IsNullOrEmpty(model.groupName))
//{
// strSql.AppendFormat(" and groupName='{0}'", model.groupName);
//}
if (!string.IsNullOrEmpty(model.groupCode))
{
strSql.AppendFormat(" and groupCode='{0}'", model.groupCode);
}
return _access.getSinggleObj<Fgroup>(strSql.ToString());
}
catch (Exception ex)
{
throw new Exception(" FgroupDao-->GetSingle-->" + ex.Message + strSql.ToString(), ex);
}
}
