xiangmu.cs

明日Asp.net销售管理系统明日Asp.net销售管理系统

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;

/// <summary>
/// Summary description for XiangMu
/// </summary>
namespace BLL {
public class XiangMu
{
    SQLHelper sqlHelper = new SQLHelper();
    SqlDataReader dr;
    private int _xMId;
    private string _mingCheng;
    private string _shiJian;
    private string _diDian;
    private string _zhuanYe;
    private string _hangYe;
    private string _jianJie;
    private int _fuZeRenId;

    public int XMId {
        get {
            return _xMId;
        }
        set {
            _xMId = value;
        }
    }

    public string MingCheng {
        get {
            return _mingCheng;
        }
        set {
            _mingCheng = value;
        }
    }

    public string ShiJian {
        get {
            return _shiJian ;
        }
        set {
            _shiJian  = value;
        }
    }


    public string DiDian
    {
        get
        {
            return _diDian;
        }
        set
        {
            _diDian= value;
        }
    }

    public string ZhuanYe
    {
        get
        {
            return _zhuanYe ;
        }
        set
        {
            _zhuanYe  = value;
        }
    }

    public string HangYe
    {
        get
        {
            return _hangYe ;
        }
        set
        {
            _hangYe  = value;
        }
    }

    public string JianJie
    {
        get
        {
            return _jianJie;
        }
        set
        {
            _jianJie = value;
        }
    }

    public int FuZeRenId
    {
        get
        {
            return _fuZeRenId;
        }
        set
        {
            _fuZeRenId = value;
        }
    }

    public void LoadData() {
        string sql = "select MingCheng,ShiJian,DiDian,ZhuanYe,HangYe,JianJie from XiangMuInfo where XMId=" + this._xMId ;
        sqlHelper.RunSQL(sql,out dr);
        if(dr.HasRows ){
            dr.Read();
            this._mingCheng = dr["MingCheng"].ToString();
            this._shiJian = Convert.ToDateTime(dr["ShiJian"]).ToShortDateString();
            this._diDian = dr["DiDian"].ToString();
            this._zhuanYe= dr["ZhuanYe"].ToString();
            this._hangYe = dr["HangYe"].ToString();
            this._jianJie = dr["JianJie"].ToString();

        }
       

        
    }

    public int InsertData() {
        SqlParameter[] ParaList ={

            sqlHelper .CreateInParam ("@MingCheng",SqlDbType.VarChar ,80,this._mingCheng ),
            sqlHelper .CreateInParam ("@ShiJian",SqlDbType.SmallDateTime ,4,this._shiJian ),
            sqlHelper .CreateInParam ("@DiDian",SqlDbType.VarChar ,50,this._diDian ),
            sqlHelper .CreateInParam ("@ZhuanYe",SqlDbType.VarChar ,50,this._zhuanYe ),
            sqlHelper .CreateInParam ("@HangYe",SqlDbType.VarChar ,50,this._hangYe ),
            sqlHelper .CreateInParam ("@JianJie",SqlDbType.VarChar ,8000,this._jianJie ),
            sqlHelper .CreateInParam ("@FuZeRenId",SqlDbType.Int,4,this._fuZeRenId )

        };

       return(sqlHelper.RunProc("XiangMuInfoAdd",ParaList ));
        //string JS="<script type='text/javascript'>window.alert('添加成功!')</script>";
        
    }
    public XiangMu()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public bool DeleteRelf() {
        bool Flag = false;
        string sql = "delete from XiangMuInfo where XMId=" + this._xMId ;
        sqlHelper.RunSQL(sql);
        Flag = true;
        return Flag;
    }

    public bool UpdateRelf() {
        bool Flag = false;
        SqlParameter[] ParaList ={
            sqlHelper.CreateInParam ("@MingCheng",SqlDbType.VarChar ,80,this._mingCheng ),
            sqlHelper .CreateInParam ("@ShiJian",SqlDbType.SmallDateTime ,4,this._shiJian ),
            sqlHelper .CreateInParam ("@DiDian",SqlDbType.VarChar ,50,this._diDian ),
            sqlHelper .CreateInParam ("@ZhuanYe",SqlDbType.VarChar ,50,this._zhuanYe ),
            sqlHelper .CreateInParam ("@HangYe",SqlDbType.VarChar ,50,this._hangYe ),
            sqlHelper .CreateInParam ("@JianJie",SqlDbType.VarChar ,8000,this._jianJie ),
            sqlHelper .CreateInParam ("@XMId",SqlDbType.VarChar ,4,this._xMId )
        };

        sqlHelper.RunProc("UpdateXMInfo",ParaList );
        Flag = true;
        return Flag;
    }


    public static bool DeleteYGXM(string FuZeRenId) {
        SQLHelper sqlHelper = new SQLHelper();
        bool Flag = true;
        string sql = "delete XiangMuInfo where FuZeRenId=" + FuZeRenId;
        sqlHelper.RunSQL(sql);
        Flag = true;
        return Flag;
        
    }
}

}