userdata.cs

本代码设计了一个销售管理系统

using System;
using System.Data;
using System.Data.SqlClient;

namespace UserData
{
	public class FPara
	{
		public static string ShopCode="";
		public static bool CheckLogin()
		{
			if(ShopCode=="")
			{
				return false;
			}
			else
			{
				return true;
			}
		}
		public static SqlConnection connStr=new SqlConnection("Server=localhost;uid=sa;pwd=123456;database=goods");
		public static SqlDataReader SqlReader(string sql,SqlConnection connstr)
		{
			SqlDataReader sqldr=null;
			SqlCommand cmd=new SqlCommand(sql,connstr);
			if (cmd.Connection.State.ToString()=="Closed") cmd.Connection.Open();
			try
			{
				sqldr=cmd.ExecuteReader();
			}
			catch(Exception e)
			{
				if (e!=null) sqldr=null;
			}
			return sqldr;
		}
		//数据库操作连接
		public static string SqlCmd(string sql,SqlConnection connstr)
		{
			string errorstr=null;
			SqlCommand sqlcmd= new SqlCommand(sql,connstr);
			if (sqlcmd.Connection.State.ToString()=="Open") sqlcmd.Connection.Close();
			sqlcmd.Connection.Open();
			try
			{
				sqlcmd.ExecuteNonQuery();
			}
			catch(Exception e)
			{
				if (e!=null) errorstr=e.ToString();
			}
			sqlcmd.Connection.Close();
			return errorstr;
		}
	}
}