/// <summary> /// 增加一条数据 /// </summary> public void Add(ERM.MDL.ArchiveTemps model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.Cell_Templet_Name != null) { strSql1.Append("Cell_Templet_Name,"); strSql2.Append("'" + model.Cell_Templet_Name + "',"); } if (model.Cell_Templet_Table != null) { strSql1.Append("Cell_Templet_Table,"); strSql2.Append("'" + model.Cell_Templet_Table + "',"); } if (model.fileRecording_Templet_Table != null) { strSql1.Append("fileRecording_Templet_Table,"); strSql2.Append("'" + model.fileRecording_Templet_Table + "',"); } if (model.isDefault != null) { strSql1.Append("isDefault,"); strSql2.Append("" + model.isDefault + ","); } if (model.orderindex != null) { strSql1.Append("orderindex,"); strSql2.Append("" + model.orderindex + ","); } if (model.Recording_Templet_Name != null) { strSql1.Append("Recording_Templet_Name,"); strSql2.Append("'" + model.Recording_Templet_Name + "',"); } if (model.tempid != null) { strSql1.Append("tempid,"); strSql2.Append("" + model.tempid + ","); } if (model.UserTitle != null) { strSql1.Append("UserTitle,"); strSql2.Append("'" + model.UserTitle + "',"); } if (model.visible != null) { strSql1.Append("visible,"); strSql2.Append("" + model.visible + ","); } strSql.Append("insert into ArchiveTemps("); 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()); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ERM.MDL.ArchiveTemps model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ArchiveTemps set "); strSql.Append("Cell_Templet_Name='" + model.Cell_Templet_Name + "',"); strSql.Append("Cell_Templet_Table='" + model.Cell_Templet_Table + "',"); strSql.Append("fileRecording_Templet_Table='" + model.fileRecording_Templet_Table + "',"); strSql.Append("isDefault=" + model.isDefault + ","); strSql.Append("orderindex=" + model.orderindex + ","); strSql.Append("Recording_Templet_Name='" + model.Recording_Templet_Name + "',"); strSql.Append("tempid=" + model.tempid + ","); strSql.Append("UserTitle='" + model.UserTitle + "',"); strSql.Append("visible=" + model.visible + ""); strSql.Append(" where tempid=" + model.tempid + " "); DbHelperOleDb.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERM.MDL.ArchiveTemps Find(int tempid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" Cell_Templet_Name,Cell_Templet_Table,fileRecording_Templet_Table,isDefault,orderindex,Recording_Templet_Name,tempid,UserTitle,visible "); strSql.Append(" from ArchiveTemps "); strSql.Append(" where tempid=" + tempid + " "); ERM.MDL.ArchiveTemps model = new ERM.MDL.ArchiveTemps(); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { model.Cell_Templet_Name = ds.Tables[0].Rows[0]["Cell_Templet_Name"].ToString(); model.Cell_Templet_Table = ds.Tables[0].Rows[0]["Cell_Templet_Table"].ToString(); model.fileRecording_Templet_Table = ds.Tables[0].Rows[0]["fileRecording_Templet_Table"].ToString(); if (ds.Tables[0].Rows[0]["isDefault"].ToString() != "") { model.isDefault = int.Parse(ds.Tables[0].Rows[0]["isDefault"].ToString()); } if (ds.Tables[0].Rows[0]["orderindex"].ToString() != "") { model.orderindex = int.Parse(ds.Tables[0].Rows[0]["orderindex"].ToString()); } model.Recording_Templet_Name = ds.Tables[0].Rows[0]["Recording_Templet_Name"].ToString(); if (ds.Tables[0].Rows[0]["tempid"].ToString() != "") { model.tempid = int.Parse(ds.Tables[0].Rows[0]["tempid"].ToString()); } model.UserTitle = ds.Tables[0].Rows[0]["UserTitle"].ToString(); if (ds.Tables[0].Rows[0]["visible"].ToString() != "") { model.visible = int.Parse(ds.Tables[0].Rows[0]["visible"].ToString()); } return(model); } else { return(null); } }