/**************************************** ***生成器版本:V1.0.1.31494 ***生成时间:2013-04-06 17:31:07 ***公司:山西ICat Studio有限公司 ***友情提示:以下代码为生成器自动生成,可做参照修改之用; *** 如需有其他业务要求,可在region外添加新方法; *** 如发现任何编译和运行时错误,请联系QQ:330669393。 *****************************************/ #region public members methods /// <summary> /// 根据条件筛选所有ApplicationUser指定页码的数据(分页型) /// </summary> /// <param name="applicationuser">实体对象</param> /// <param name="pageparams">分页对象</param> /// <returns></returns> public string GetJsonByPage(EntityApplicationUser applicationuser, PageParams pageparams) { #region int totalCount = 0; DataSet applicationuserdata = this.GetData(applicationuser, pageparams, out totalCount); return(base.GetJson(applicationuserdata, totalCount)); #endregion }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityApplicationUser applicationuser) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(applicationuser, queryparams, out totalcount); ExportExcel exportexcel = new ExportExcel(filename, ds, grid); exportexcel.Output(); #endregion }
/// <summary> /// 编辑applicationuserdata数据集中指定的行数据 /// </summary> /// <param name="applicationuserdata">数据集对象</param> /// <param name="applicationuser">实体对象</param> public void EditRow(ref ApplicationUserData applicationuserdata, EntityApplicationUser applicationuser) { #region if (applicationuserdata.Tables[0].Rows.Count <= 0) { applicationuserdata = this.getData(applicationuser.userid); } DataRow dr = applicationuserdata.Tables[0].Rows.Find(new object[1] { applicationuser.userid }); applicationuserdata.Assign(dr, ApplicationUserData.userid, applicationuser.userid); applicationuserdata.Assign(dr, ApplicationUserData.Username, applicationuser.Username); applicationuserdata.Assign(dr, ApplicationUserData.roleId, applicationuser.roleId); applicationuserdata.Assign(dr, ApplicationUserData.organizationId, applicationuser.organizationId); applicationuserdata.Assign(dr, ApplicationUserData.fullName, applicationuser.fullName); //编辑的时候不动人家密码 //applicationuserdata.Assign(dr, ApplicationUserData.passWord, Password.ToMD5(applicationuser.passWord)); applicationuserdata.Assign(dr, ApplicationUserData.telephone, applicationuser.telephone); applicationuserdata.Assign(dr, ApplicationUserData.isTotal, applicationuser.isTotal); applicationuserdata.Assign(dr, ApplicationUserData.email, applicationuser.email); applicationuserdata.Assign(dr, ApplicationUserData.usable, applicationuser.usable); applicationuserdata.Assign(dr, ApplicationUserData.loginTimes, applicationuser.loginTimes); applicationuserdata.Assign(dr, ApplicationUserData.lastLoginTime, applicationuser.lastLoginTime); applicationuserdata.Assign(dr, ApplicationUserData.writeTime, applicationuser.writeTime); applicationuserdata.Assign(dr, ApplicationUserData.writeUser, applicationuser.writeUser); applicationuserdata.Assign(dr, ApplicationUserData.writeIp, applicationuser.writeIp); applicationuserdata.Assign(dr, ApplicationUserData.isMarry, applicationuser.isMarry); applicationuserdata.Assign(dr, ApplicationUserData.birthday, applicationuser.birthday); applicationuserdata.Assign(dr, ApplicationUserData.household, applicationuser.household); applicationuserdata.Assign(dr, ApplicationUserData.oldHome, applicationuser.oldHome); applicationuserdata.Assign(dr, ApplicationUserData.nowLiveHome, applicationuser.nowLiveHome); applicationuserdata.Assign(dr, ApplicationUserData.intoCompanyDate, applicationuser.intoCompanyDate); applicationuserdata.Assign(dr, ApplicationUserData.workTotalYear, applicationuser.workTotalYear); applicationuserdata.Assign(dr, ApplicationUserData.still, applicationuser.still); applicationuserdata.Assign(dr, ApplicationUserData.maxEducation, applicationuser.maxEducation); applicationuserdata.Assign(dr, ApplicationUserData.maxEduCollege, applicationuser.maxEduCollege); applicationuserdata.Assign(dr, ApplicationUserData.maxEduLeaveTime, applicationuser.maxEduLeaveTime); applicationuserdata.Assign(dr, ApplicationUserData.workExperiences, applicationuser.workExperiences); applicationuserdata.Assign(dr, ApplicationUserData.studyExperiences, applicationuser.studyExperiences); applicationuserdata.Assign(dr, ApplicationUserData.photoUrl, applicationuser.photoUrl); #endregion }
/// <summary> /// 根据条件筛选所有ApplicationUser指定页码的数据(分页型) /// </summary> /// <param name="applicationuser">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public ApplicationUserData GetData(EntityApplicationUser applicationuser, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(ApplicationUserData.userid, EnumSqlType.sqlint, EnumCondition.Equal, applicationuser.userid); querybusinessparams.Add(ApplicationUserData.Username, EnumSqlType.nvarchar, EnumCondition.LikeBoth, applicationuser.Username); querybusinessparams.Add(ApplicationUserData.roleId, EnumSqlType.tinyint, EnumCondition.Equal, applicationuser.roleId); querybusinessparams.Add(ApplicationUserData.organizationId, EnumSqlType.sqlint, EnumCondition.Equal, applicationuser.organizationId); querybusinessparams.Add(ApplicationUserData.fullName, EnumSqlType.nvarchar, EnumCondition.LikeBoth, applicationuser.fullName); querybusinessparams.Add(ApplicationUserData.passWord, EnumSqlType.nvarchar, EnumCondition.Equal, applicationuser.passWord); querybusinessparams.Add(ApplicationUserData.telephone, EnumSqlType.nvarchar, EnumCondition.Equal, applicationuser.telephone); querybusinessparams.Add(ApplicationUserData.isTotal, EnumSqlType.bit, EnumCondition.Equal, applicationuser.isTotal); querybusinessparams.Add(ApplicationUserData.email, EnumSqlType.nvarchar, EnumCondition.LikeBoth, applicationuser.email); querybusinessparams.Add(ApplicationUserData.usable, EnumSqlType.bit, EnumCondition.Equal, applicationuser.usable); querybusinessparams.Add(ApplicationUserData.loginTimes, EnumSqlType.sqlint, EnumCondition.Equal, applicationuser.loginTimes); querybusinessparams.Add(ApplicationUserData.lastLoginTime, EnumSqlType.datetime, EnumCondition.Equal, applicationuser.lastLoginTime); querybusinessparams.Add(ApplicationUserData.writeTime, EnumSqlType.datetime, EnumCondition.Equal, applicationuser.writeTime); querybusinessparams.Add(ApplicationUserData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, applicationuser.writeUser); querybusinessparams.Add(ApplicationUserData.writeIp, EnumSqlType.nvarchar, EnumCondition.Equal, applicationuser.writeIp); ApplicationUserData applicationuserdata = new ApplicationUserData(); totalCount = this._applicationuserclass.SelectApplicationUserByPage(applicationuserdata, querybusinessparams); return(applicationuserdata); #endregion }
/// <summary> /// 添加ApplicationUser表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="applicationuserdata">数据集对象</param> /// <param name="applicationuser">实体对象</param> public void AddRow(ref ApplicationUserData applicationuserdata, EntityApplicationUser applicationuser) { #region applicationuser.userid = _applicationuserclass.GetMaxAddOne(applicationuserdata).ToString(); DataRow dr = applicationuserdata.Tables[0].NewRow(); applicationuserdata.Assign(dr, ApplicationUserData.userid, applicationuser.userid); applicationuserdata.Assign(dr, ApplicationUserData.Username, applicationuser.Username); applicationuserdata.Assign(dr, ApplicationUserData.roleId, applicationuser.roleId); applicationuserdata.Assign(dr, ApplicationUserData.organizationId, applicationuser.organizationId); applicationuserdata.Assign(dr, ApplicationUserData.fullName, applicationuser.fullName); applicationuserdata.Assign(dr, ApplicationUserData.passWord, Password.ToMD5(applicationuser.passWord)); applicationuserdata.Assign(dr, ApplicationUserData.telephone, applicationuser.telephone); applicationuserdata.Assign(dr, ApplicationUserData.isTotal, applicationuser.isTotal); applicationuserdata.Assign(dr, ApplicationUserData.email, applicationuser.email); applicationuserdata.Assign(dr, ApplicationUserData.usable, applicationuser.usable); applicationuserdata.Assign(dr, ApplicationUserData.loginTimes, applicationuser.loginTimes); applicationuserdata.Assign(dr, ApplicationUserData.lastLoginTime, applicationuser.lastLoginTime); applicationuserdata.Assign(dr, ApplicationUserData.writeTime, applicationuser.writeTime); applicationuserdata.Assign(dr, ApplicationUserData.writeUser, applicationuser.writeUser); applicationuserdata.Assign(dr, ApplicationUserData.writeIp, applicationuser.writeIp); applicationuserdata.Assign(dr, ApplicationUserData.isMarry, applicationuser.isMarry); applicationuserdata.Assign(dr, ApplicationUserData.birthday, applicationuser.birthday); applicationuserdata.Assign(dr, ApplicationUserData.household, applicationuser.household); applicationuserdata.Assign(dr, ApplicationUserData.oldHome, applicationuser.oldHome); applicationuserdata.Assign(dr, ApplicationUserData.nowLiveHome, applicationuser.nowLiveHome); applicationuserdata.Assign(dr, ApplicationUserData.intoCompanyDate, applicationuser.intoCompanyDate); applicationuserdata.Assign(dr, ApplicationUserData.workTotalYear, applicationuser.workTotalYear); applicationuserdata.Assign(dr, ApplicationUserData.still, applicationuser.still); applicationuserdata.Assign(dr, ApplicationUserData.maxEducation, applicationuser.maxEducation); applicationuserdata.Assign(dr, ApplicationUserData.maxEduCollege, applicationuser.maxEduCollege); applicationuserdata.Assign(dr, ApplicationUserData.maxEduLeaveTime, applicationuser.maxEduLeaveTime); applicationuserdata.Assign(dr, ApplicationUserData.workExperiences, applicationuser.workExperiences); applicationuserdata.Assign(dr, ApplicationUserData.studyExperiences, applicationuser.studyExperiences); applicationuserdata.Assign(dr, ApplicationUserData.photoUrl, applicationuser.photoUrl); applicationuserdata.Tables[0].Rows.Add(dr); #endregion }