/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.ArchiveData model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ArchiveData set ");
strSql.Append("cellCreatedate='" + model.cellCreatedate + "',");
strSql.Append("cellParentid='" + model.cellParentid + "',");
strSql.Append("codetype=" + model.codetype + ",");
strSql.Append("customdefine=" + model.customdefine + ",");
strSql.Append("docstatus=" + model.docstatus + ",");
strSql.Append("examplepath='" + model.examplepath + "',");
strSql.Append("fbmc='" + model.fbmc + "',");
strSql.Append("filepath='" + model.filepath + "',");
strSql.Append("fxmc='" + model.fxmc + "',");
strSql.Append("id=" + model.id + ",");
strSql.Append("orderindex=" + model.orderindex + ",");
strSql.Append("ProjectNO='" + model.ProjectNO + "',");
strSql.Append("ptreepath='" + model.ptreepath + "',");
strSql.Append("title='" + model.title + "',");
strSql.Append("treepath='" + model.treepath + "',");
strSql.Append("ys=" + model.ys + ",");
strSql.Append("zfbmc='" + model.zfbmc + "',");
strSql.Append("zrr='" + model.zrr + "'");
strSql.Append(" where id=" + model.id + " ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.ArchiveData Find(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" cellCreatedate,cellParentid,codetype,customdefine,docstatus,examplepath,fbmc,filepath,fxmc,id,orderindex,ProjectNO,ptreepath,title,treepath,ys,zfbmc,zrr ");
strSql.Append(" from ArchiveData ");
strSql.Append(" where id=" + id + " ");
ERM.MDL.ArchiveData model = new ERM.MDL.ArchiveData();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.cellCreatedate = ds.Tables[0].Rows[0]["cellCreatedate"].ToString();
model.cellParentid = ds.Tables[0].Rows[0]["cellParentid"].ToString();
if (ds.Tables[0].Rows[0]["codetype"].ToString() != "")
{
model.codetype = int.Parse(ds.Tables[0].Rows[0]["codetype"].ToString());
}
if (ds.Tables[0].Rows[0]["customdefine"].ToString() != "")
{
model.customdefine = int.Parse(ds.Tables[0].Rows[0]["customdefine"].ToString());
}
if (ds.Tables[0].Rows[0]["docstatus"].ToString() != "")
{
model.docstatus = int.Parse(ds.Tables[0].Rows[0]["docstatus"].ToString());
}
model.examplepath = ds.Tables[0].Rows[0]["examplepath"].ToString();
model.fbmc = ds.Tables[0].Rows[0]["fbmc"].ToString();
model.filepath = ds.Tables[0].Rows[0]["filepath"].ToString();
model.fxmc = ds.Tables[0].Rows[0]["fxmc"].ToString();
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["orderindex"].ToString() != "")
{
model.orderindex = int.Parse(ds.Tables[0].Rows[0]["orderindex"].ToString());
}
model.ProjectNO = ds.Tables[0].Rows[0]["ProjectNO"].ToString();
model.ptreepath = ds.Tables[0].Rows[0]["ptreepath"].ToString();
model.title = ds.Tables[0].Rows[0]["title"].ToString();
model.treepath = ds.Tables[0].Rows[0]["treepath"].ToString();
if (ds.Tables[0].Rows[0]["ys"].ToString() != "")
{
model.ys = int.Parse(ds.Tables[0].Rows[0]["ys"].ToString());
}
model.zfbmc = ds.Tables[0].Rows[0]["zfbmc"].ToString();
model.zrr = ds.Tables[0].Rows[0]["zrr"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.ArchiveData model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.cellCreatedate != null)
{
strSql1.Append("cellCreatedate,");
strSql2.Append("'" + model.cellCreatedate + "',");
}
if (model.cellParentid != null)
{
strSql1.Append("cellParentid,");
strSql2.Append("'" + model.cellParentid + "',");
}
if (model.codetype != null)
{
strSql1.Append("codetype,");
strSql2.Append("" + model.codetype + ",");
}
if (model.customdefine != null)
{
strSql1.Append("customdefine,");
strSql2.Append("" + model.customdefine + ",");
}
if (model.docstatus != null)
{
strSql1.Append("docstatus,");
strSql2.Append("" + model.docstatus + ",");
}
if (model.examplepath != null)
{
strSql1.Append("examplepath,");
strSql2.Append("'" + model.examplepath + "',");
}
if (model.fbmc != null)
{
strSql1.Append("fbmc,");
strSql2.Append("'" + model.fbmc + "',");
}
if (model.filepath != null)
{
strSql1.Append("filepath,");
strSql2.Append("'" + model.filepath + "',");
}
if (model.fxmc != null)
{
strSql1.Append("fxmc,");
strSql2.Append("'" + model.fxmc + "',");
}
if (model.id != null)
{
strSql1.Append("id,");
strSql2.Append("" + model.id + ",");
}
if (model.orderindex != null)
{
strSql1.Append("orderindex,");
strSql2.Append("" + model.orderindex + ",");
}
if (model.ProjectNO != null)
{
strSql1.Append("ProjectNO,");
strSql2.Append("'" + model.ProjectNO + "',");
}
if (model.ptreepath != null)
{
strSql1.Append("ptreepath,");
strSql2.Append("'" + model.ptreepath + "',");
}
if (model.title != null)
{
strSql1.Append("title,");
strSql2.Append("'" + model.title + "',");
}
if (model.treepath != null)
{
strSql1.Append("treepath,");
strSql2.Append("'" + model.treepath + "',");
}
if (model.ys != null)
{
strSql1.Append("ys,");
strSql2.Append("" + model.ys + ",");
}
if (model.zfbmc != null)
{
strSql1.Append("zfbmc,");
strSql2.Append("'" + model.zfbmc + "',");
}
if (model.zrr != null)
{
strSql1.Append("zrr,");
strSql2.Append("'" + model.zrr + "',");
}
strSql.Append("insert into ArchiveData(");
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());
}
