/// <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);
}
