/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CR_LICENSE_ANALYSIS_CORRECTION set ");
strSql.Append("ID=@ID,");
strSql.Append("VEH_NO_ERROR=@VEH_NO_ERROR,");
strSql.Append("VEH_NO_CORRECT=@VEH_NO_CORRECT,");
strSql.Append("PASSAGE_COUNT=@PASSAGE_COUNT,");
strSql.Append("ERROR_COUNT=@ERROR_COUNT,");
strSql.Append("CORRECT_FLAG=@CORRECT_FLAG,");
strSql.Append("CREATE_TIME=@CREATE_TIME,");
strSql.Append("UPDATE_TIME=@UPDATE_TIME,");
strSql.Append("UPDATE_USERNAME=@UPDATE_USERNAME");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32),
new SqlParameter("@VEH_NO_ERROR", SqlDbType.VarChar, 50),
new SqlParameter("@VEH_NO_CORRECT", SqlDbType.VarChar, 50),
new SqlParameter("@PASSAGE_COUNT", SqlDbType.Int, 4),
new SqlParameter("@ERROR_COUNT", SqlDbType.Int, 4),
new SqlParameter("@CORRECT_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_USERNAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.VEH_NO_ERROR;
parameters[2].Value = model.VEH_NO_CORRECT;
parameters[3].Value = model.PASSAGE_COUNT;
parameters[4].Value = model.ERROR_COUNT;
parameters[5].Value = model.CORRECT_FLAG;
parameters[6].Value = model.CREATE_TIME;
parameters[7].Value = model.UPDATE_TIME;
parameters[8].Value = model.UPDATE_USERNAME;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION DataRowToModel(DataRow row)
{
Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION model = new Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["VEH_NO_ERROR"] != null)
{
model.VEH_NO_ERROR = row["VEH_NO_ERROR"].ToString();
}
if (row["VEH_NO_CORRECT"] != null)
{
model.VEH_NO_CORRECT = row["VEH_NO_CORRECT"].ToString();
}
if (row["PASSAGE_COUNT"] != null && row["PASSAGE_COUNT"].ToString() != "")
{
model.PASSAGE_COUNT = int.Parse(row["PASSAGE_COUNT"].ToString());
}
if (row["ERROR_COUNT"] != null && row["ERROR_COUNT"].ToString() != "")
{
model.ERROR_COUNT = int.Parse(row["ERROR_COUNT"].ToString());
}
if (row["CORRECT_FLAG"] != null && row["CORRECT_FLAG"].ToString() != "")
{
model.CORRECT_FLAG = int.Parse(row["CORRECT_FLAG"].ToString());
}
if (row["CREATE_TIME"] != null && row["CREATE_TIME"].ToString() != "")
{
model.CREATE_TIME = DateTime.Parse(row["CREATE_TIME"].ToString());
}
if (row["UPDATE_TIME"] != null && row["UPDATE_TIME"].ToString() != "")
{
model.UPDATE_TIME = DateTime.Parse(row["UPDATE_TIME"].ToString());
}
if (row["UPDATE_USERNAME"] != null)
{
model.UPDATE_USERNAME = row["UPDATE_USERNAME"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CR_LICENSE_ANALYSIS_CORRECTION(");
strSql.Append("ID,VEH_NO_ERROR,VEH_NO_CORRECT,PASSAGE_COUNT,ERROR_COUNT,CORRECT_FLAG,CREATE_TIME,UPDATE_TIME,UPDATE_USERNAME)");
strSql.Append(" values (");
strSql.Append("@ID,@VEH_NO_ERROR,@VEH_NO_CORRECT,@PASSAGE_COUNT,@ERROR_COUNT,@CORRECT_FLAG,@CREATE_TIME,@UPDATE_TIME,@UPDATE_USERNAME)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.VarChar, 32),
new SqlParameter("@VEH_NO_ERROR", SqlDbType.VarChar, 50),
new SqlParameter("@VEH_NO_CORRECT", SqlDbType.VarChar, 50),
new SqlParameter("@PASSAGE_COUNT", SqlDbType.Int, 4),
new SqlParameter("@ERROR_COUNT", SqlDbType.Int, 4),
new SqlParameter("@CORRECT_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_TIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_USERNAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.VEH_NO_ERROR;
parameters[2].Value = model.VEH_NO_CORRECT;
parameters[3].Value = model.PASSAGE_COUNT;
parameters[4].Value = model.ERROR_COUNT;
parameters[5].Value = model.CORRECT_FLAG;
parameters[6].Value = model.CREATE_TIME;
parameters[7].Value = model.UPDATE_TIME;
parameters[8].Value = model.UPDATE_USERNAME;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,VEH_NO_ERROR,VEH_NO_CORRECT,PASSAGE_COUNT,ERROR_COUNT,CORRECT_FLAG,CREATE_TIME,UPDATE_TIME,UPDATE_USERNAME from CR_LICENSE_ANALYSIS_CORRECTION ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION model = new Parking.Core.Model.CR_LICENSE_ANALYSIS_CORRECTION();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
