/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.docDraft model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update docDraft set ");
strSql.Append("code='" + model.code + "',");
strSql.Append("draft='" + model.draft + "'");
strSql.Append(" where code='" + model.code + "' ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.docDraft Find(string code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" code,draft ");
strSql.Append(" from docDraft ");
strSql.Append(" where code='" + code + "' ");
ERM.MDL.docDraft model = new ERM.MDL.docDraft();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.code = ds.Tables[0].Rows[0]["code"].ToString();
model.draft = ds.Tables[0].Rows[0]["draft"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.docDraft model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.code != null)
{
strSql1.Append("code,");
strSql2.Append("'" + model.code + "',");
}
if (model.draft != null)
{
strSql1.Append("draft,");
strSql2.Append("'" + model.draft + "',");
}
strSql.Append("insert into docDraft(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}