/// <summary> /// 事务-删除旧记录,修改新记录 /// </summary> public bool DeleteAndModifyInTransaction(CRBITBL_HistoryControlQuery query, int idModify, int idDelete) { var dataCommand = DataCommandManager.GetDataCommand("DeleteAndModifySampleInfoInTransaction"); dataCommand.SetParameterValue("@n_IdDelete", idDelete); dataCommand.SetParameterValue("@n_IdModify", idModify); dataCommand.SetParameterValue("@s_ProvinceName", query.sProvinceName); dataCommand.SetParameterValue("@n_ProvinceCode", query.iProvinceCode); dataCommand.SetParameterValue("@s_CityName", query.sCityName); dataCommand.SetParameterValue("@n_CityCode", query.iCityCode); dataCommand.SetParameterValue("@s_AreaName", query.sAreaName); dataCommand.SetParameterValue("@n_AreaCode", query.iAreaCode); dataCommand.SetParameterValue("@dt_Start", query.dateStart); dataCommand.SetParameterValue("@dt_End", query.dateEnd); dataCommand.SetParameterValue("@s_EnterpriseName", query.sEnterpriseName); dataCommand.SetParameterValue("@n_EnterpriseID", query.iEnterpriseID); dataCommand.SetParameterValue("@b_IsValid", query.bIsValid); dataCommand.SetParameterValue("@n_Type", query.iType); DataTable result = dataCommand.ExecuteDataSet().Tables[0]; if (result.Rows[0][0].ToString() == "0") { return(true); } else { return(false); } }
public CRBITBL_HistoryControlResult LoadDataByType(CRBITBL_HistoryControlQuery query) { var pagingInfo = new PagingInfoEntity(); pagingInfo.SortField = query.PageInfo.SortFields; pagingInfo.StartRowIndex = 1 + query.PageInfo.PageIndex * query.PageInfo.PageSize; pagingInfo.MaximumRows = query.PageInfo.PageSize - 1; if (pagingInfo.MaximumRows < 0) { pagingInfo.MaximumRows = 0; } if (pagingInfo.StartRowIndex < 0) { pagingInfo.StartRowIndex = 0; } var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("loadSamplePolitInfoByType"); using (var builder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "n_ID asc")) { builder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, string.Format("n_Type={0}", query.iType)); dataCommand.CommandText = builder.BuildQuerySql(); } var result = dataCommand.ExecuteEntityList <CRBITBL_HistoryControlTable>(); var totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); CRBITBL_HistoryControlResult response = new CRBITBL_HistoryControlResult(); response.DataList = result; response.TotalCount = totalCount; return(response); }
public void Insert(CRBITBL_HistoryControlQuery query) { var dataCommand = DataCommandManager.GetDataCommand("insertSamplePolitInfo"); dataCommand.SetParameterValue("@s_ProvinceName", query.sProvinceName); dataCommand.SetParameterValue("@n_ProvinceCode", query.iProvinceCode); dataCommand.SetParameterValue("@s_CityName", query.sCityName); dataCommand.SetParameterValue("@n_CityCode", query.iCityCode); dataCommand.SetParameterValue("@s_AreaName", query.sAreaName); dataCommand.SetParameterValue("@n_AreaCode", query.iAreaCode); dataCommand.SetParameterValue("@dt_Start", query.dateStart); dataCommand.SetParameterValue("@dt_End", query.dateEnd); dataCommand.SetParameterValue("@s_EnterpriseName", query.sEnterpriseName); dataCommand.SetParameterValue("@n_EnterpriseID", query.iEnterpriseID); dataCommand.SetParameterValue("@b_IsValid", query.bIsValid); dataCommand.SetParameterValue("@n_Type", query.iType); dataCommand.ExecuteNonQuery(); }