public RecieveMsgModel GetModel(Guid InstanceCode)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" v_yhdm,InstanceCode,TheOrder,LookUrl,RecieveUserCode,RecieveDate ");
builder.Append(" from WF_RecieveMsg ");
builder.Append(" where InstanceCode='" + InstanceCode + "' ");
RecieveMsgModel model = new RecieveMsgModel();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
model.v_yhdm = set.Tables[0].Rows[0]["v_yhdm"].ToString();
if (set.Tables[0].Rows[0]["InstanceCode"].ToString() != "")
{
model.InstanceCode = new Guid(set.Tables[0].Rows[0]["InstanceCode"].ToString());
}
if (set.Tables[0].Rows[0]["TheOrder"].ToString() != "")
{
model.TheOrder = new decimal?(decimal.Parse(set.Tables[0].Rows[0]["TheOrder"].ToString()));
}
model.LookUrl = set.Tables[0].Rows[0]["LookUrl"].ToString();
model.RecieveUserCode = set.Tables[0].Rows[0]["RecieveUserCode"].ToString();
if (set.Tables[0].Rows[0]["RecieveDate"].ToString() != "")
{
model.RecieveDate = DateTime.Parse(set.Tables[0].Rows[0]["RecieveDate"].ToString());
}
return(model);
}
public int Add(RecieveMsgModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" begin");
builder.Append(" insert into WF_RecieveMsg(");
builder.Append("v_yhdm,InstanceCode,TheOrder,LookUrl,RecieveUserCode,RecieveDate");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.v_yhdm + "',");
builder.Append("'" + model.InstanceCode + "',");
builder.Append(model.TheOrder + ",");
builder.Append("'" + model.LookUrl + "',");
builder.Append("'" + model.RecieveUserCode + "',");
builder.Append("'" + model.RecieveDate + "'");
builder.Append(")");
builder.Append(";select @@IDENTITY");
builder.Append(" end");
object obj2 = publicDbOpClass.ExecuteScalar(builder.ToString());
if (obj2 != null)
{
this.getPTDBSJ(obj2.ToString(), model.LookUrl, model.v_yhdm);
return(1);
}
return(0);
}
private void RecieveMsgAdd(string usercode)
{
RecieveMsgModel recieveMsgModel = new RecieveMsgModel();
recieveMsgModel.v_yhdm = usercode;
recieveMsgModel.TheOrder = new decimal?(1m);
recieveMsgModel.LookUrl = this.txtContent.Text;
recieveMsgModel.InstanceCode = this.InstanceCode;
recieveMsgModel.RecieveDate = System.DateTime.Now;
recieveMsgModel.RecieveUserCode = this.Session["yhdm"].ToString();
this.rma.Add(recieveMsgModel);
}
public int Update(RecieveMsgModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update WF_RecieveMsg set ");
builder.Append("v_yhdm='" + model.v_yhdm + "',");
builder.Append("TheOrder=" + model.TheOrder + ",");
builder.Append("LookUrl='" + model.LookUrl + "'");
builder.Append("RecieveUserCode='" + model.RecieveUserCode + "',");
builder.Append("RecieveDate='" + model.RecieveDate + "'");
builder.Append(" where InstanceCode='" + model.InstanceCode + "' ");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
private void AddMsg(string usercode)
{
RecieveMsgModel recieveMsgModel = new RecieveMsgModel();
recieveMsgModel.v_yhdm = usercode;
recieveMsgModel.TheOrder = new decimal?(1m);
string text;
if (this.RBLRoleType.SelectedValue == "-2")
{
text = "流程驳回";
}
else
{
if (this.RBLRoleType.SelectedValue == "1")
{
text = "流程通过";
}
else
{
text = "流程重报";
}
}
DataTable instanceMain = FlowAuditAction.GetInstanceMain(this.InstanceID);
string businessClassName = FlowAuditAction.GetBusinessClassName(instanceMain.Rows[0]["businesscode"].ToString(), instanceMain.Rows[0]["businessclass"].ToString());
RecieveMsgModel expr_B1 = recieveMsgModel;
string lookUrl = expr_B1.LookUrl;
expr_B1.LookUrl = string.Concat(new string[]
{
lookUrl,
businessClassName,
text,
"提醒",
this.txtContent.Value
});
recieveMsgModel.InstanceCode = this.InstanceCode;
recieveMsgModel.RecieveDate = System.DateTime.Now;
recieveMsgModel.RecieveUserCode = this.Session["yhdm"].ToString();
this.rma.Add(recieveMsgModel);
}