/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebSiteModel.WebAttitudes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WebAttitudes(");
strSql.Append("Title,SortIndex,AddDate,Remark,Color)");
strSql.Append(" values (");
strSql.Append("@Title,@SortIndex,@AddDate,@Remark,@Color)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Title", DbType.String),
new SQLiteParameter("@SortIndex", DbType.Int32, 8),
new SQLiteParameter("@AddDate", DbType.DateTime),
new SQLiteParameter("@Remark", DbType.String),
new SQLiteParameter("@Color", DbType.String)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.SortIndex;
parameters[2].Value = model.AddDate;
parameters[3].Value = model.Remark;
parameters[3].Value = model.Color;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebSiteModel.WebAttitudes DataRowToModel(DataRow row)
{
WebSiteModel.WebAttitudes model = new WebSiteModel.WebAttitudes();
if (row != null)
{
if (row["WebAttitudesID"] != null && row["WebAttitudesID"].ToString() != "")
{
model.WebAttitudesID = int.Parse(row["WebAttitudesID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["SortIndex"] != null && row["SortIndex"].ToString() != "")
{
model.SortIndex = int.Parse(row["SortIndex"].ToString());
}
if (row["AddDate"] != null && row["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(row["AddDate"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["Color"] != null)
{
model.Color = row["Color"].ToString();
}
}
return(model);
}
private bool DoAdd()
{
bool result = true;
WebSiteModel.WebAttitudes model = new WebSiteModel.WebAttitudes();
WebSiteData.WebAttitudes bll = new WebSiteData.WebAttitudes();
string Title = this.txtTitle.Text;
DateTime AddDate;
if (Maticsoft.Common.PageValidate.IsDateTime(this.txtAddDate.Text))
{
AddDate = DateTime.Parse(this.txtAddDate.Text);
}
else
{
AddDate = DateTime.Now;
}
string Remark = this.txtRemark.Text;
string Color = this.txtColor.Text;
model.Title = Title;
model.AddDate = AddDate;
model.Remark = Remark;
model.Color = Color;
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
private void ShowInfo(int WebAttitudesID)
{
WebSiteData.WebAttitudes bll = new WebSiteData.WebAttitudes();
WebSiteModel.WebAttitudes model = bll.GetModel(WebAttitudesID);
this.lblWebAttitudesID.Text = model.WebAttitudesID.ToString();
this.txtTitle.Text = model.Title;
this.txtAddDate.Text = model.AddDate.ToString();
this.txtRemark.Text = model.Remark;
this.txtColor.Text = model.Color;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebSiteModel.WebAttitudes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebAttitudes set ");
strSql.Append("Title=@Title,");
strSql.Append("SortIndex=@SortIndex,");
strSql.Append("AddDate=@AddDate,");
strSql.Append("Remark=@Remark,");
strSql.Append("Color=@Color");
strSql.Append(" where WebAttitudesID=@WebAttitudesID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Title", DbType.String),
new SQLiteParameter("@SortIndex", DbType.Int32, 8),
new SQLiteParameter("@AddDate", DbType.DateTime),
new SQLiteParameter("@Remark", DbType.String),
new SQLiteParameter("@Color", DbType.String),
new SQLiteParameter("@WebAttitudesID", DbType.Int32, 8)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.SortIndex;
parameters[2].Value = model.AddDate;
parameters[3].Value = model.Remark;
parameters[4].Value = model.Color;
parameters[5].Value = model.WebAttitudesID;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebSiteModel.WebAttitudes GetModel(int WebAttitudesID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select WebAttitudesID,Title,SortIndex,AddDate,Remark,Color from WebAttitudes ");
strSql.Append(" where WebAttitudesID=@WebAttitudesID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@WebAttitudesID", DbType.Int32, 4)
};
parameters[0].Value = WebAttitudesID;
WebSiteModel.WebAttitudes model = new WebSiteModel.WebAttitudes();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
