/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(KM.Entity.KeyWords model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KeyWords set ");
strSql.Append("KeyWordsName=@KeyWordsName,");
strSql.Append("KeyWordsStatus=@KeyWordsStatus");
strSql.Append(" where KID=@KID ");
SqlParameter[] parameters =
{
new SqlParameter("@KeyWordsName", SqlDbType.NVarChar, 200),
new SqlParameter("@KeyWordsStatus", SqlDbType.NVarChar, 10),
new SqlParameter("@KID", SqlDbType.NVarChar, 30)
};
parameters[0].Value = model.KeyWordsName;
parameters[1].Value = model.KeyWordsStatus;
parameters[2].Value = model.KID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(KM.Entity.KeyWords model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into KeyWords(");
strSql.Append("KID,KeyWordsName,KeyWordsStatus)");
strSql.Append(" values (");
strSql.Append("@KID,@KeyWordsName,@KeyWordsStatus)");
SqlParameter[] parameters =
{
new SqlParameter("@KID", SqlDbType.NVarChar, 30),
new SqlParameter("@KeyWordsName", SqlDbType.NVarChar, 200),
new SqlParameter("@KeyWordsStatus", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.KID;
parameters[1].Value = model.KeyWordsName;
parameters[2].Value = model.KeyWordsStatus;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//赋值操作
public void BingData()
{
if (this.kid != "")
{
KM.Entity.KeyWords kwmodel = kw.GetModel(this.kid);
this.txtID.Text = kwmodel.KID;
this.txtName.Text = kwmodel.KeyWordsName;
this.comBoxStatus.SelectedItem = kwmodel.KeyWordsStatus;
//禁用只读
this.txtID.ReadOnly = true;
}
}
//增加操作
public bool DoAdd()
{
bool bl = true;
KM.Entity.KeyWords kwmodel = new KM.Entity.KeyWords();
kwmodel.KID = CommonSpace.Conmmon.GenerateStringID();
kwmodel.KeyWordsName = this.txtName.Text;
kwmodel.KeyWordsStatus = this.comBoxStatus.Text;
if (!kw.Add(kwmodel))
{
bl = false;
}
return(bl);
}
//编辑操作
public bool Doedit()
{
//为什么在这个地方还要获取一次数据呢？
//因为需要的将获得更新对象的ID
bool bl = true;
if (this.kid != "")
{
KM.Entity.KeyWords kwmodel = kw.GetModel(this.kid);
kwmodel.KeyWordsName = this.txtName.Text;
kwmodel.KeyWordsStatus = this.comBoxStatus.Text;
if (!kw.Update(kwmodel))
{
bl = false;
}
}
return(bl);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KM.Entity.KeyWords DataRowToModel(DataRow row)
{
KM.Entity.KeyWords model = new KM.Entity.KeyWords();
if (row != null)
{
if (row["KID"] != null)
{
model.KID = row["KID"].ToString();
}
if (row["KeyWordsName"] != null)
{
model.KeyWordsName = row["KeyWordsName"].ToString();
}
if (row["KeyWordsStatus"] != null)
{
model.KeyWordsStatus = row["KeyWordsStatus"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KM.Entity.KeyWords GetModel(string KID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 KID,KeyWordsName,KeyWordsStatus from KeyWords ");
strSql.Append(" where KID=@KID ");
SqlParameter[] parameters =
{
new SqlParameter("@KID", SqlDbType.NVarChar, 30)
};
parameters[0].Value = KID;
KM.Entity.KeyWords model = new KM.Entity.KeyWords();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
