[图]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threa...
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
namespace Computer
{
class DB
{
//连接数据库
static string conStr = "Data Source=DESKTOP-MJ25BUS;Initial Catalog=GoodsManager;User ID=sa;Password=123456";
SqlConnection con = new SqlConnection(conStr);
#region 读取电脑列表
public SqlDataReader GetComputerList()
{
try
{
//打开数据库
con.Open();
string sql = "Select * from UsersInfo";
SqlCommand command = new SqlCommand(sql, con);
return command.ExecuteReader();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
#endregion
#region 统计电脑数量
public int GetComputer()
{
try
{
con.Open();
string sql = "Select count(*) from UsersInfo";
SqlCommand command = new SqlCommand(sql, con);
int count = Convert.ToInt32(command.ExecuteScalar());
return count;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return -1;
}
finally
{
//关闭数据库
con.Close();
}
}
#endregion
#region 修改电脑信息
public int UpdateComputer(int id,string name,int price)
{
try
{
con.Open();
string sql = string.Format("Update UsersInfo Set pcName = {0} , pcPrice = {1} where id = {2}", name, price, id);
//执行增,删,改的SQL语句应用方法
SqlCommand command = new SqlCommand(sql, con);
return command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return -1;
}
finally
{
con.Close();
}
}
#endregion
}
class Manage
{
DB db = new DB();
#region 统计电脑记录
public void GetComputerCount()
{
int count = db.GetComputer();
Console.WriteLine("共有:" + count + "台电脑的记录");
}
#endregion
#region 菜单
public void ShowMenu()
{
bool flag = true;
do
{
Console.WriteLine("==================请选择操作键==================");
Console.WriteLine("1、查看全部电脑信息");
Console.WriteLine("2、修改电脑信息");
Console.WriteLine("3、统计所有电脑的数量");
Console.WriteLine("================================================");
int choose = int.Parse(Console.ReadLine());
switch (choose)
{
case 1:
GetAllComputer();
break;
case 2:
UpdateComputer();
break;
case 3:
GetComputerCount();
break;
}
} while (true);
}
#endregion
#region 读取电脑数据
public void GetAllComputer()
{
SqlDataReader reader = db.GetComputerList();
Console.WriteLine("编号\t电脑名称\t品牌编号\t是否到货\t价格\t\t配置\t\t备注\t时间");
while (reader.Read())
{
Console.WriteLine("{0}\t{1}\t{2}\t\t{3}\t\t{4}\t{5}\t{6}\t{7}", reader["Id"], reader["pcName"], reader["brandId"],reader["isReceive"],reader["pcPrice"],reader["pcDetail"],reader["pcRemark"],reader["timeStamp"]);
}
//关闭数据库
reader.Close();
}
#endregion
#region 修改电脑的信息
public void UpdateComputer()
{
Console.WriteLine("输入编号:");
int id = int.Parse(Console.ReadLine());
Console.WriteLine("输入电脑名称:");
string name = Console.ReadLine();
Console.WriteLine("输入电脑的价格:");
int price = int.Parse(Console.ReadLine());
int result = db.UpdateComputer(id, name, price);
if (result > 0)
{
Console.WriteLine("修改成功");
//调用查询所有花的方法
GetAllComputer();
}
else
{
Console.WriteLine("修改失败");
}
}
#endregion
}
internal class Program
{
static void Main(string[] args)
{
Manage manage = new Manage();
manage.ShowMenu();
Console.ReadLine();
}
}
}
这个是怎么回事啊,帮忙看看一下啊
我要接单
我要接单
一周热门 更多>