public string GetMissionsIdBySummaryId(EntityWLOGMission mission) { #region DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(WLOGMissionData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, mission.writeUser); querybusinessparams.Add(WLOGMissionData.summaryId, EnumSqlType.sqlint, EnumCondition.Equal, mission.summaryId); WLOGMissionData missiondata = new WLOGMissionData(); this._wlogmissionclass.GetSingleT(missiondata, querybusinessparams); JsonHelper jsonhlp = new JsonHelper(); string missionsid = ""; DataRowCollection drcollect = missiondata.Tables[0].Rows; for (int i = 0; i < drcollect.Count; i++) { string temp = drcollect[i][WLOGMissionData.missionId].ToString(); if (i != drcollect.Count - 1) { temp += ','; } missionsid += temp; } jsonhlp.AddObjectToJson("missionId", missionsid); jsonhlp.SetResult(true); return(jsonhlp.ToString()); #endregion }
/// <summary> /// 添加WLOGMission表行数据(如主键为非自增型字段,则自行修改代码) /// </summary> /// <param name="wlogmissiondata">数据集对象</param> /// <param name="wlogmission">实体对象</param> public void AddRow(ref WLOGMissionData wlogmissiondata, EntityWLOGMission wlogmission) { #region DataRow dr = wlogmissiondata.Tables[0].NewRow(); wlogmission.missionId = this._wlogmissionclass.GetMaxAddOne(wlogmissiondata).ToString(); wlogmissiondata.Assign(dr, WLOGMissionData.missionId, wlogmission.missionId); wlogmissiondata.Assign(dr, WLOGMissionData.summaryId, wlogmission.summaryId); wlogmissiondata.Assign(dr, WLOGMissionData.writeUser, wlogmission.writeUser); wlogmissiondata.Assign(dr, WLOGMissionData.projectId, wlogmission.projectId); wlogmissiondata.Assign(dr, WLOGMissionData.missionBH, wlogmission.missionBH); wlogmissiondata.Assign(dr, WLOGMissionData.missionName, wlogmission.missionName); wlogmissiondata.Assign(dr, WLOGMissionData.missionRemark, wlogmission.missionRemark); wlogmissiondata.Assign(dr, WLOGMissionData.planned, wlogmission.planned); wlogmissiondata.Assign(dr, WLOGMissionData.plantimelimit, wlogmission.plantimelimit); wlogmissiondata.Assign(dr, WLOGMissionData.outputResult, wlogmission.outputResult); wlogmissiondata.Assign(dr, WLOGMissionData.startDate, wlogmission.startDate); wlogmissiondata.Assign(dr, WLOGMissionData.reviewState, wlogmission.reviewState); wlogmissiondata.Assign(dr, WLOGMissionData.missionState, wlogmission.missionState); wlogmissiondata.Assign(dr, WLOGMissionData.deleted, wlogmission.deleted); wlogmissiondata.Assign(dr, WLOGMissionData.usable, wlogmission.usable); wlogmissiondata.Assign(dr, WLOGMissionData.updated, wlogmission.updated); wlogmissiondata.Assign(dr, WLOGMissionData.deleteTime, wlogmission.deleteTime); wlogmissiondata.Assign(dr, WLOGMissionData.writeTime, wlogmission.writeTime); wlogmissiondata.Assign(dr, WLOGMissionData.writeIp, wlogmission.writeIp); wlogmissiondata.Tables[0].Rows.Add(dr); #endregion }
/// <summary> /// 编辑wlogmissiondata数据集中指定的行数据 /// </summary> /// <param name="wlogmissiondata">数据集对象</param> /// <param name="wlogmission">实体对象</param> public void EditRow(ref WLOGMissionData wlogmissiondata, EntityWLOGMission wlogmission) { #region if (wlogmissiondata.Tables[0].Rows.Count <= 0) { wlogmissiondata = this.getData(wlogmission.missionId); } DataRow dr = wlogmissiondata.Tables[0].Rows.Find(new object[1] { wlogmission.missionId }); wlogmissiondata.Assign(dr, WLOGMissionData.missionId, wlogmission.missionId); wlogmissiondata.Assign(dr, WLOGMissionData.summaryId, wlogmission.summaryId); wlogmissiondata.Assign(dr, WLOGMissionData.writeUser, wlogmission.writeUser); wlogmissiondata.Assign(dr, WLOGMissionData.projectId, wlogmission.projectId); wlogmissiondata.Assign(dr, WLOGMissionData.missionBH, wlogmission.missionBH); wlogmissiondata.Assign(dr, WLOGMissionData.missionName, wlogmission.missionName); wlogmissiondata.Assign(dr, WLOGMissionData.missionRemark, wlogmission.missionRemark); wlogmissiondata.Assign(dr, WLOGMissionData.planned, wlogmission.planned); wlogmissiondata.Assign(dr, WLOGMissionData.plantimelimit, wlogmission.plantimelimit); wlogmissiondata.Assign(dr, WLOGMissionData.outputResult, wlogmission.outputResult); wlogmissiondata.Assign(dr, WLOGMissionData.startDate, wlogmission.startDate); wlogmissiondata.Assign(dr, WLOGMissionData.reviewState, wlogmission.reviewState); wlogmissiondata.Assign(dr, WLOGMissionData.missionState, wlogmission.missionState); wlogmissiondata.Assign(dr, WLOGMissionData.deleted, wlogmission.deleted); wlogmissiondata.Assign(dr, WLOGMissionData.usable, wlogmission.usable); wlogmissiondata.Assign(dr, WLOGMissionData.updated, wlogmission.updated); wlogmissiondata.Assign(dr, WLOGMissionData.deleteTime, wlogmission.deleteTime); wlogmissiondata.Assign(dr, WLOGMissionData.writeTime, wlogmission.writeTime); wlogmissiondata.Assign(dr, WLOGMissionData.writeIp, wlogmission.writeIp); #endregion }
/**************************************** ***生成器版本:V1.0.1.31494 ***生成时间:2013-04-26 18:05:16 ***公司:山西ICat Studio有限公司 ***友情提示:以下代码为生成器自动生成,可做参照修改之用; *** 如需有其他业务要求,可在region外添加新方法; *** 如发现任何编译和运行时错误,请联系QQ:330669393。 *****************************************/ #region public members methods /// <summary> /// 根据条件筛选所有WLOGMission指定页码的数据(分页型) /// </summary> /// <param name="wlogmission">实体对象</param> /// <param name="pageparams">分页对象</param> /// <returns></returns> public string GetJsonByPage(EntityWLOGMission wlogmission, PageParams pageparams) { #region int totalCount = 0; WLOGMissionClass wlogmissionclass = new WLOGMissionClass(); pageparams.PageSorts.Add(new PageSort(WLOGMissionData.writeTime, EnumSQLOrderBY.DESC)); DataSet wlogmissiondata = this.GetData(wlogmission, pageparams, out totalCount); return(base.GetJson(wlogmissiondata, totalCount)); #endregion }
/// <summary> /// 将符合查询的数据导出Excel /// </summary> /// <param name="filename"></param> /// <param name="grid"></param> /// <param name="httplink"></param> public void OutputExcel(string filename, ExtjsGrid grid, EntityWLOGMission wlogmission) { #region int totalcount = 0; PageParams queryparams = new PageParams(1, 65536); DataSet ds = this.GetData(wlogmission, queryparams, out totalcount); ExportExcel exportexcel = new ExportExcel(filename, ds, grid); exportexcel.Output(); #endregion }
public string GetMissionBySummaryId(EntityWLOGMission mission, SceneWeekSummary scene) { #region WLOGMissionClass wlogmissionclass = new WLOGMissionClass(); DBConditions querybusinessparams = new DBConditions(); querybusinessparams.Add(WLOGMissionData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, mission.writeUser); switch (scene) { case SceneWeekSummary.ViewMissions: querybusinessparams.Or(WLOGMissionData.summaryId, EnumSqlType.sqlint, EnumCondition.Equal, mission.summaryId); break; case SceneWeekSummary.AddWeekSummary: querybusinessparams.Or(WLOGMissionData.summaryId, EnumSqlType.sqlint, EnumCondition.EmptyIsNull, ""); break; case SceneWeekSummary.EditWeekSummary: querybusinessparams.Or(WLOGMissionData.summaryId, EnumSqlType.sqlint, EnumCondition.EmptyIsNull, ""); querybusinessparams.Add(WLOGMissionData.summaryId, EnumSqlType.sqlint, EnumCondition.Equal, mission.summaryId); querybusinessparams.Add(WLOGMissionData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, mission.writeUser); break; default: break; } int totalCount = 0; WLOGMissionData missiondata = new WLOGMissionData(); totalCount = this._wlogmissionclass.GetSingleT(missiondata, querybusinessparams); return(base.GetJson(missiondata, totalCount)); #endregion }
/// <summary> /// 根据条件筛选所有WLOGMission指定页码的数据(分页型) /// </summary> /// <param name="wlogmission">实体对象</param> /// <param name="pageparams">分页对象</param> /// <param name="totalCount">符合条件的记录总数量</param> /// <returns></returns> public DataSet GetData(EntityWLOGMission wlogmission, PageParams pageparams, out int totalCount) { #region DBConditions querybusinessparams = new DBConditions(pageparams); querybusinessparams.Add(WLOGMissionData.writeUser, EnumSqlType.sqlint, EnumCondition.Equal, wlogmission.writeUser); querybusinessparams.Add(WLOGMissionData.missionBH, EnumSqlType.nvarchar, EnumCondition.LikeRight, wlogmission.missionBH); querybusinessparams.Add(WLOGMissionData.missionName, EnumSqlType.nvarchar, EnumCondition.LikeBoth, wlogmission.missionName); querybusinessparams.Add(WLOGMissionData.planned, EnumSqlType.bit, EnumCondition.Equal, wlogmission.planned); querybusinessparams.Add(WLOGMissionData.reviewState, EnumSqlType.bit, EnumCondition.Equal, wlogmission.reviewState); querybusinessparams.Add(WLOGMissionData.missionState, EnumSqlType.tinyint, EnumCondition.Equal, wlogmission.missionState); querybusinessparams.Add(WLOGMissionData.usable, EnumSqlType.bit, EnumCondition.Equal, wlogmission.usable); WLOGMissionData wlogmissiondata = new WLOGMissionData(); totalCount = this._wlogmissionclass.SelectWLOGMissionByPage(wlogmissiondata, querybusinessparams); return(wlogmissiondata); #endregion }