/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone();
if (row != null)
{
if (row["ReaderTimeZoneID"] != null && row["ReaderTimeZoneID"].ToString() != "")
{
model.ReaderTimeZoneID = int.Parse(row["ReaderTimeZoneID"].ToString());
}
if (row["TimeZone1"] != null)
{
model.TimeZone1 = row["TimeZone1"].ToString();
}
if (row["OperateMode1"] != null && row["OperateMode1"].ToString() != "")
{
model.OperateMode1 = int.Parse(row["OperateMode1"].ToString());
}
if (row["TimeZone2"] != null)
{
model.TimeZone2 = row["TimeZone2"].ToString();
}
if (row["OperateMode2"] != null && row["OperateMode2"].ToString() != "")
{
model.OperateMode2 = int.Parse(row["OperateMode2"].ToString());
}
if (row["TimeZone3"] != null)
{
model.TimeZone3 = row["TimeZone3"].ToString();
}
if (row["OperateMode3"] != null && row["OperateMode3"].ToString() != "")
{
model.OperateMode3 = int.Parse(row["OperateMode3"].ToString());
}
if (row["TimeZone4"] != null)
{
model.TimeZone4 = row["TimeZone4"].ToString();
}
if (row["OperateMode4"] != null && row["OperateMode4"].ToString() != "")
{
model.OperateMode4 = int.Parse(row["OperateMode4"].ToString());
}
if (row["TimeZone5"] != null)
{
model.TimeZone5 = row["TimeZone5"].ToString();
}
if (row["OperateMode5"] != null && row["OperateMode5"].ToString() != "")
{
model.OperateMode5 = int.Parse(row["OperateMode5"].ToString());
}
if (row["TimeZone6"] != null)
{
model.TimeZone6 = row["TimeZone6"].ToString();
}
if (row["OperateMode6"] != null && row["OperateMode6"].ToString() != "")
{
model.OperateMode6 = int.Parse(row["OperateMode6"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ReaderTimeZone set ");
strSql.Append("TimeZone1=@TimeZone1,");
strSql.Append("OperateMode1=@OperateMode1,");
strSql.Append("TimeZone2=@TimeZone2,");
strSql.Append("OperateMode2=@OperateMode2,");
strSql.Append("TimeZone3=@TimeZone3,");
strSql.Append("OperateMode3=@OperateMode3,");
strSql.Append("TimeZone4=@TimeZone4,");
strSql.Append("OperateMode4=@OperateMode4,");
strSql.Append("TimeZone5=@TimeZone5,");
strSql.Append("OperateMode5=@OperateMode5,");
strSql.Append("TimeZone6=@TimeZone6,");
strSql.Append("OperateMode6=@OperateMode6");
strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TimeZone1", DbType.String),
new SQLiteParameter("@OperateMode1", DbType.Int32, 4),
new SQLiteParameter("@TimeZone2", DbType.String),
new SQLiteParameter("@OperateMode2", DbType.Int32, 4),
new SQLiteParameter("@TimeZone3", DbType.String),
new SQLiteParameter("@OperateMode3", DbType.Int32, 4),
new SQLiteParameter("@TimeZone4", DbType.String),
new SQLiteParameter("@OperateMode4", DbType.Int32, 4),
new SQLiteParameter("@TimeZone5", DbType.String),
new SQLiteParameter("@OperateMode5", DbType.Int32, 4),
new SQLiteParameter("@TimeZone6", DbType.String),
new SQLiteParameter("@OperateMode6", DbType.Int32, 4),
new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4)
};
parameters[0].Value = model.TimeZone1;
parameters[1].Value = model.OperateMode1;
parameters[2].Value = model.TimeZone2;
parameters[3].Value = model.OperateMode2;
parameters[4].Value = model.TimeZone3;
parameters[5].Value = model.OperateMode3;
parameters[6].Value = model.TimeZone4;
parameters[7].Value = model.OperateMode4;
parameters[8].Value = model.TimeZone5;
parameters[9].Value = model.OperateMode5;
parameters[10].Value = model.TimeZone6;
parameters[11].Value = model.OperateMode6;
parameters[12].Value = model.ReaderTimeZoneID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ReaderTimeZone(");
strSql.Append("ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6)");
strSql.Append(" values (");
strSql.Append("@ReaderTimeZoneID,@TimeZone1,@OperateMode1,@TimeZone2,@OperateMode2,@TimeZone3,@OperateMode3,@TimeZone4,@OperateMode4,@TimeZone5,@OperateMode5,@TimeZone6,@OperateMode6)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4),
new SQLiteParameter("@TimeZone1", DbType.String),
new SQLiteParameter("@OperateMode1", DbType.Int32, 4),
new SQLiteParameter("@TimeZone2", DbType.String),
new SQLiteParameter("@OperateMode2", DbType.Int32, 4),
new SQLiteParameter("@TimeZone3", DbType.String),
new SQLiteParameter("@OperateMode3", DbType.Int32, 4),
new SQLiteParameter("@TimeZone4", DbType.String),
new SQLiteParameter("@OperateMode4", DbType.Int32, 4),
new SQLiteParameter("@TimeZone5", DbType.String),
new SQLiteParameter("@OperateMode5", DbType.Int32, 4),
new SQLiteParameter("@TimeZone6", DbType.String),
new SQLiteParameter("@OperateMode6", DbType.Int32, 4)
};
parameters[0].Value = model.ReaderTimeZoneID;
parameters[1].Value = model.TimeZone1;
parameters[2].Value = model.OperateMode1;
parameters[3].Value = model.TimeZone2;
parameters[4].Value = model.OperateMode2;
parameters[5].Value = model.TimeZone3;
parameters[6].Value = model.OperateMode3;
parameters[7].Value = model.TimeZone4;
parameters[8].Value = model.OperateMode4;
parameters[9].Value = model.TimeZone5;
parameters[10].Value = model.OperateMode5;
parameters[11].Value = model.TimeZone6;
parameters[12].Value = model.OperateMode6;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone GetModel(int ReaderTimeZoneID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6 from ReaderTimeZone ");
strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32, 4)
};
parameters[0].Value = ReaderTimeZoneID;
KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone DataRowToModel(DataRow row)
{
KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone();
if (row != null)
{
if(row["ReaderTimeZoneID"]!=null && row["ReaderTimeZoneID"].ToString()!="")
{
model.ReaderTimeZoneID=int.Parse(row["ReaderTimeZoneID"].ToString());
}
if(row["TimeZone1"]!=null)
{
model.TimeZone1=row["TimeZone1"].ToString();
}
if(row["OperateMode1"]!=null && row["OperateMode1"].ToString()!="")
{
model.OperateMode1=int.Parse(row["OperateMode1"].ToString());
}
if(row["TimeZone2"]!=null)
{
model.TimeZone2=row["TimeZone2"].ToString();
}
if(row["OperateMode2"]!=null && row["OperateMode2"].ToString()!="")
{
model.OperateMode2=int.Parse(row["OperateMode2"].ToString());
}
if(row["TimeZone3"]!=null)
{
model.TimeZone3=row["TimeZone3"].ToString();
}
if(row["OperateMode3"]!=null && row["OperateMode3"].ToString()!="")
{
model.OperateMode3=int.Parse(row["OperateMode3"].ToString());
}
if(row["TimeZone4"]!=null)
{
model.TimeZone4=row["TimeZone4"].ToString();
}
if(row["OperateMode4"]!=null && row["OperateMode4"].ToString()!="")
{
model.OperateMode4=int.Parse(row["OperateMode4"].ToString());
}
if(row["TimeZone5"]!=null)
{
model.TimeZone5=row["TimeZone5"].ToString();
}
if(row["OperateMode5"]!=null && row["OperateMode5"].ToString()!="")
{
model.OperateMode5=int.Parse(row["OperateMode5"].ToString());
}
if(row["TimeZone6"]!=null)
{
model.TimeZone6=row["TimeZone6"].ToString();
}
if(row["OperateMode6"]!=null && row["OperateMode6"].ToString()!="")
{
model.OperateMode6=int.Parse(row["OperateMode6"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone GetModel(int ReaderTimeZoneID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ReaderTimeZoneID,TimeZone1,OperateMode1,TimeZone2,OperateMode2,TimeZone3,OperateMode3,TimeZone4,OperateMode4,TimeZone5,OperateMode5,TimeZone6,OperateMode6 from ReaderTimeZone ");
strSql.Append(" where ReaderTimeZoneID=@ReaderTimeZoneID ");
SQLiteParameter[] parameters = {
new SQLiteParameter("@ReaderTimeZoneID", DbType.Int32,4) };
parameters[0].Value = ReaderTimeZoneID;
KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone model=new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderTimeZone();
DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
