基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 10 元　

支付宝支付

微信支付

   源码介绍

---

SQL C# 做的库存管理小程序，程序具备完整的用户管理，库存管理功能，看一下学习，也可以直接使用

SQL的数据库，压缩包内的脚本文件直接执行即可，免除了SQL版本兼容性异常麻烦

using System;
using System.Diagnostics;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;
using KCManageSys.CommMethod;
using System.IO;


namespace KCManageSys.CommMethod
{
    static class SqlHelper
    {
        public static SqlConnection GetSqlConnection()
        {
            //string strConn = "server=.;database=KCManageSys;uid=sa;pwd=test";
            string s = Directory.GetCurrentDirectory()  "\\sql.exe .config";
            string strConn = xmlHelper.readXml(s);
            SqlConnection connection = null;
            try
            {
                connection = new SqlConnection(strConn);
                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                } 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return connection;
        }

        public static SqlDataReader getReader(string strCmd)
        {
            SqlDataReader reader = null;
            try
            {
                SqlConnection connection = GetSqlConnection();
                SqlCommand command = new SqlCommand(strCmd, connection);
                reader = command.ExecuteReader();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return reader;
        }

        public static DataTable getTabel(string strCmdText)
        {
            DataTable table = new DataTable();
            try
            {
                SqlConnection connection = GetSqlConnection();
                SqlCommand command = new SqlCommand(strCmdText, connection);
                SqlDataAdapter adapter = new SqlDataAdapter(command);
;               adapter.Fill(table);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return table;
        }

        public static bool updateTable(string strCmdText)
        {
            bool flag = false;
            try
            {
                SqlConnection connection = GetSqlConnection();
                SqlCommand command = new SqlCommand(strCmdText, connection);
                int i=command.ExecuteNonQuery();
                if (i > 0)
                {
                    flag = true;
                }
                else
                {
                    flag = false;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return flag;
        }

    }
}