public virtual tb_cluster_collect_version_model CreateModel(DataRow dr) { var o = new tb_cluster_collect_version_model(); // if (dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } // if (dr.Table.Columns.Contains("versionnum")) { o.versionnum = dr["versionnum"].Toint(); } // if (dr.Table.Columns.Contains("versioncreatetime")) { o.versioncreatetime = dr["versioncreatetime"].ToDateTime(); } // if (dr.Table.Columns.Contains("zipfilename")) { o.zipfilename = dr["zipfilename"].Tostring(); } // if (dr.Table.Columns.Contains("zipfile")) { o.zipfile = dr["zipfile"].ToBytes(); } return(o); }
public List <tb_cluster_collect_version_model> GetList(DbConn PubConn, int pagesize, int pageindex, out int count) { int _count = 0; List <tb_cluster_collect_version_model> model = new List <tb_cluster_collect_version_model>(); try { DataSet dsList = SqlHelper.Visit <DataSet>(ps => { StringBuilder sql = new StringBuilder(); sql.Append("select ROW_NUMBER() over(order by id desc) as rownum,* from tb_cluster_collect_version "); _count = Convert.ToInt32(PubConn.ExecuteScalar("select count(1) from tb_cluster_collect_version ", ps.ToParameters())); DataSet ds = new DataSet(); string sqlSel = "select * from (" + sql + ") A where rownum between " + ((pageindex - 1) * pagesize + 1) + " and " + pagesize * pageindex; PubConn.SqlToDataSet(ds, sqlSel, ps.ToParameters()); return(ds); }); foreach (DataRow dr in dsList.Tables[0].Rows) { tb_cluster_collect_version_model m = CreateModel(dr); model.Add(m); } } catch (Exception exp) { } count = _count; return(model); }
public ActionResult Add(HttpPostedFileBase filedll) { if (filedll == null) { ModelState.AddModelError("Error", "请选择上传文件"); return(View()); } Stream dll = filedll.InputStream; byte[] dllbyte = new byte[dll.Length]; dll.Read(dllbyte, 0, Convert.ToInt32(dll.Length)); try { tb_cluster_collect_version_dal dal = new tb_cluster_collect_version_dal(); using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString)) { PubConn.Open(); tb_cluster_collect_version_model model = new tb_cluster_collect_version_model() { versionnum = dal.GetMaxVersion(PubConn), versioncreatetime = DateTime.Now, zipfile = dllbyte, zipfilename = filedll.FileName }; dal.Add(PubConn, model); return(RedirectToAction("index")); } } catch (Exception ex) { ModelState.AddModelError("Error", ex.Message); return(View()); } }
public int Update(DbConn PubConn, tb_cluster_collect_version_model model) { return(SqlHelper.Visit(ps => { ps.Add("id", model.id); ps.Add("versionnum", model.versionnum); ps.Add("zipfilename", model.zipfilename); ps.Add("zipfile", model.zipfile); string sql = "update tb_cluster_collect_version set versionnum=@versionnum,versioncreatetime=getdate(),zipfilename=@zipfilename,zipfile=@zipfile where id=@id"; return PubConn.ExecuteSql(sql, ps.ToParameters()); })); }
public virtual bool Add(DbConn PubConn, tb_cluster_collect_version_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@versionnum", model.versionnum), // new ProcedureParameter("@versioncreatetime", model.versioncreatetime), // new ProcedureParameter("@zipfilename", model.zipfilename), // new ProcedureParameter("@zipfile", model.zipfile) }; int rev = PubConn.ExecuteSql(@"insert into tb_cluster_collect_version(versionnum,versioncreatetime,zipfilename,zipfile) values(@versionnum,@versioncreatetime,@zipfilename,@zipfile)" , Par); return(rev == 1); }
public virtual bool Edit(DbConn PubConn, tb_cluster_collect_version_model model) { List <ProcedureParameter> Par = new List <ProcedureParameter>() { // new ProcedureParameter("@versionnum", model.versionnum), // new ProcedureParameter("@versioncreatetime", model.versioncreatetime), // new ProcedureParameter("@zipfilename", model.zipfilename), // new ProcedureParameter("@zipfile", model.zipfile) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_cluster_collect_version set versionnum=@versionnum,versioncreatetime=@versioncreatetime,zipfilename=@zipfilename,zipfile=@zipfile where id=@id", Par); return(rev == 1); }