public virtual bool Edit(DbConn PubConn, tb_version_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@version", model.version), // new ProcedureParameter("@versioncreatetime", model.versioncreatetime), //压缩文件二进制文件 new ProcedureParameter("@zipfile", model.zipfile), // new ProcedureParameter("@zipfilename", model.zipfilename) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_version set taskid=@taskid,version=@version,versioncreatetime=@versioncreatetime,zipfile=@zipfile,zipfilename=@zipfilename where id=@id", Par); return rev == 1; }
public virtual bool Add(DbConn PubConn, tb_version_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { // new ProcedureParameter("@taskid", model.taskid), // new ProcedureParameter("@version", model.version), // new ProcedureParameter("@versioncreatetime", model.versioncreatetime), //压缩文件二进制文件 new ProcedureParameter("@zipfile", model.zipfile), // new ProcedureParameter("@zipfilename", model.zipfilename) }; int rev = PubConn.ExecuteSql(@"insert into tb_version(taskid,version,versioncreatetime,zipfile,zipfilename) values(@taskid,@version,@versioncreatetime,@zipfile,@zipfilename)", Par); return rev == 1; }
public virtual tb_version_model CreateModel(DataRow dr) { var o = new tb_version_model(); // if(dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } // if(dr.Table.Columns.Contains("taskid")) { o.taskid = dr["taskid"].Toint(); } // if(dr.Table.Columns.Contains("version")) { o.version = dr["version"].Toint(); } // if(dr.Table.Columns.Contains("versioncreatetime")) { o.versioncreatetime = dr["versioncreatetime"].ToDateTime(); } //压缩文件二进制文件 if(dr.Table.Columns.Contains("zipfile")) { o.zipfile = dr["zipfile"].ToBytes(); } // if(dr.Table.Columns.Contains("zipfilename")) { o.zipfilename = dr["zipfilename"].Tostring(); } return o; }