public string QueryCallid() { fgMgr = new FgroupMgr(mySqlConnectionString); string json = string.Empty; try { json = fgMgr.QueryCallid(); } 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 HttpResponseBase QueryProduct() { string json = "{success:true,data:[]}"; try { Product product = null; Caller caller = Session["caller"] as Caller; if (!string.IsNullOrEmpty(Request.Form["ProductId"])) { uint product_id = 0; if (uint.TryParse(Request.Form["ProductId"], out product_id)) { _productMgr = new ProductMgr(connectionString); product = _productMgr.Query(new Product { Product_Id = product_id }).FirstOrDefault(); if (product.Product_alt == "") { product.Product_alt = product.Product_Name; }//add by wwei0216w 2015/4/15 //如果商品說明為空則將商品名稱賦予product_alt } } else//查詢temp表 { _productTempMgr = new ProductTempMgr(connectionString); int writerId = caller.user_id; ProductTemp query = new ProductTemp { Writer_Id = writerId, Combo_Type = COMBO_TYPE }; if (!string.IsNullOrEmpty(Request.Form["OldProductId"])) { query.Product_Id = Request.Form["OldProductId"]; } product = _productTempMgr.GetProTemp(query); if (product.Product_alt == "") { product.Product_alt = product.Product_Name; }//add by wwei0216w 2015/4/15 //如果商品說明為空則將商品名稱賦予product_alt } if (product != null) { if (!string.IsNullOrEmpty(product.Product_Image)) { product.Product_Image = imgServerPath + prodPath + GetDetailFolder(product.Product_Image) + product.Product_Image; } else { product.Product_Image = imgServerPath + "/product/nopic_150.jpg"; } if (!string.IsNullOrEmpty(product.Mobile_Image)) //edit by wwei0216w 2015/3/18 添加關於手機說明圖的操作 { prodPath = prodMobile640; //add by wwei0216w 2015/4/1 添加原因:手機圖片要放在640*640路徑下 product.Mobile_Image = imgServerPath + prodPath + GetDetailFolder(product.Mobile_Image) + product.Mobile_Image; } else { product.Mobile_Image = imgServerPath + "/product/nopic_150.jpg"; //product.Mobile_Image = imgServerPath + "/Content/img/click_up_img.jpg"; } #region 庫存是否可編輯 //edit by xiangwang 0413w 2014/10/09 if (Request.UrlReferrer.AbsolutePath == "/Product/productStock") { IFgroupImplMgr _fgroupMgr = new FgroupMgr(connectionString); product.IsEdit = _fgroupMgr.QueryStockPrerogative(caller.user_email, Server.MapPath(xmlPath)); //if (caller.user_email == "*****@*****.**" || caller.user_email == "*****@*****.**") //{ // product.IsEdit = true; //} } #endregion } json = "{success:true,data:" + JsonConvert.SerializeObject(product) + "}"; } 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 = "[]"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int GetVebdorPMGroup()//add by mengjuan0826j 2015/6/8 處理供應商pm設定 { paraMgr = new ParameterMgr(mySqlConnectionString); fgMgr = new FgroupMgr(mySqlConnectionString); List<Parametersrc> parstore = paraMgr.QueryUsed(new Parametersrc { ParameterType = "vendor_pm" }).ToList();//獲取vendor_pm 群組的設定 群組名稱和群組編碼 int group_id = 0; if (parstore.Count != 0) { fg.groupCode = parstore[0].ParameterCode; fg.groupName = parstore[0].parameterName; Fgroup pmfg = fgMgr.GetSingle(fg);//根據群組名稱找到group_id if (pmfg != null) { group_id = pmfg.rowid; } } return group_id; }
public void ExportGroupLimit() { try { fgMgr = new FgroupMgr(mySqlConnectionString); List<string> NameList = new List<string>(); List<DataTable> Elist = new List<DataTable>(); List<bool> comName = new List<bool>(); DataTable _dt = fgMgr.GetFgroupList(); for (int i = 0; i < _dt.Rows.Count; i++)//循環各個群組 { DataTable _dtone = new DataTable(); _dtone.Columns.Add("群組人員", typeof(String)); _dtone.Columns.Add("功能模塊", typeof(String)); _dtone.Columns.Add("基本功能", typeof(String)); _dtone.Columns.Add("功能操作", typeof(String)); #region 獲取信息 //獲取某個群組下的所有用戶 DataTable _dtUsers = fgMgr.GetUsersByGroupId(Convert.ToInt32(_dt.Rows[i]["rowid"])); //獲取某個群組下的所有權限 DataTable _dtAuthorty = fgMgr.GetAuthorityByGroupId(Convert.ToInt32(_dt.Rows[i]["rowid"])); int usercount = _dtUsers.Rows.Count; int authorty = _dtAuthorty.Rows.Count; if (authorty >= usercount)//如果權限的行數大於群組中的個數 { for (int z = 0; z < _dtAuthorty.Rows.Count; z++) { DataRow _tbRow = _dtone.NewRow(); try { _tbRow[0] = _dtUsers.Rows[z]["user_username"].ToString().Trim(); } catch (Exception ex) { _tbRow[0] = ""; } if (z == 0) { thispname = _dtAuthorty.Rows[0]["pname"].ToString(); thiscname = _dtAuthorty.Rows[0]["cname"].ToString(); //_tbRow[1] = _dtAuthorty.Rows[z]["pname"] + " " + (_dtAuthorty.Rows[z]["tpname"].ToString() == "" ? "X" : "O"); _tbRow[1] = _dtAuthorty.Rows[z]["pname"]; _tbRow[2] = _dtAuthorty.Rows[z]["cname"] + " " + (_dtAuthorty.Rows[z]["tcname"].ToString() == "" ? "X" : "O"); } else { if (thispname == _dtAuthorty.Rows[z]["pname"].ToString())//如果相同 { _tbRow[1] = ""; } else { //_tbRow[1] = _dtAuthorty.Rows[z]["pname"] + " " + (_dtAuthorty.Rows[z]["tpname"].ToString() == "" ? "X" : "O"); _tbRow[1] = _dtAuthorty.Rows[z]["pname"]; thispname = _dtAuthorty.Rows[z]["pname"].ToString(); } if (thiscname == _dtAuthorty.Rows[z]["cname"].ToString()) { _tbRow[2] = ""; } else { _tbRow[2] = _dtAuthorty.Rows[z]["cname"] + " " + (_dtAuthorty.Rows[z]["tcname"].ToString() == "" ? "X" : "O"); thiscname = _dtAuthorty.Rows[z]["cname"].ToString(); } } if (_dtAuthorty.Rows[z]["tname"].ToString() == "") { _tbRow[3] = ""; } else { if (_dtAuthorty.Rows[z]["ttname"].ToString() == "" || _dtAuthorty.Rows[z]["functionId"].ToString() == "") { _tbRow[3] = _dtAuthorty.Rows[z]["tname"] + " " + "X"; } else { _tbRow[3] = _dtAuthorty.Rows[z]["tname"] + " " + "O"; } } _dtone.Rows.Add(_tbRow); } } else { for (int j = 0; j < _dtUsers.Rows.Count; j++) { DataRow _tbRow = _dtone.NewRow(); _tbRow[0] = _dtUsers.Rows[j]["user_username"].ToString().Trim(); if (j == 0) { thispname = _dtAuthorty.Rows[0]["pname"].ToString(); thiscname = _dtAuthorty.Rows[0]["cname"].ToString(); //_tbRow[1] = _dtAuthorty.Rows[0]["pname"] + " " + (_dtAuthorty.Rows[j]["tpname"].ToString() == "" ? "X" : "O"); _tbRow[1] = _dtAuthorty.Rows[0]["pname"]; _tbRow[2] = _dtAuthorty.Rows[0]["cname"] + " " + (_dtAuthorty.Rows[j]["tcname"].ToString() == "" ? "X" : "O"); if (_dtAuthorty.Rows[0]["tname"].ToString() == "") { _tbRow[3] = ""; } else { if (_dtAuthorty.Rows[0]["ttname"].ToString() == "" || _dtAuthorty.Rows[0]["functionId"].ToString() == "") { _tbRow[3] = _dtAuthorty.Rows[0]["tname"] + " " + "X"; } else { _tbRow[3] = _dtAuthorty.Rows[0]["tname"] + " " + "O"; } } } else { try { if (thispname == _dtAuthorty.Rows[j]["pname"].ToString()) { _tbRow[1] = ""; } else { // _tbRow[1] = _dtAuthorty.Rows[j]["pname"] + " " + (_dtAuthorty.Rows[j]["tpname"].ToString() == "" ? "X" : "O"); _tbRow[1] = _dtAuthorty.Rows[j]["pname"]; thispname = _dtAuthorty.Rows[j]["pname"].ToString(); } if (thiscname == _dtAuthorty.Rows[j]["cname"].ToString()) { _tbRow[2] = ""; } else { _tbRow[2] = _dtAuthorty.Rows[j]["cname"] + " " + (_dtAuthorty.Rows[j]["tcname"].ToString() == "" ? "X" : "O"); thiscname = _dtAuthorty.Rows[j]["cname"].ToString(); } if (_dtAuthorty.Rows[j]["tname"].ToString() == "") { _tbRow[3] = ""; } else { if (_dtAuthorty.Rows[j]["ttname"].ToString() == "" || _dtAuthorty.Rows[j]["functionId"].ToString() == "") { _tbRow[3] = _dtAuthorty.Rows[j]["tname"] + " " + "X"; } else { _tbRow[3] = _dtAuthorty.Rows[j]["tname"] + " " + "O"; } } } catch (Exception ex) { _tbRow[1] = ""; _tbRow[2] = ""; _tbRow[3] = ""; } } _dtone.Rows.Add(_tbRow); } } #endregion comName.Add(true); Elist.Add(_dtone); NameList.Add(_dt.Rows[i]["groupName"].ToString() + "群組"); thispname = ""; thiscname = ""; } string fileName = "群組權限信息" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; MemoryStream ms = ExcelHelperXhf.ExportDTNoColumnsBySdy(Elist, NameList, comName); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } 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); } }
/// <summary> /// 删除 /// </summary> /// <returns></returns> public HttpResponseBase Delete() { fgMgr = new FgroupMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["rowID"])) { string rowIDs = Request.Form["rowID"]; if (rowIDs.IndexOf("|") != -1) { foreach (string id in rowIDs.Split('|')) { if (!string.IsNullOrEmpty(id)) { fg.rowid = Int32.Parse(id); fgMgr.Delete(fg); } } json = "{success:true,msg:\"删除成功\"}"; } else { json = "{success:true,msg:\"删除失败\"}"; } } else { json = "{success:true,msg:\"删除失败\"}"; } } 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 = "{success:true,msg:\"删除失败\"}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 修改 /// </summary> /// <returns></returns> public HttpResponseBase Edit() { fgMgr = new FgroupMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["rowid"])) { fg.rowid = Convert.ToInt32(Request.Form["rowid"]); } if (!string.IsNullOrEmpty(Request.Form["groupName"])) { fg.groupName = Request.Form["groupName"]; } if (!string.IsNullOrEmpty(Request.Form["groupCode"])) { fg.groupCode = Request.Form["groupCode"]; } if (!string.IsNullOrEmpty(Request.Form["remark"])) { fg.remark = Request.Form["remark"]; } fg.kuser = ""; int num = fgMgr.Save(fg); if (num == -1) { json = "{success:true,msg:\"群組名稱 或 群組編號已存在。\"}"; } else if (num == 2) { json = "{success:true,msg:\"修改成功\"}"; } else { json = "{success:true,msg:\"修改失败\"}"; } } 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 = "{success:true,msg:\"修改失败\"}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }