Exemplos de ucLeverContact.getInsertSql em C# (CSharp)

Exemplo n.º 1

        private void btnconfirm_Click(object sender, EventArgs e)
        {
            string sql = "delete from T_OPER_LEVEL_RELA";

            Sqls.Add(sql);                             //包删除语句添加进去集合
            ffding.getInsertSql(ref Sqls);             //添加一条等级是丁的sql语句
            ffbing.getInsertSql(ref Sqls);             //添加一条等级是丙的sql语句
            ffyi.getInsertSql(ref Sqls);               //添加一条等级是乙的sql语句
            ffjia.getInsertSql(ref Sqls);              //添加一条等级是甲的sql语句

            string[] strsqls = new string[Sqls.Count]; //定义个string数组 个数等于sqls个数
            for (int i = 0; i < Sqls.Count; i++)
            {
                strsqls[i] = Sqls[i].ToString(); //把sqls的每一项赋值给strsqls
            }
            if (App.ExecuteBatch(strsqls) > 0)   //一起执行
            {
                App.Msg("操作已经成功！");
            }
        }