data.cs

介绍学习的管理系统说明什么的

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using DataAccess;

/// <summary>
/// data 的摘要说明
/// </summary>
public class data : System.Web.UI.Page
{
	public data()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//

      
	} 
   /// <summary>
   /// 显示农机主织的基本信息
   /// </summary>
    public void rOrganization(string card,Label Faren,Label Ftele,Label Fmove,Label liaxiren ,Label ltele,Label lmove,Label addess)
        {
            SqlDataReader read; 
            DataBase organ = new DataBase();
            read = organ.QueryDataReader("select * from rOrganization where AIDCard ='"+card+"'");
            if (read.Read())
            {
                Faren.Text = read["Faren"].ToString();
                Ftele.Text = read["ATelephone"].ToString();
                Fmove.Text = read["Movephone"].ToString();
                addess.Text = read["Address"].ToString();
                liaxiren.Text = read["member"].ToString();
                ltele.Text = read["tele"].ToString();
                lmove.Text = read["move"].ToString();
            }
            read.Close();
       }

    /// <summary>
    /// 插入Model表
    /// </summary>
    /// <param name="card">农机组织账号</param>
    /// <param name="MachName">机器类型</param>
    /// <param name="aModel">机器型号</param>
    /// <param name="Mach">机器介绍</param>
    /// <param name="carer">车主</param>
    /// <param name="cartele">车主电话</param>
    public void insert_Model(string card,string MachName,string aModel,string Mach,string  carer,string cartele)
    {
        SqlParameter[] prams ={
            new SqlParameter("@AIDCard",card),
            new SqlParameter("@MachName",MachName),
            new SqlParameter("@aModel",aModel),
            new SqlParameter("@Mach",Mach),
            new SqlParameter("@carer",carer),
            new SqlParameter("@cartele",cartele)
        };
        DataBase p = new DataBase();
        p.RunProc("add_MODEL", prams);
        
    }
    /// <summary>
    /// 填充GridView
    /// </summary>
    /// <param name="gr">GridView</param>
    /// <param name="sql">生成视图的sql语句</param>
    public int grive(GridView gr,string sql)
    {
        DataBase v = new DataBase();
        DataSet view = v.QueryDataSet(sql);
        gr.DataSource = view;
        gr.DataBind();
        return view.Tables[0].DefaultView.Count;
    }
    /// <summary>
    /// 更新农机组织机器表
    /// </summary>
    /// <param name="MID">机器编号</param>
    /// <param name="MachName">机器类型</param>
    /// <param name="aModel">机器型号</param>
    /// <param name="Mach">机器介绍</param>
    /// <param name="carer">车主</param>
    /// <param name="cartile">车主电话</param>
    public string up_MODEL(string MID,string MachName,string aModel,string Mach,string carer,string cartele)
    {
        string a = "ok";
        try
        {
            SqlParameter[] prams ={
            new SqlParameter("@id","1"),
            new SqlParameter("@MID",MID),
            new SqlParameter("@MachName",MachName),
            new SqlParameter("@aModel",aModel),
            new SqlParameter("@Mach",Mach),
            new SqlParameter("@carer",carer),
            new SqlParameter("@cartele",cartele)
        };
            DataBase p = new DataBase();
            p.RunProc("up_MODEL", prams);
        }
        catch (Exception er)
        {
            a = er.Message.ToString();
        }
        return a;
    }
    /// <summary>
    /// 删除农机组织机器表
    /// </summary>
    /// <param name="MID">机器ID</param>
    /// <returns></returns>
    public string deL_MODEL(string MID)
    {
        string a = "ok";
        try
        {
            SqlParameter[] prams ={
            new SqlParameter("@id","0"),//为0时删除
            new SqlParameter("@MID",MID)
        };
            DataBase p = new DataBase();
            p.RunProc("up_MODEL", prams);
        }
        catch (Exception er)
        {
            a = er.Message.ToString();
        }
        return a;
    }
    /// <summary>
    /// 添加注册未成功的原因
    /// </summary>
    /// <param name="type">用户类型</param>
    /// <param name="useid">用户ＩＤ</param>
    /// <param name="useName">用户组织名称</param>
    /// <param name="delWhy">删除原因</param>
    /// <returns></returns>
    public string add_DEL(string type, string useid, string useName, string delWhy)//@type,@useid,@useName,@delWhy)
    {
        string a = "ok";
        try
        {
            SqlParameter[] prams ={
            new SqlParameter("@type",type),//为0时删除
            new SqlParameter("@useid",useid),
                new SqlParameter("@useName",useName),
                new SqlParameter("@delWhy",delWhy)
        };
            DataBase p = new DataBase();
            p.RunProc("add_DEL", prams);
        }
        catch (Exception er)
        {
            a = er.Message.ToString();
        }
        return a;
    }

    /// <summary>
    /// 邦定DataList
    /// </summary>
    /// <param name="dl"></param>
    /// <param name="sql"></param>
    public void bind(DataList dl, string sql)
    {
        DataBase p = new DataBase();
        dl.DataSource= p.View(sql);
        dl.DataBind();
    }
    /// <summary>
    /// 读取管理员的信息
    /// </summary>
    /// <param name="sql"></param>
    /// <param name="tName">名字</param>
    /// <param name="tCard">账号</param>
    /// <param name="tAPassword">密码</param>
    /// <param name="tATelephone">电话</param>
    /// <param name="tAmovephone">农民信箱</param>
    /// <param name="tadminiType">管理员类型</param>
    /// <param name="tCity">市</param>
    /// <param name="tTown">镇</param>
    /// <param name="taddress">村</param>
    static  public void Getadmini(string sql, TextBox tName, TextBox tCard, TextBox tAPassword, TextBox tATelephone, TextBox tAmovephone, TextBox tadminiType, TextBox tCity, TextBox tTown, TextBox taddress)
    {
        DataAccess.DataBase p = new DataBase();
        SqlDataReader read = p.QueryDataReader("SELECT * FROM administrators WHERE AIDCard='"+ sql + "'");
        if (read.Read())
        {
            tName.Text = read["AName"].ToString();
            tCard.Text = read["AIDCard"].ToString();
            tAPassword.Text = read["APassword"].ToString();
            tATelephone.Text = read["ATelephone"].ToString();
            tAmovephone.Text = read["Amovephone"].ToString();
            tadminiType.Text = read["adminiType"].ToString();
            tCity.Text = read["City"].ToString();
            tTown.Text = read["Town"].ToString();
            taddress.Text = read["address"].ToString();
    
        }
        read.Close();

    }
    /// <summary>
    /// 修改管理
    /// </summary>
    /// <param name="para"></param>
    static public string up_admini(SqlParameter[] para)
    {
        DataBase p = new DataBase();
        return p.RunProc("up_admini", para);
    }
}