public virtual tb_mqpath_model CreateModel(DataRow dr) { var o = new tb_mqpath_model(); // if(dr.Table.Columns.Contains("id")) { o.id = dr["id"].Toint(); } //mq·�� if(dr.Table.Columns.Contains("mqpath")) { o.mqpath = dr["mqpath"].Tostring(); } //��·����mq,����������ʱ��(�Ե�ǰ��ʱ��Ϊ) if(dr.Table.Columns.Contains("lastupdatetime")) { o.lastupdatetime = dr["lastupdatetime"].ToDateTime(); } //mq����ʱ��(�Ե�ǰ��ʱ��Ϊ) if(dr.Table.Columns.Contains("createtime")) { o.createtime = dr["createtime"].ToDateTime(); } return o; }
public virtual bool Add(DbConn PubConn, tb_mqpath_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq·�� new ProcedureParameter("@mqpath", model.mqpath), //��·����mq,����������ʱ��(�Ե�ǰ��ʱ��Ϊ) new ProcedureParameter("@lastupdatetime", model.lastupdatetime), //mq����ʱ��(�Ե�ǰ��ʱ��Ϊ) new ProcedureParameter("@createtime", model.createtime) }; int rev = PubConn.ExecuteSql(@"insert into tb_mqpath(mqpath,lastupdatetime,createtime) values(@mqpath,@lastupdatetime,@createtime)", Par); return rev == 1; }
public virtual bool Edit(DbConn PubConn, tb_mqpath_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq·�� new ProcedureParameter("@mqpath", model.mqpath), //��·����mq,����������ʱ��(�Ե�ǰ��ʱ��Ϊ) new ProcedureParameter("@lastupdatetime", model.lastupdatetime), //mq����ʱ��(�Ե�ǰ��ʱ��Ϊ) new ProcedureParameter("@createtime", model.createtime) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_mqpath set mqpath=@mqpath,lastupdatetime=@lastupdatetime,createtime=@createtime where id=@id", Par); return rev == 1; }
public ActionResult Update(tb_mqpath_model model) { using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage)) { conn.Open(); tb_mqpath_model result = pathDal.Get(conn, model.id); if (result != null) { result.mqpath = model.mqpath; result.lastupdatetime = DateTime.Now; if (pathDal.Edit(conn, result)) { return RedirectToAction("index"); } } ModelState.AddModelError("Error", "更新错误"); return View(result); } }