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