public void Insert(ModelTaskClass model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
//if (this.ClassID != null) {
// strSql1.Append("ClassID,");
// strSql2.Append("" + this.ClassID + ",");
//}
if (model.TreeClassName != null)
{
strSql1.Append("TreeClassName,");
strSql2.Append("'" + model.TreeClassName + "',");
}
if (model.TreeClassReadMe != null)
{
strSql1.Append("TreeClassReadMe,");
strSql2.Append("'" + model.TreeClassReadMe + "',");
}
strSql.Append("insert into S_TreeClass(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
SQLiteHelper.Execute(dbStr, strSql.ToString());
}
public void Update(ModelTaskClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update S_TreeClass set ");
strSql.Append("TreeClassName=@TreeClassName,");
strSql.Append("TreeClassReadMe=@TreeClassReadMe");
strSql.Append(" where ClassID=@ClassID");
int rowsAffected = DbHelper.Execute(CommonHelper.SQLiteConnectionString, strSql.ToString(), model);
}
public void Insert(ModelTaskClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into S_TreeClass(");
strSql.Append("TreeClassName,TreeClassReadMe)");
strSql.Append(" values (");
strSql.Append("@TreeClassName,@TreeClassReadMe)");
DbHelper.Execute(CommonHelper.SQLiteConnectionString, strSql.ToString(), model);
}
public void Update(ModelTaskClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update S_TreeClass set ");
if (model.TreeClassName != null)
{
strSql.Append("TreeClassName='" + model.TreeClassName + "',");
}
if (model.TreeClassReadMe != null)
{
strSql.Append("TreeClassReadMe='" + model.TreeClassReadMe + "',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ClassID=" + model.ClassID + " ");
int rowsAffected = SQLiteHelper.Execute(dbStr, strSql.ToString());
}
/// <summary>
/// 操作点击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
errorProvider.Clear();
if (string.IsNullOrEmpty(this.txtTreeClassName.Text))
{
errorProvider.SetError(this.txtTreeClassName, "分类不能为空!");
return;
}
int ClassID = StringHelper.Instance.SetNumber(this.txtEditID.Text);
string TreeClassName = this.txtTreeClassName.Text;
string TreeClassReadMe = this.txtTreeClassReadMe.Text;
string opType = string.Empty;
string Msg = string.Empty;
DALTaskClass dal = new DALTaskClass();
ModelTaskClass model = new ModelTaskClass();
model.ClassID = ClassID;
model.TreeClassName = TreeClassName;
model.TreeClassReadMe = TreeClassReadMe;
if (ClassID == 0)
{
opType = "add";
Msg = "分类添加成功!";
dal.Insert(model);
}
else if (ClassID > 0)
{
opType = "edit";
Msg = "分类编辑成功!";
dal.Update(model);
}
if (OutOpMsg != null)
{
OutOpMsg(opType, Msg);
}
this.Hide();
this.Close();
}
