private string getOperatorTypeDetail(string TypeCode, string WorkflowID)
{
DataTable dtTypeDetail = DbHelper.GetInstance().GetDBRecords("TypeDetailCode,DetailTypeName", "Workflow_OperatorTypeDetail", "TypeCode='" + TypeCode + "'", "TypeDetailCode");
List<OperatorTypeDetail> lotd = new List<OperatorTypeDetail>();
foreach (DataRow dr in dtTypeDetail.Rows)
{
OperatorTypeDetail otd = new OperatorTypeDetail();
otd.DetailTypeName = dr["DetailTypeName"].ToString();
otd.TypeDetailCode = Convert.ToInt32(dr["TypeDetailCode"]);
lotd.Add(otd);
}
List<OperatorTypeDetail> OperatorContents_list = ReDisplayOperatorContents(TypeCode, WorkflowID);
var griddata = new { OperatorTypeDetail = lotd, ObjectValue = OperatorContents_list };
string json = new JavaScriptSerializer().Serialize(griddata);
return json;
}
private List<OperatorTypeDetail> ReDisplayOperatorContents(string TypeCode,string WorkflowID)
{
DataTable dtObjectList = new DataTable();
if (TypeCode == "20")
{
dtObjectList = DbHelper.GetInstance().GetDBRecords("c.FieldID,c.FieldLabel,c.DisplayOrder",
"Workflow_Base b,Workflow_FormField c,Workflow_FieldDict d",
"b.FormID=c.FormID and c.FieldID=d.FieldID and d.HTMLTypeID=8 and d.BrowseType=3 and b.WorkflowID=" + WorkflowID,
"c.DisplayOrder");
}
else if (TypeCode == "30")
{
dtObjectList = DbHelper.GetInstance().GetDBRecords("c.FieldID,c.FieldLabel,c.DisplayOrder",
"Workflow_Base b,Workflow_FormField c,Workflow_FieldDict d",
"b.FormID=c.FormID and c.FieldID=d.FieldID and d.HTMLTypeID=8 and d.BrowseType=2 and b.WorkflowID=" + WorkflowID,
"c.DisplayOrder");
}
else if (TypeCode == "50")
{
//DataTable dtObjectList = DbHelper.GetInstance().GetDBRecords("a.NodeID,a.NodeName",
// "Workflow_FlowNode a,Workflow_FlowNode b",
// "a.WorkflowID=b.WorkflowID and b.NodeID=" + NodeID + " and a.NodeID != " + NodeID,
// "NodeID");
}
List<OperatorTypeDetail> lotd = new List<OperatorTypeDetail>();
foreach (DataRow dr in dtObjectList.Rows)
{
OperatorTypeDetail otd = new OperatorTypeDetail();
otd.DetailTypeName = dr["FieldLabel"].ToString();
otd.TypeDetailCode = Convert.ToInt32(dr["FieldID"]);
lotd.Add(otd);
}
return lotd;
}
