Esempio n. 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Maticsoft.BLL.ComPany combll = new Maticsoft.BLL.ComPany();
         int maxid = combll.GetMaxId() - 1;
         Maticsoft.Model.ComPany commodel = combll.GetModel(maxid);
         lblComPanyContent.Text = commodel.comconten;
     }
 }
Esempio n. 2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.ComPany model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ComPany set ");
            strSql.Append("CompanyNames=@CompanyNames,");
            strSql.Append("CompanyType=@CompanyType,");
            strSql.Append("Fanren=@Fanren,");
            strSql.Append("ComAddress=@ComAddress,");
            strSql.Append("ComFax=@ComFax,");
            strSql.Append("ComPhoto=@ComPhoto,");
            strSql.Append("ComEmail=@ComEmail,");
            strSql.Append("QQ=@QQ,");
            strSql.Append("Comwangzhi=@Comwangzhi,");
            strSql.Append("comconten=@comconten");
            strSql.Append(" where CompanyID=@CompanyID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CompanyID",    SqlDbType.Int,       4),
                new SqlParameter("@CompanyNames", SqlDbType.VarChar, 200),
                new SqlParameter("@CompanyType",  SqlDbType.VarChar, 200),
                new SqlParameter("@Fanren",       SqlDbType.VarChar, 200),
                new SqlParameter("@ComAddress",   SqlDbType.Text),
                new SqlParameter("@ComFax",       SqlDbType.VarChar, 200),
                new SqlParameter("@ComPhoto",     SqlDbType.VarChar, 200),
                new SqlParameter("@ComEmail",     SqlDbType.VarChar, 200),
                new SqlParameter("@QQ",           SqlDbType.VarChar, 200),
                new SqlParameter("@Comwangzhi",   SqlDbType.Text),
                new SqlParameter("@comconten",    SqlDbType.Text)
            };
            parameters[0].Value  = model.CompanyID;
            parameters[1].Value  = model.CompanyNames;
            parameters[2].Value  = model.CompanyType;
            parameters[3].Value  = model.Fanren;
            parameters[4].Value  = model.ComAddress;
            parameters[5].Value  = model.ComFax;
            parameters[6].Value  = model.ComPhoto;
            parameters[7].Value  = model.ComEmail;
            parameters[8].Value  = model.QQ;
            parameters[9].Value  = model.Comwangzhi;
            parameters[10].Value = model.comconten;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Esempio n. 3
0
        private void bind()
        {
            Maticsoft.BLL.ComPany companybll = new Maticsoft.BLL.ComPany();
            int maxid = companybll.GetMaxId() - 1;

            Maticsoft.Model.ComPany companymodel = companybll.GetModel(maxid);
            lblComEmail.Text     = companymodel.ComEmail;
            lblComFax.Text       = companymodel.ComFax;
            lblCompanyNames.Text = companymodel.CompanyNames;
            lblComPhoto.Text     = companymodel.ComPhoto;
            lblFanren.Text       = companymodel.Fanren;
        }
Esempio n. 4
0
 private void ShowInfo(int CompanyID)
 {
     Maticsoft.BLL.ComPany   bll   = new Maticsoft.BLL.ComPany();
     Maticsoft.Model.ComPany model = bll.GetModel(CompanyID);
     this.lblCompanyID.Text    = model.CompanyID.ToString();
     this.txtCompanyNames.Text = model.CompanyNames;
     this.txtCompanyType.Text  = model.CompanyType;
     this.txtComAddress.Text   = model.ComAddress;
     this.txtComFax.Text       = model.ComFax;
     this.txtComPhoto.Text     = model.ComPhoto;
     this.txtComEmail.Text     = model.ComEmail;
     this.txtQQ.Text           = model.QQ;
     this.txtComwangzhi.Text   = model.Comwangzhi;
 }
Esempio n. 5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Maticsoft.BLL.ComPany   companybll   = new Maticsoft.BLL.ComPany();
         Maticsoft.Model.ComPany companymodel = companybll.GetModel(1);
         lblComAddress.Text   = companymodel.ComAddress;
         lblComEmail.Text     = companymodel.ComEmail;
         lblComFax.Text       = companymodel.ComFax;
         lblCompanyNames.Text = companymodel.CompanyNames;
         lblComPhoto.Text     = companymodel.ComPhoto;
         lblComwangzhi.Text   = companymodel.Comwangzhi;
         lblqq.Text           = companymodel.QQ;
     }
 }
Esempio n. 6
0
        private void bind()
        {
            Maticsoft.BLL.ComPany   combll   = new Maticsoft.BLL.ComPany();
            Maticsoft.Model.ComPany commodel = combll.GetModel(1);

            txtcomfaren.Text    = commodel.Fanren.ToString();
            txtcomfax.Text      = commodel.ComFax;
            txtcompanyname.Text = commodel.CompanyNames;
            txtcompanytype.Text = commodel.CompanyType;
            txtcomphoto.Text    = commodel.ComPhoto;
            txtcomwangzhi.Text  = commodel.Comwangzhi;
            txtcontent.Text     = commodel.comconten;
            txtEmail.Text       = commodel.ComEmail;
            txtqq.Text          = commodel.QQ;
            txtcomaddress.Text  = commodel.ComAddress;
        }
Esempio n. 7
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Maticsoft.Model.ComPany model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ComPany(");
            strSql.Append("CompanyNames,CompanyType,Fanren,ComAddress,ComFax,ComPhoto,ComEmail,QQ,Comwangzhi,comconten)");
            strSql.Append(" values (");
            strSql.Append("@CompanyNames,@CompanyType,@Fanren,@ComAddress,@ComFax,@ComPhoto,@ComEmail,@QQ,@Comwangzhi,@comconten)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CompanyNames", SqlDbType.VarChar, 200),
                new SqlParameter("@CompanyType",  SqlDbType.VarChar, 200),
                new SqlParameter("@Fanren",       SqlDbType.VarChar, 200),
                new SqlParameter("@ComAddress",   SqlDbType.Text),
                new SqlParameter("@ComFax",       SqlDbType.VarChar, 200),
                new SqlParameter("@ComPhoto",     SqlDbType.VarChar, 200),
                new SqlParameter("@ComEmail",     SqlDbType.VarChar, 200),
                new SqlParameter("@QQ",           SqlDbType.VarChar, 200),
                new SqlParameter("@Comwangzhi",   SqlDbType.Text),
                new SqlParameter("@comconten",    SqlDbType.Text)
            };
            parameters[0].Value = model.CompanyNames;
            parameters[1].Value = model.CompanyType;
            parameters[2].Value = model.Fanren;
            parameters[3].Value = model.ComAddress;
            parameters[4].Value = model.ComFax;
            parameters[5].Value = model.ComPhoto;
            parameters[6].Value = model.ComEmail;
            parameters[7].Value = model.QQ;
            parameters[8].Value = model.Comwangzhi;
            parameters[9].Value = model.comconten;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Esempio n. 8
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.ComPany GetModel(int CompanyID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 CompanyID,CompanyNames,CompanyType,Fanren,ComAddress,ComFax,ComPhoto,ComEmail,QQ,Comwangzhi,comconten from ComPany ");
            strSql.Append(" where CompanyID=@CompanyID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@CompanyID", SqlDbType.Int, 4)
            };
            parameters[0].Value = CompanyID;

            Maticsoft.Model.ComPany model = new Maticsoft.Model.ComPany();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["CompanyID"].ToString() != "")
                {
                    model.CompanyID = int.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString());
                }
                model.CompanyNames = ds.Tables[0].Rows[0]["CompanyNames"].ToString();
                model.CompanyType  = ds.Tables[0].Rows[0]["CompanyType"].ToString();
                model.Fanren       = ds.Tables[0].Rows[0]["Fanren"].ToString();
                model.ComAddress   = ds.Tables[0].Rows[0]["ComAddress"].ToString();
                model.ComFax       = ds.Tables[0].Rows[0]["ComFax"].ToString();
                model.ComPhoto     = ds.Tables[0].Rows[0]["ComPhoto"].ToString();
                model.ComEmail     = ds.Tables[0].Rows[0]["ComEmail"].ToString();
                model.QQ           = ds.Tables[0].Rows[0]["QQ"].ToString();
                model.Comwangzhi   = ds.Tables[0].Rows[0]["Comwangzhi"].ToString();
                model.comconten    = ds.Tables[0].Rows[0]["comconten"].ToString();
                return(model);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (Session["usename"] != null)
                {
                    if (Session["usename"].ToString() != "")
                    {
                        Maticsoft.BLL.ComPany   companybll   = new Maticsoft.BLL.ComPany();
                        Maticsoft.Model.ComPany companymodel = companybll.GetModel(1);

                        if (companymodel.CompanyNames == "")
                        {
                            btnadd.Visible    = true;
                            btnupadel.Visible = false;
                        }
                        else
                        {
                            btnadd.Visible    = false;
                            btnupadel.Visible = true;
                            bind();
                        }
                    }
                    else
                    {
                        Response.Redirect("login.aspx");
                        Response.End();
                    }
                }
                else
                {
                    Response.Redirect("login.aspx");
                    Response.End();
                }
            }
        }
Esempio n. 10
0
 protected void btnadd_Click(object sender, EventArgs e)
 {
     Maticsoft.BLL.ComPany   companybll = new Maticsoft.BLL.ComPany();
     Maticsoft.Model.ComPany commodel   = new Maticsoft.Model.ComPany();
     if (txtcompanyname.Text.Trim() == "")
     {
         lblconname.Text = "请填写公司名称";
         return;
     }
     lblconname.Text       = "";
     commodel.CompanyNames = txtcompanyname.Text.Trim();
     if (txtcompanytype.Text.Trim() == "")
     {
         lbltype.Text = "请填写公司类型";
         return;
     }
     lbltype.Text         = "";
     commodel.CompanyType = txtcompanytype.Text.Trim();
     if (txtcomaddress.Text.Trim() == "")
     {
         lbladdress.Text = "请填写公司地址";
         return;
     }
     lbladdress.Text     = "";
     commodel.ComAddress = txtcomaddress.Text.Trim();
     if (txtcomfax.Text.Trim() == "")
     {
         lblfax.Text = "请填写公司传真";
         return;
     }
     lblfax.Text     = "";
     commodel.ComFax = txtcomfax.Text.Trim();
     if (txtcomfaren.Text.Trim() == "")
     {
         lblfanren.Text = "请填写公司法人代表";
         return;
     }
     lblfanren.Text  = "";
     commodel.Fanren = txtcomfaren.Text.Trim();
     if (txtcomphoto.Text.Trim() == "")
     {
         lblphoto.Text = "请填写公司电话";
         return;
     }
     lblphoto.Text     = "";
     commodel.ComPhoto = txtcomphoto.Text.Trim();
     if (txtEmail.Text.Trim() == "")
     {
         lblemail.Text = "请填写公司邮箱";
         return;
     }
     lblemail.Text     = "";
     commodel.ComEmail = txtEmail.Text.Trim();
     if (txtqq.Text.Trim() == "")
     {
         lblqq.Text = "请填写公司qq或MSN";
         return;
     }
     lblqq.Text  = "";
     commodel.QQ = txtqq.Text.Trim();
     if (txtcomwangzhi.Text.Trim() == "")
     {
         lblwangzhi.Text = "请填写公司网址";
         return;
     }
     lblwangzhi.Text     = "";
     commodel.Comwangzhi = txtcomwangzhi.Text.Trim();
     if (txtcontent.Text.Trim() == "")
     {
         lblcomcontent.Text = "请填写公司简介";
     }
     lblcomcontent.Text = "";
     commodel.comconten = txtcontent.Text.Trim();
     companybll.Add(commodel);
     Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功....')</script>");
     txtcomaddress.Text  = string.Empty;
     txtcomfaren.Text    = string.Empty;
     txtcomfax.Text      = string.Empty;
     txtcompanyname.Text = string.Empty;
     txtcompanytype.Text = string.Empty;
     txtcomphoto.Text    = string.Empty;
     txtcomwangzhi.Text  = string.Empty;
     txtcontent.Text     = string.Empty;
     txtEmail.Text       = string.Empty;
     txtqq.Text          = string.Empty;
 }
Esempio n. 11
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtCompanyNames.Text.Trim().Length == 0)
            {
                strErr += "CompanyNames不能为空!\\n";
            }
            if (this.txtCompanyType.Text.Trim().Length == 0)
            {
                strErr += "CompanyType不能为空!\\n";
            }
            if (this.txtComAddress.Text.Trim().Length == 0)
            {
                strErr += "ComAddress不能为空!\\n";
            }
            if (this.txtComFax.Text.Trim().Length == 0)
            {
                strErr += "ComFax不能为空!\\n";
            }
            if (this.txtComPhoto.Text.Trim().Length == 0)
            {
                strErr += "ComPhoto不能为空!\\n";
            }
            if (this.txtComEmail.Text.Trim().Length == 0)
            {
                strErr += "ComEmail不能为空!\\n";
            }
            if (this.txtQQ.Text.Trim().Length == 0)
            {
                strErr += "QQ不能为空!\\n";
            }
            if (this.txtComwangzhi.Text.Trim().Length == 0)
            {
                strErr += "Comwangzhi不能为空!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            int    CompanyID    = int.Parse(this.lblCompanyID.Text);
            string CompanyNames = this.txtCompanyNames.Text;
            string CompanyType  = this.txtCompanyType.Text;
            string ComAddress   = this.txtComAddress.Text;
            string ComFax       = this.txtComFax.Text;
            string ComPhoto     = this.txtComPhoto.Text;
            string ComEmail     = this.txtComEmail.Text;
            string QQ           = this.txtQQ.Text;
            string Comwangzhi   = this.txtComwangzhi.Text;


            Maticsoft.Model.ComPany model = new Maticsoft.Model.ComPany();
            model.CompanyID    = CompanyID;
            model.CompanyNames = CompanyNames;
            model.CompanyType  = CompanyType;
            model.ComAddress   = ComAddress;
            model.ComFax       = ComFax;
            model.ComPhoto     = ComPhoto;
            model.ComEmail     = ComEmail;
            model.QQ           = QQ;
            model.Comwangzhi   = Comwangzhi;

            Maticsoft.BLL.ComPany bll = new Maticsoft.BLL.ComPany();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }