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