file.cs

c#编写的人事管理系统源码 写得不错 值得收藏

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.IO;
using System.Data;
using System.Text;
using System.Data.OleDb;
namespace PM
{
	/// <summary>
	/// File 的摘要说明。
	/// </summary>
	public class File
	{

		//读指定路径的文件，并返回字符传
		public static string ReadText(int n)
		{
			StringBuilder sb = new StringBuilder();
			string str = "select * from ColName where colId=" + n;
			DataTable dt = new DataTable();
			Base bb = new Base();
			dt = bb.ExeSQLdt(str);
			for(int i = 0 ; i < dt.Rows.Count ; i ++)
			{
				sb.Append(dt.Rows[i]["colName"].ToString() + "#");
			}
			return sb.ToString();
		}

		//写文件，把CheckedListBox的选中项写进文件中
		public static void WriteText(int n,CheckedListBox clbox)
		{
			string s = "delete from ColName where colId=" + n ; 
			Base bb = new Base();
			bb.ExeSQL(s);
			StringBuilder sb = new StringBuilder();
			for(int i = 0 ; i < clbox.CheckedItems.Count; i ++)
			{
				sb.Append(clbox.CheckedItems[i].ToString() + "#");
			}
			string []ss = sb.ToString().Split('#');
			Base b;
			for(int i = 0 ; i < ss.Length - 1; i ++)
			{
				string str = "insert into ColName (colId,colName) values (" + n + ",'" + ss[i] + "')";
				b = new Base();
				b.ExeSQL(str);
			}
		}

		//检查CheckedListBox的选项和文件中的内容是否一致
		public static void CheckCol(CheckedListBox clbox,int n,DataTable dt)
		{
			string []ss = File.ReadText(n).Split('#');
			for(int i = 0 ; i < dt.Columns .Count ; i ++)
			{
				clbox.Items.Add(dt.Columns[i].ColumnName);
				for(int j = 0 ; j < ss.Length ; j ++)
				{
					if(ss[j] == clbox.Items[i].ToString())
					{
						clbox.SetItemCheckState(i,CheckState.Checked);
					}
				}
			}
		}

		//设置DataGrid的样式(参数不同，根据不同的参数调用不同的方法)
		public static void DataGridStyle(DataTable dt,DataGrid dg,DataGridTableStyle Grid)
		{
			Grid.MappingName = dt.TableName;
			Class1 c;
			for(int i = 0 ; i < dt.Columns.Count ; i ++)
			{
				c = new Class1();
				c.MappingName = dt.Columns[i].ColumnName;
				c.HeaderText = dt.Columns[i].ColumnName;
				c.NullText = "";
				c.Format = "D";
				Grid.GridColumnStyles.Add(c);
			}
			dg.TableStyles.Add(Grid);
			dg.Select(0);
		}

		//设置DataGrid的样式(参数不同，根据不同的参数调用不同的方法)
		public static void DataGridStyle(DataTable dt,DataGrid dg)
		{
			DataGridTableStyle Grid = new DataGridTableStyle();
			Grid.MappingName = dt.TableName;
			Class1 c;
			for(int i = 0 ; i < dt.Columns.Count ; i ++)
			{
				c = new Class1();
				c.MappingName = dt.Columns[i].ColumnName;
				c.HeaderText = dt.Columns[i].ColumnName;
				c.NullText = "";
				c.Format = "D";
				Grid.GridColumnStyles.Add(c);
			}
			dg.TableStyles.Add(Grid);
			Grid.GridColumnStyles[0].Width = 0;
			dg.Select(0);
		}

		//设置DataGrid的样式(参数不同，根据不同的参数调用不同的方法)
		public static void DataGridStyle(DataTable dt,int n,DataGrid dg)
		{
			try
			{
				string []ss = File.ReadText(n).Split('#');
				DataGridTableStyle Grid = new DataGridTableStyle();
				Grid.MappingName = dt.TableName;
				Class1 c;
				for(int i = 0 ; i < dt.Columns.Count ; i ++)
				{
					c = new Class1();
					c.MappingName = dt.Columns[i].ColumnName;
					c.HeaderText = dt.Columns[i].ColumnName;
					c.NullText = "";
					c.Format = "D";
					Grid.GridColumnStyles.Add(c);
					for(int j = 0 ; j < ss.Length - 1;j ++)
					{
						if(ss[j].Trim() == Grid.GridColumnStyles[i].HeaderText)
						{
							Grid.GridColumnStyles[i].Width = 0;
						}
					} 
				}
				dg.TableStyles.Add(Grid);
				dg.Select(0);
			}
			catch(Exception ee)
			{
			    MessageBox.Show(ee.ToString());
			}
		}

		//建立目录
		public static void IsDir(string path)
		{
			if(Directory.Exists(path))
			{
				return ;
			}
			else
			{
			    Directory.CreateDirectory(path);
			}
		}

		//显示图片
		public static Image showImage(string path)
		{
			Image image = null;
			if(System.IO.File.Exists(path))
			{
				FileStream fs = new FileStream(path,FileMode.Open,FileAccess.Read);
				byte [] b = new byte[1024000];
				fs.Read(b,0,b.Length);
				MemoryStream ms = new MemoryStream(b);
				image = Image.FromStream(ms,true);
				return image;
			}
			else
			{
			    return image;
			}
		}


		//保存图片
		public static void upImage(PictureBox pb,string path)
		{
		    Bitmap btp = new Bitmap(pb.Image);
		    btp.Save(path);
		}
	}
}