www.pudn.com > WEBrsgl6.20.rar > 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; 
 
///  
/// data 的摘要说明 
///  
public class data : System.Web.UI.Page 
{ 
	public data() 
	{ 
		// 
		// TODO: 在此处添加构造函数逻辑 
		// 
 
       
	}  
   ///  
   /// 显示农机主织的基本信息 
   ///  
    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(); 
       } 
 
    ///  
    /// 插入Model表 
    ///  
    /// 农机组织账号 
    /// 机器类型 
    /// 机器型号 
    /// 机器介绍 
    /// 车主 
    /// 车主电话 
    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); 
         
    } 
    ///  
    /// 填充GridView 
    ///  
    /// GridView 
    /// 生成视图的sql语句 
    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; 
    } 
    ///  
    /// 更新农机组织机器表 
    ///  
    /// 机器编号 
    /// 机器类型 
    /// 机器型号 
    /// 机器介绍 
    /// 车主 
    /// 车主电话 
    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; 
    } 
    ///  
    /// 删除农机组织机器表 
    ///  
    /// 机器ID 
    ///  
    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; 
    } 
    ///  
    /// 添加注册未成功的原因 
    ///  
    /// 用户类型 
    /// 用户ＩＤ 
    /// 用户组织名称 
    /// 删除原因 
    ///  
    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; 
    } 
 
    ///  
    /// 邦定DataList 
    ///  
    ///  
    ///  
    public void bind(DataList dl, string sql) 
    { 
        DataBase p = new DataBase(); 
        dl.DataSource= p.View(sql); 
        dl.DataBind(); 
    } 
    ///  
    /// 读取管理员的信息 
    ///  
    ///  
    /// 名字 
    /// 账号 
    /// 密码 
    /// 电话 
    /// 农民信箱 
    /// 管理员类型 
    /// 市 
    /// 镇 
    /// 村 
    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(); 
 
    } 
    ///  
    /// 修改管理 
    ///  
    ///  
    static public string up_admini(SqlParameter[] para) 
    { 
        DataBase p = new DataBase(); 
        return p.RunProc("up_admini", para); 
    } 
}