/// <summary> /// 更新一条数据 /// </summary> public void Update(ERM.MDL.T_CellFile model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Cell_Templet set "); strSql.Append("codeno='" + model.codeno + "',"); strSql.Append("codetype=" + model.codetype + ","); strSql.Append("customdefine=" + model.customdefine + ","); 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("isvisible=" + model.isvisible + ","); strSql.Append("orderindex=" + model.orderindex + ","); strSql.Append("parentid='" + model.parentid + "',"); 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 + "' and ProjectNO='" + model.ProjectNO + "' "); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERM.MDL.T_CellFile Find(string id, string ProjectNO) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" codeno,codetype,customdefine,examplepath,fbmc,filepath,fxmc,id,isvisible,orderindex,parentid,ProjectNO,PTreePath,title,TreePath,ys,zfbmc,zrr "); strSql.Append(" from Cell_Templet "); strSql.Append(" where id='" + id + "' and ProjectNO='" + ProjectNO + "' "); ERM.MDL.T_CellFile model = new ERM.MDL.T_CellFile(); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { model.codeno = ds.Tables[0].Rows[0]["codeno"].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()); } 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(); model.id = ds.Tables[0].Rows[0]["id"].ToString(); if (ds.Tables[0].Rows[0]["isvisible"].ToString() != "") { model.isvisible = int.Parse(ds.Tables[0].Rows[0]["isvisible"].ToString()); } if (ds.Tables[0].Rows[0]["orderindex"].ToString() != "") { model.orderindex = int.Parse(ds.Tables[0].Rows[0]["orderindex"].ToString()); } model.parentid = ds.Tables[0].Rows[0]["parentid"].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.T_CellFile model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.codeno != null) { strSql1.Append("codeno,"); strSql2.Append("'" + model.codeno + "',"); } if (model.codetype != null) { strSql1.Append("codetype,"); strSql2.Append("" + model.codetype + ","); } if (model.customdefine != null) { strSql1.Append("customdefine,"); strSql2.Append("" + model.customdefine + ","); } 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.isvisible != null) { strSql1.Append("isvisible,"); strSql2.Append("" + model.isvisible + ","); } if (model.orderindex != null) { strSql1.Append("orderindex,"); strSql2.Append("" + model.orderindex + ","); } if (model.parentid != null) { strSql1.Append("parentid,"); strSql2.Append("'" + model.parentid + "',"); } 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 Cell_Templet("); 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()); }