public ActionResult Add(tb_messagequeue_model model, string node, string tablepartition,string daypartition) { DateTime serverdate = DateTime.Now; using (DbConn conn = DbConfig.CreateConn(DataConfig.MqManage)) { conn.Open(); serverdate = conn.GetServerDate(); } using (DbConn conn = DbConfig.CreateConn(DataConfig.DataNodeParConn(node))) { conn.Open(); model.sqlcreatetime = serverdate; model.mqcreatetime = DateTime.Now; string tablename = PartitionRuleHelper.GetTableName(Convert.ToInt32(tablepartition), DateTime.ParseExact(daypartition, "yyMMdd", CultureInfo.InvariantCulture)); var dal = new tb_messagequeue_dal();dal.TableName=tablename; if (dal.Add(conn, tablename, model)) { return RedirectToAction("index"); } else { ModelState.AddModelError("Error", "更新错误"); return View(model); } } }
public virtual bool AddMove(DbConn PubConn, tb_messagequeue_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq�������߶˵Ĵ���ʱ�䣨�����߶�ʱ����ܸ�������ʱ�䲻һ�£� new ProcedureParameter("@mqcreatetime", model.mqcreatetime), //��Ϣ����,0=�ɶ���Ϣ��1=��Ǩ����Ϣ new ProcedureParameter("@state", model.state), //��Դ����:0 ��ʾ ��������,1 ��ʾ Ǩ����Ϣ new ProcedureParameter("@source", model.source), //��Ϣ�壨��Ϣ����,��json��ʽ�洢��Ϊ���Ķ����ǣ� new ProcedureParameter("@message", model.message) }; int rev = PubConn.ExecuteSql(string.Format(@"insert into {0}(mqcreatetime,sqlcreatetime,state,source,message) values(@mqcreatetime,getdate(),@state,@source,@message)", TableName), Par); return rev == 1; }
public bool Add(DbConn conn, string tableName, tb_messagequeue_model model) { return SqlHelper.Visit((ps) => { string sql = string.Format("insert into {0}(mqcreatetime,sqlcreatetime,state,source,message) values(@mqcreatetime,@sqlcreatetime,@state,@source,@message)", tableName); List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq�������߶˵Ĵ���ʱ�䣨�����߶�ʱ����ܸ�������ʱ�䲻һ�£� new ProcedureParameter("@mqcreatetime", model.mqcreatetime), //sql���ݽڵ㴦�Ĵ���ʱ�� new ProcedureParameter("@sqlcreatetime", model.sqlcreatetime), //��Ϣ����,0=�ɶ���Ϣ��1=��Ǩ����Ϣ new ProcedureParameter("@state", model.state), //��Դ����:0 ��ʾ ��������,1 ��ʾ Ǩ����Ϣ new ProcedureParameter("@source", model.source), //��Ϣ�壨��Ϣ����,��json��ʽ�洢��Ϊ���Ķ����ǣ� new ProcedureParameter("@message", model.message) }; int rev = conn.ExecuteSql(sql, Par); return rev == 1; }); }
public virtual tb_messagequeue_model CreateModel(DataRow dr) { var o = new tb_messagequeue_model(); //��Ϣid��,����1+���ݽڵ���+��������+ʱ�������+����id if(dr.Table.Columns.Contains("id")) { o.id = dr["id"].Tolong(); } //mq�������߶˵Ĵ���ʱ�䣨�����߶�ʱ����ܸ�������ʱ�䲻һ�£� if(dr.Table.Columns.Contains("mqcreatetime")) { o.mqcreatetime = dr["mqcreatetime"].ToDateTime(); } //sql���ݽڵ㴦�Ĵ���ʱ�� if(dr.Table.Columns.Contains("sqlcreatetime")) { o.sqlcreatetime = dr["sqlcreatetime"].ToDateTime(); } //��Ϣ����,0=�ɶ���Ϣ��1=��Ǩ����Ϣ if(dr.Table.Columns.Contains("state")) { o.state = dr["state"].ToByte(); } //��Դ����:0 ��ʾ ��������,1 ��ʾ Ǩ����Ϣ if(dr.Table.Columns.Contains("source")) { o.source = dr["source"].ToByte(); } //��Ϣ�壨��Ϣ����,��json��ʽ�洢��Ϊ���Ķ����ǣ� if(dr.Table.Columns.Contains("message")) { o.message = dr["message"].Tostring(); } return o; }
public virtual bool Edit(DbConn PubConn, tb_messagequeue_model model) { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq�������߶˵Ĵ���ʱ�䣨�����߶�ʱ����ܸ�������ʱ�䲻һ�£� new ProcedureParameter("@mqcreatetime", model.mqcreatetime), //sql���ݽڵ㴦�Ĵ���ʱ�� new ProcedureParameter("@sqlcreatetime", model.sqlcreatetime), //��Ϣ����,0=�ɶ���Ϣ��1=��Ǩ����Ϣ new ProcedureParameter("@state", model.state), //��Դ����:0 ��ʾ ��������,1 ��ʾ Ǩ����Ϣ new ProcedureParameter("@source", model.source), //��Ϣ�壨��Ϣ����,��json��ʽ�洢��Ϊ���Ķ����ǣ� new ProcedureParameter("@message", model.message) }; Par.Add(new ProcedureParameter("@id", model.id)); int rev = PubConn.ExecuteSql("update tb_messagequeue set mqcreatetime=@mqcreatetime,sqlcreatetime=@sqlcreatetime,state=@state,source=@source,message=@message where id=@id", Par); return rev == 1; }
public bool Update(DbConn conn, tb_messagequeue_model model, string tableName) { return SqlHelper.Visit((ps) => { List<ProcedureParameter> Par = new List<ProcedureParameter>() { //mq�������߶˵Ĵ���ʱ�䣨�����߶�ʱ����ܸ�������ʱ�䲻һ�£� new ProcedureParameter("@mqcreatetime", model.mqcreatetime), //sql���ݽڵ㴦�Ĵ���ʱ�� new ProcedureParameter("@sqlcreatetime", model.sqlcreatetime), //��Ϣ����,0=�ɶ���Ϣ��1=��Ǩ����Ϣ new ProcedureParameter("@state", model.state), //��Դ����:0 ��ʾ ��������,1 ��ʾ Ǩ����Ϣ new ProcedureParameter("@source", model.source), //��Ϣ�壨��Ϣ����,��json��ʽ�洢��Ϊ���Ķ����ǣ� new ProcedureParameter("@message", model.message) }; Par.Add(new ProcedureParameter("@id", model.id)); string sql = string.Format("update {0} set mqcreatetime=@mqcreatetime,sqlcreatetime=@sqlcreatetime,state=@state,source=@source,message=@message where id=@id", tableName); int rev = conn.ExecuteSql(sql, Par); return rev == 1; }); }
public ActionResult Update(tb_messagequeue_model model, string node, long id) { ViewBag.node = node; var mqidinfo = XXF.BaseService.MessageQuque.BusinessMQ.SystemRuntime.PartitionRuleHelper.GetMQIDInfo(Convert.ToInt64(id)); ViewBag.tablepartition = mqidinfo.TablePartition; ViewBag.daypartition = mqidinfo.Day.ToString("yyMMdd"); string tablename = PartitionRuleHelper.GetTableName(mqidinfo.TablePartition, mqidinfo.Day); var dal = new tb_messagequeue_dal(); dal.TableName = tablename; using (DbConn conn = DbConfig.CreateConn(DataConfig.DataNodeParConn(node))) { conn.Open(); tb_messagequeue_model result = dal.GetModel(conn, id, tablename); if (result != null) { result.message = model.message; result.state = model.state; result.source = model.source; if (dal.Update(conn, result, tablename)) { return RedirectToAction("Index", new { node =node, tablepartition = XXF.BaseService.MessageQuque.BusinessMQ.SystemRuntime.PartitionRuleHelper.PartitionNameRule( mqidinfo.TablePartition), daypartition = mqidinfo.Day.ToString("yyMMdd"), mqid = id }); } } ModelState.AddModelError("Error", "更新错误"); return View(result); } }