/// <summary>
/// 关键字 查询 按工作ID查
/// </summary>
/// <returns></returns>
public string KeySearchByWorkID(string content, string ck)
{
int workid = 0;
string sql = "";
try
{
workid = int.Parse(content);
}
catch
{
//this.Alert("您输入的不是一个WorkID" + content);
//return;
}
if (ck.ToUpper() == "TRUE")
{
sql = "SELECT A.*,B.Name as FlowName FROM V_FlowData a,WF_Flow b WHERE A.FK_Flow=B.No AND A.OID=" + workid + " AND FlowEmps LIKE '%@" + WebUser.No + ",%'";
}
else
{
sql = "SELECT A.*,B.Name as FlowName FROM V_FlowData a,WF_Flow b WHERE A.FK_Flow=B.No AND A.OID=" + workid;
}
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取抄送列表
/// </summary>
/// <returns></returns>
private string GetCCList()
{
DataTable dt = null;
string strCCSta = getUTF8ToString("ccSta");
//全部
if (strCCSta == "all")
{
dt = BP.WF.Dev2Interface.DB_CCList(WebUser.No);
}
//未读
if (strCCSta == "unread")
{
dt = BP.WF.Dev2Interface.DB_CCList_UnRead(WebUser.No);
}
//已读
if (strCCSta == "isread")
{
dt = BP.WF.Dev2Interface.DB_CCList_Read(WebUser.No);
}
//删除
if (strCCSta == "delete")
{
dt = BP.WF.Dev2Interface.DB_CCList_Delete(WebUser.No);
}
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 改变数据状态 2013.05.23 H
/// </summary>
/// <returns></returns>
public string UpdateMsgSta()
{
string myPK = getUTF8ToString("myPK");
DataTable dt = BP.WF.Dev2Interface.DB_GenerUpdateMsgSta(myPK);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取历史发起
/// </summary>
/// <returns></returns>
private string GetHistoryStartFlow()
{
string fk_flow = getUTF8ToString("FK_FLOW");
Flow startFlow = new Flow(fk_flow);
string sql = "SELECT * FROM " + startFlow.PTable + " WHERE FlowStarter='" + WebUser.No + "'";
DataTable dt = startFlow.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取挂起流程
/// </summary>
/// <returns></returns>
private string GetHungUpList()
{
DataTable dt = BP.WF.Dev2Interface.DB_GenerHungUpList();
foreach (DataColumn column in dt.Columns)
{
column.ColumnName = column.ColumnName.ToUpper();
}
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 月计划汇总
/// </summary>
/// <returns></returns>
private string MonthPlanCollect()
{
string sql = "SELECT a.* ,b.FK_Flow,b.FK_Node,b.FlowName,b.NodeName,b.IsRead,b.Starter,b.ADT,b.SDT,b.WorkID FROM ND22Rpt"
+ " a , WF_EmpWorks b WHERE a.OID=B.WorkID AND b.WFState not in (7)"
+ " AND b.FK_Emp='" + WebUser.No + "'"
+ " ORDER BY ADT DESC";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 详细 信息 2013.05.23 H
/// </summary>
/// <returns></returns>
public string GetDetailSms()
{
string myPK = getUTF8ToString("myPK");
string sql = "";
sql = "SELECT * FROM Sys_SMS WHERE MyPK='" + myPK + "'";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 弹出 窗口 2013.05.23 H
/// </summary>
/// <returns></returns>
public string PopAlert()
{
// IsRead = 0 未读
string type = getUTF8ToString("type");
DataTable dt = BP.WF.Dev2Interface.DB_GenerPopAlert(type);
if (dt.Rows.Count >= 1)
{
return(CommonDbOperator.GetJsonFromTable(GetNewDataTable(dt)));
}
else
{
return("");
}
}
/// <summary>
/// 关键字 查询 按流程标题字段关键字查
/// </summary>
/// <returns></returns>
public string KeySearchByTitle(string content, string ck)
{
string sql = "";
if (ck.ToUpper() == "TRUE")
{
sql = "SELECT A.*,B.Name as FlowName FROM V_FlowData a,WF_Flow b WHERE A.FK_Flow=B.No AND a.Title LIKE '%" + content + "%' AND FlowEmps LIKE '%@" + WebUser.No + ",%'";
}
else
{
sql = "SELECT A.*,B.Name as FlowName FROM V_FlowData a,WF_Flow b WHERE A.FK_Flow=B.No AND a.Title LIKE '%" + content + "%'";
}
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取历史流程信息
/// </summary>
public string GetStoryHistory()
{
string fk_flow = "";
if (!string.IsNullOrEmpty(Request["FK_Flow"]))
{
fk_flow = Request["FK_Flow"].ToString();
}
Flow fl = new Flow(fk_flow);
string sql = "";
sql = "SELECT " + fl.HistoryFields + ",OID,FID FROM " + fl.PTable + " WHERE FlowStarter='" + BP.Web.WebUser.No + "' AND WFState!='" + (int)WFState.Blank + "'" + " ORDER by OID DESC";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 取回 审批
/// </summary>
/// <returns></returns>
public string Gettask()
{
Flows fls = new Flows();
BP.En.QueryObject qo = new BP.En.QueryObject(fls);
qo.addOrderBy(FlowAttr.FK_FlowSort);
qo.DoQuery();
//将集合 转换为datatable
DataTable dt = new DataTable("Flows");
DataColumn dc0 = new DataColumn("No", Type.GetType("System.String")); //编号
DataColumn dc1 = new DataColumn("FK_FlowSortText", Type.GetType("System.String")); //流程类别
DataColumn dc2 = new DataColumn("Name", Type.GetType("System.String")); //名称
DataColumn dc3 = new DataColumn("FlowImage", Type.GetType("System.String")); //流程图
DataColumn dc4 = new DataColumn("Note", Type.GetType("System.String")); //描述
dt.Columns.Add(dc0);
dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
dt.Columns.Add(dc3);
dt.Columns.Add(dc4);
foreach (Flow fl in fls)
{
DataRow dr = dt.NewRow();
dr["No"] = fl.No;
dr["FK_FlowSortText"] = fl.FK_FlowSortText;
dr["Name"] = fl.Name;
dr["FlowImage"] = fl.No;
dr["Note"] = fl.Note;
dt.Rows.Add(dr);
}
//将dt以json的格式 返回
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取待办列表
/// </summary>
/// <returns></returns>
private string GetEmpWorks()
{
DataTable dt = BP.WF.Dev2Interface.DB_GenerEmpWorksOfDataTable();
return(CommonDbOperator.GetJsonFromTable(dt));
}
/// <summary>
/// 获取启动流程项
/// </summary>
/// <returns></returns>
private string GetSartFlow()
{
DataTable dt = BP.WF.Dev2Interface.DB_GenerCanStartFlowsOfDataTable(WebUser.No);
return(CommonDbOperator.GetJsonFromTable(dt));
}