示例#1
0
        private void ���Դ洢����ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Database db = new Database("Data Source=.;Initial Catalog=NewSystem;Integrated Security=True");//TestForSmartTools HR_JC
            //db.AddStoreProcedure("CustOrderHist2");
            //db.AddStoreProcedure("CustOrderHist3");
            db.GetAllStoreProcedure();

            foreach ( Model.StoreProcedure sp in db.StoreProcedures )
            {
                if (sp.Name=="GetUserMenu")
                {
                    sp.ProcExecuteReturnType = Model.StoreProcedure.ExecuteReturnType.DataTable;
                }
                else
                {
                    db.StoreProcedures.Remove(sp);
                }
            }

            //db.GetStoreProcedure("GetUserMenu");
            //db.AddStoreProcedure("CustOrderHist2");
            //db.GetStoreProcedure("CustOrderHist2").NeedReturnValue = true;
            //db.GetStoreProcedure("CustOrderHist2").ProcExecuteReturnType = Model.StoreProcedure.ExecuteReturnType.DataTable;
            //db.AddStoreProcedure("CustOrderHist3");
            //db.GetStoreProcedure("CustOrderHist3").NeedReturnValue = false;
            //db.GetStoreProcedure("CustOrderHist3").ProcExecuteReturnType = Model.StoreProcedure.ExecuteReturnType.Scalar;

            SqlStorProcExecCode sec = new SqlStorProcExecCode(db.StoreProcedures, true, false, null, null, null, "SqlHelper");

            ShowCSharpCode scc = new ShowCSharpCode(sec.GetCode());
            scc.Show(dp);
        }
示例#2
0
        private void createDataBaseToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Database db = new Database("Data Source=.;Persist Security Info=True;User ID=sa;Password=;Initial Catalog=TestForSmartTools;");
            db.GetAllTable();
            db.GetAllView();
            db.GetAllStoreProcedure();
            //retVal = db.AddTable("TABLE1");
            //retVal = db.AddView("Invoices");
            //retVal = db.AddStoreProcedure("CustOrderHist3");

            MessageBox.Show(db.StoreProcedures[0].CreateCmdText);
        }
示例#3
0
        private void ���Դ洢����ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Database db = new Database("Data Source=.;Persist Security Info=True;User ID=sa;Password=sa;Initial Catalog=RewardLife;");//TestForSmartTools HR_JC
            //db.AddStoreProcedure("CustOrderHist2");
            //db.AddStoreProcedure("CustOrderHist3");
            db.GetAllStoreProcedure();

            //db.AddStoreProcedure("CustOrderHist2");
            //db.GetStoreProcedure("CustOrderHist2").NeedReturnValue = true;
            //db.GetStoreProcedure("CustOrderHist2").ProcExecuteReturnType = Model.StoreProcedure.ExecuteReturnType.DataTable;
            //db.AddStoreProcedure("CustOrderHist3");
            //db.GetStoreProcedure("CustOrderHist3").NeedReturnValue = false;
            //db.GetStoreProcedure("CustOrderHist3").ProcExecuteReturnType = Model.StoreProcedure.ExecuteReturnType.Scalar;

            SqlStorProcExecCode sec = new SqlStorProcExecCode(db.StoreProcedures, false, true, null, null, null, null);

            ShowCSharpCode scc = new ShowCSharpCode(sec.GetCode());
            scc.Show(dp);
        }