public virtual tb_tasksyncmap_model CreateModel(DataRow dr)
{
var o = new tb_tasksyncmap_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if (dr.Table.Columns.Contains("fromtaskid"))
{
o.fromtaskid = dr["fromtaskid"].Toint();
}
//
if (dr.Table.Columns.Contains("totaskid"))
{
o.totaskid = dr["totaskid"].Toint();
}
//
if (dr.Table.Columns.Contains("createtime"))
{
o.createtime = dr["createtime"].ToDateTime();
}
return(o);
}
public virtual bool Add(DbConn PubConn, tb_tasksyncmap_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@fromtaskid", model.fromtaskid),
//
new ProcedureParameter("@totaskid", model.totaskid),
//
new ProcedureParameter("@createtime", model.createtime)
};
int rev = PubConn.ExecuteSql(@"insert into tb_tasksyncmap(fromtaskid,totaskid,createtime)
values(@fromtaskid,@totaskid,@createtime)" , Par);
return(rev == 1);
}
public virtual bool Edit(DbConn PubConn, tb_tasksyncmap_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@fromtaskid", model.fromtaskid),
//
new ProcedureParameter("@totaskid", model.totaskid),
//
new ProcedureParameter("@createtime", model.createtime),
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_tasksyncmap set fromtaskid=@fromtaskid,totaskid=@totaskid,createtime=@createtime where id=@id", Par);
return(rev == 1);
}
public List <tb_tasksyncmap_model> GetList(DbConn PubConn)
{
List <tb_tasksyncmap_model> model = new List <tb_tasksyncmap_model>();
DataSet dsList = SqlHelper.Visit <DataSet>(ps =>
{
string sql = "SELECT * FROM [ky_monitor].[dbo].[tb_tasksyncmap]";
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, ps.ToParameters());
return(ds);
});
foreach (DataRow dr in dsList.Tables[0].Rows)
{
tb_tasksyncmap_model m = CreateModel(dr);
model.Add(m);
}
return(model);
}
