/// <summary> /// 导出数据 /// </summary> /// <returns></returns> public void ExportData() { string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"]; HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); ISheet sheet = book.CreateSheet("sheet1"); IRow row1 = sheet.CreateRow(0); row1.CreateCell(0).SetCellValue("账号"); row1.CreateCell(1).SetCellValue("密码"); row1.CreateCell(2).SetCellValue("姓名"); Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)); IList <QTProductUserModel> qTProductUsers = QTProductUserService.ServiceHelper.LoadWithPageInfinity("GQT.QT.ALLProductUsers", dicWhere).Results; //List<BudgetAccountsModel> models = budgetAccounts.ToList(); for (int i = 0; i < qTProductUsers.Count; i++) { QTProductUserModel model = qTProductUsers[i]; IRow row = sheet.CreateRow(i + 1); row.CreateCell(0).SetCellValue(model.ProductUserCode); row.CreateCell(1).SetCellValue(model.ProductUserPwd); row.CreateCell(2).SetCellValue(model.ProductUserName); } System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff"))); Response.BinaryWrite(ms.ToArray()); book = null; ms.Close(); ms.Dispose(); }
/// <summary> /// 获取产品用户通过产品标识和G6账号 /// </summary> /// <returns></returns> public string getUserByProduct() { string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"]; string UserNo = System.Web.HttpContext.Current.Request.Params["UserNo"]; QTProductUserModel qTProductUser = QTProductUserService.getUserByProduct(ProductBZ, UserNo); return(DataConverterHelper.ResponseResultToJson(qTProductUser)); }
/// <summary> /// 不删除设置对应关系 /// </summary> /// <param name="ProductBZ"></param> /// <returns></returns> public CommonResult SaveByProductNoDelete(string ProductBZ) { CommonResult result = new CommonResult(); try { Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <EnumUserStatus> .Eq("Status", EnumUserStatus.Activate)); //var Users = UserFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllUsers", dic2); var Users = UserFacade.Find(dic).Data; for (var i = 0; i < Users.Count; i++) { User2Model user = Users[i]; Dictionary <string, object> dic2 = new Dictionary <string, object>(); new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("Fg3userno", user.UserNo)); var IfDYGX = base.Find(dic2).Data; Dictionary <string, object> dic3 = new Dictionary <string, object>(); new CreateCriteria(dic3).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("ProductUserCode", user.UserNo)); var IfUser = QTProductUserFacade.Find(dic3).Data; if (IfDYGX.Count == 0 && IfUser.Count > 0) { QTProductUserModel qTProductUserModel = IfUser[0]; QTProductUserDygxModel qTProductUserDygxModel = new QTProductUserDygxModel { ProductBZ = ProductBZ, ProductUserCode = user.UserNo, ProductPhid = qTProductUserModel.ProductPhid, ProductUserPhid = qTProductUserModel.PhId, ProductUserName = qTProductUserModel.ProductUserName, ProductUserPwd = qTProductUserModel.ProductUserPwd, Fg3userPhid = user.PhId, Fg3userno = user.UserNo, Fg3username = user.UserName, PersistentState = PersistentState.Added }; base.Save <Int64>(qTProductUserDygxModel, ""); } } } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "同步失败!"; } return(result); }
/// <summary> /// 保存 /// </summary> /// <param name="User"></param> /// <param name="adddata"></param> /// <param name="deletedata"></param> /// <returns></returns> public CommonResult Save2(User2Model User, List <QTProductUserDygxModel> adddata, List <string> deletedata) { CommonResult result = new CommonResult(); try { if (adddata != null && adddata.Count > 0) { for (var i = 0; i < adddata.Count; i++) { QTProductUserDygxModel qTProductUserDygxModel = adddata[i]; //Dictionary<string, object> dic1 = new Dictionary<string, object>(); //new CreateCriteria(dic1).Add(ORMRestrictions<string>.Eq("ProductBZ", qTProductUserDygxModel.ProductBZ)); //QTProductModel qTProductModel = QTProductFacade.Find(dic1).Data[0]; //qTProductUserDygxModel.ProductPhid = qTProductModel.PhId; Dictionary <string, object> dic2 = new Dictionary <string, object>(); new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", qTProductUserDygxModel.ProductBZ)) .Add(ORMRestrictions <string> .Eq("ProductUserCode", qTProductUserDygxModel.ProductUserCode)); QTProductUserModel qTProductUserModel = QTProductUserFacade.Find(dic2).Data[0]; if (qTProductUserDygxModel.PhId == 0) { qTProductUserDygxModel.ProductPhid = qTProductUserModel.ProductPhid; qTProductUserDygxModel.ProductUserPhid = qTProductUserModel.PhId; qTProductUserDygxModel.ProductUserName = qTProductUserModel.ProductUserName; qTProductUserDygxModel.ProductUserPwd = qTProductUserModel.ProductUserPwd; qTProductUserDygxModel.Fg3userPhid = User.PhId; qTProductUserDygxModel.Fg3userno = User.UserNo; qTProductUserDygxModel.Fg3username = User.UserName; qTProductUserDygxModel.PersistentState = PersistentState.Added; base.Save <Int64>(qTProductUserDygxModel, ""); } else { QTProductUserDygxModel qTProductUserDygxModel2 = base.Find(qTProductUserDygxModel.PhId).Data; qTProductUserDygxModel2.ProductBZ = qTProductUserDygxModel.ProductBZ; qTProductUserDygxModel2.ProductUserCode = qTProductUserDygxModel.ProductUserCode; qTProductUserDygxModel2.ProductPhid = qTProductUserModel.ProductPhid; qTProductUserDygxModel2.ProductUserPhid = qTProductUserModel.PhId; qTProductUserDygxModel2.ProductUserName = qTProductUserModel.ProductUserName; qTProductUserDygxModel2.ProductUserPwd = qTProductUserModel.ProductUserPwd; qTProductUserDygxModel2.Fg3userPhid = User.PhId; qTProductUserDygxModel2.Fg3userno = User.UserNo; qTProductUserDygxModel2.Fg3username = User.UserName; qTProductUserDygxModel2.PersistentState = PersistentState.Modified; base.Save <Int64>(qTProductUserDygxModel2, ""); } } } if (deletedata != null && deletedata.Count > 0) { for (var j = 0; j < deletedata.Count; j++) { base.Delete(deletedata[j]); } } } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "保存失败!"; } return(result); }