public FlexFieldGetBySearch ( long AtulProcessID, long AtulSubProcessID, long AtulActivityID ) : |
||
AtulProcessID | long | The atul process ID. |
AtulSubProcessID | long | The atul sub process ID. |
AtulActivityID | long | The atul activity ID. |
return |
public DataTable FlexFieldGetBySearch(long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID)
{
if (AtulProcessID == 0)
{
AtulProcessID = null;
}
if (AtulSubProcessID == 0)
{
AtulSubProcessID = null;
}
if (AtulActivityID == 0)
{
AtulActivityID = null;
}
SqlCommand cmd = new SqlCommand("exec dbo.Atul_FlexFieldGetBySearch_sp @AtulProcessID, @AtulSubProcessID, @AtulActivityID", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulSubProcessID", AtulSubProcessID));
cmd.Parameters.Add(new SqlParameter("@AtulActivityID", AtulActivityID));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "FlexFields";
da.Fill(returnTable);
return returnTable;
}
//needs nullable /// <summary> /// get the Flexfield by search. /// </summary> /// <param name="AtulProcessID">The atul process ID.</param> /// <param name="AtulSubProcessID">The atul sub process ID.</param> /// <param name="AtulActivityID">The atul activity ID.</param> /// <returns></returns> public string FlexFieldGetBySearch(long? AtulProcessID, long? AtulSubProcessID, long? AtulActivityID) { DataTable returnTable = new DataTable(); Atul_v1Data adb = new Atul_v1Data(); returnTable = adb.FlexFieldGetBySearch(AtulProcessID, AtulSubProcessID, AtulActivityID); return JsonMethods.GetJSONString(returnTable); }