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