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