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);
}
