private void ProcedureControllCreate(string pName, ProcedureControll.FncType type, SQL_Helper.Parameter[] buf_p)
{
dgv_Data.Visible = false;
dgv_Data.Enabled = false;
pc = new ProcedureControll(pName, buf_p);
pc.Function_Type = type;
pc.sendMessage += new ProcedureControll.SendMessage(GetMessage);
pc.Size = p_ContentHolder.Size;
p_ContentHolder.Controls.Add(pc);
}
private void GetMessage()
{
var p = pc.parameters;
if (pc.Function_Type == ProcedureControll.FncType.Scalar)
{
SQL_Helper.Parameter res = new SQL_Helper.Parameter();
try
{
res = SQL_Helper.getInstance().SQL_Scalarfunction(pc.ProcedureName, p);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
Type t = res.type;
pc_scalar_res = new SQL_Helper.Parameter();
pc_scalar_res.value = res;
pc_scalar_res.type = t;
}
else if (pc.Function_Type == ProcedureControll.FncType.Table)
{
DataTable dt = new DataTable();
try
{
dt = SQL_Helper.getInstance().SQL_Tablefunction(pc.ProcedureName, p);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
dgv_Data.DataSource = dt;
}
else if (pc.Function_Type == ProcedureControll.FncType.StoredProcedure)
{
SQL_Helper.getInstance().SQL_StoredProcedure(pc.ProcedureName, p);
}
fnc_Type = pc.Function_Type;
ResetWindow();
}
