private TY_ReferendumReportModel _DataBind(int Code)
{
TY_ReferendumReportModel model = new TY_ReferendumReportModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from TY_ReferendumReport ");
builder.Append(" where ReferendumReportCode=@ReferendumReportCode");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@ReferendumReportCode", SqlDbType.Int, 4, Code);
SqlDataReader sqlDataReader = null;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
this.Initialize(sqlDataReader, model);
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(model);
}
private void Initialize(SqlDataReader reader, TY_ReferendumReportModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.ReferendumReportCode = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.Number = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.StartDate = reader.GetDateTime(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.StartPerson = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.TextTitle = reader.GetString(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.TextContent = reader.GetString(5);
}
if (reader.GetValue(6) != DBNull.Value)
{
obj.Audit = reader.GetString(6);
}
if (reader.GetValue(7) != DBNull.Value)
{
obj.Field1 = reader.GetString(7);
}
}
private List <TY_ReferendumReportModel> _Select(TY_ReferendumReportQueryModel qmObj)
{
List <TY_ReferendumReportModel> list = new List <TY_ReferendumReportModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from TY_ReferendumReport ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY ReferendumReportCode desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
TY_ReferendumReportModel model = new TY_ReferendumReportModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
private int _Update(TY_ReferendumReportModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update TY_ReferendumReport set ");
if (mObj.Number != null)
{
builder.Append("Number=@Number,");
this._DataProcess.ProcessParametersAdd("@Number", SqlDbType.VarChar, 50, mObj.Number);
}
if (mObj.StartDate != DateTime.MinValue)
{
builder.Append("StartDate=@StartDate,");
this._DataProcess.ProcessParametersAdd("@StartDate", SqlDbType.DateTime, 8, mObj.StartDate);
}
if (mObj.StartPerson != null)
{
builder.Append("StartPerson=@StartPerson,");
this._DataProcess.ProcessParametersAdd("@StartPerson", SqlDbType.VarChar, 50, mObj.StartPerson);
}
if (mObj.TextTitle != null)
{
builder.Append("TextTitle=@TextTitle,");
this._DataProcess.ProcessParametersAdd("@TextTitle", SqlDbType.VarChar, 50, mObj.TextTitle);
}
if (mObj.TextContent != null)
{
builder.Append("TextContent=@TextContent,");
this._DataProcess.ProcessParametersAdd("@TextContent", SqlDbType.VarChar, 800, mObj.TextContent);
}
if (mObj.Audit != null)
{
builder.Append("Audit=@Audit,");
this._DataProcess.ProcessParametersAdd("@Audit", SqlDbType.VarChar, 50, mObj.Audit);
}
if (mObj.Field1 != null)
{
builder.Append("Field1=@Field1,");
this._DataProcess.ProcessParametersAdd("@Field1", SqlDbType.VarChar, 50, mObj.Field1);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where ReferendumReportCode=@ReferendumReportCode");
this._DataProcess.ProcessParametersAdd("@ReferendumReportCode", SqlDbType.Int, 4, mObj.ReferendumReportCode);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
private int _Insert(TY_ReferendumReportModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into TY_ReferendumReport(");
builder.Append("Number,StartDate,StartPerson,TextTitle,TextContent,Audit,Field1)");
builder.Append(" values (");
builder.Append("@Number,@StartDate,@StartPerson,@TextTitle,@TextContent,@Audit,@Field1) ");
builder.Append("SELECT @ReferendumReportCode = SCOPE_IDENTITY()");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@Number", SqlDbType.VarChar, 50, mObj.Number);
this._DataProcess.ProcessParametersAdd("@StartDate", SqlDbType.DateTime, 8, mObj.StartDate);
this._DataProcess.ProcessParametersAdd("@StartPerson", SqlDbType.VarChar, 50, mObj.StartPerson);
this._DataProcess.ProcessParametersAdd("@TextTitle", SqlDbType.VarChar, 50, mObj.TextTitle);
this._DataProcess.ProcessParametersAdd("@TextContent", SqlDbType.VarChar, 800, mObj.TextContent);
this._DataProcess.ProcessParametersAdd("@Audit", SqlDbType.VarChar, 50, mObj.Audit);
this._DataProcess.ProcessParametersAdd("@Field1", SqlDbType.VarChar, 50, mObj.Field1);
SqlParameter parameter = this._DataProcess.ProcessParametersAdd("@ReferendumReportCode", SqlDbType.Int, 4, null);
parameter.Direction = ParameterDirection.Output;
this._DataProcess.RunSql();
mObj.ReferendumReportCode = (int)parameter.Value;
return(mObj.ReferendumReportCode);
}
public int Update(TY_ReferendumReportModel mObj)
{
return(this._Update(mObj));
}
public int Insert(TY_ReferendumReportModel mObj)
{
return(this._Insert(mObj));
}
public int Delete(TY_ReferendumReportModel mObj)
{
return(this._Delete(mObj.ReferendumReportCode));
}