public InsertInstanceProcess ( int AtulProcessID, int CreatedBy, int OwnedBy, int AtulProcessStatusID ) : |
||
AtulProcessID | int | The atul process ID. |
CreatedBy | int | The created by. |
OwnedBy | int | The owned by. |
AtulProcessStatusID | int | The atul process status ID. |
리턴 |
public DataTable InsertInstanceProcess(int AtulProcessID, int CreatedBy, int OwnedBy, int AtulProcessStatusID)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_InstanceProcessInsert_sp @AtulProcessID, @CreatedBy, @OwnedBy, @AtulProcessStatusID", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulProcessID", AtulProcessID));
cmd.Parameters.Add(new SqlParameter("@CreatedBy", CreatedBy));
cmd.Parameters.Add(new SqlParameter("@OwnedBy", OwnedBy));
cmd.Parameters.Add(new SqlParameter("@AtulProcessStatusID", AtulProcessStatusID));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "atultblInstanceProcess";
da.Fill(returnTable);
return returnTable;
}
/// <summary> /// Inserts the instance process. /// </summary> /// <param name="AtulProcessID">The atul process ID.</param> /// <param name="CreatedBy">The created by.</param> /// <param name="OwnedBy">The owned by.</param> /// <param name="AtulProcessStatusID">The atul process status ID.</param> /// <returns></returns> public string InsertInstanceProcess(string AtulProcessID, string CreatedBy, string OwnedBy, string AtulProcessStatusID) { DataTable returnTable = new DataTable(); Atul_v1Data adb = new Atul_v1Data(); returnTable = adb.InsertInstanceProcess(Convert.ToInt32(AtulProcessID), Convert.ToInt32(CreatedBy), Convert.ToInt32(OwnedBy), Convert.ToInt32(AtulProcessStatusID)); return JsonMethods.GetJSONString(returnTable); }