예제 #1
0
  /// <summary>
  /// 修改公司信息
  /// </summary>
  /// <param name="Model">Company实体</param>
  /// <returns>更新是否成功</returns>
 public static bool ModifyCompany(CompanyModel Model)
 {
     if (Model == null) return false;
     if (Model.ModifiedUserID == null) Model.ModifiedUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
     try
     {
         return CompanyDBHelper.ModifyCompany(Model);
     }
     catch (System.Exception ex)
     {
         throw ex;
     }
 }
예제 #2
0
        /// <summary>
        /// 修改公司信息
        /// </summary>
        /// <param name="Model">Company实体</param>
        /// <returns></returns>
        public static bool ModifyCompany(CompanyModel Model)
        {
            StringBuilder sql = new StringBuilder();

            sql.AppendLine("update pubdba.company set");
            sql.AppendLine("[CompanyNameCn] = @CompanyNameCn,");
            sql.AppendLine("[CompanyNameEn] = @CompanyNameEn,");
            sql.AppendLine("[ProvCD] = @ProvCD,[CityCD] = @CityCD,");
            sql.AppendLine("[Addr] = @Addr,[Contact] = @Contact,");
            sql.AppendLine("[Tel] = @Tel,[Fax] = @Fax,");
            sql.AppendLine("[Post] = @Post,[HomePage] = @HomePage,");
            sql.AppendLine("[Email] = @Email,[QQ] = @QQ,");
            sql.AppendLine("[MSN] = @MSN,[IM] = @IM,");
            sql.AppendLine("[TradeCD] = @TradeCD,[Staff] = @Staff,");
            sql.AppendLine("[Size] = @Size,[Production] = @Production,");
            sql.AppendLine("[Sale] = @Sale,[Credit] = @Credit,[Remark] = @Remark,");
            sql.AppendLine("[ModifiedDate] = getdate(), [ModifiedUserID] =ModifiedUserID  where CompanyCD=@CompanyCD");
            SqlParameter[] parms = new SqlParameter[23];
            parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
            parms[1] = SqlHelper.GetParameter("@CompanyNameCn", Model.CompanyNameCn);
            parms[2] = SqlHelper.GetParameter("@CompanyNameEn", Model.CompanyNameEn);
            parms[3] = SqlHelper.GetParameter("@ProvCD", Model.ProvCD);
            parms[4] = SqlHelper.GetParameter("@CityCD", Model.CityCD);
            parms[5] = SqlHelper.GetParameter("@Addr", Model.Addr);
            parms[6] = SqlHelper.GetParameter("@Contact", Model.Contact);
            parms[7] = SqlHelper.GetParameter("@Tel", Model.Tel);
            parms[8] = SqlHelper.GetParameter("@Fax", Model.Fax);
            parms[9] = SqlHelper.GetParameter("@Post", Model.Post);
            parms[10] = SqlHelper.GetParameter("@HomePage", Model.HomePage);
            parms[11] = SqlHelper.GetParameter("@Email", Model.Email);
            parms[12] = SqlHelper.GetParameter("@QQ", Model.QQ);
            parms[13] = SqlHelper.GetParameter("@MSN", Model.MSN);
            parms[14] = SqlHelper.GetParameter("@IM", Model.IM);
            parms[15] = SqlHelper.GetParameter("@TradeCD", Model.TradeCD);
            parms[16] = SqlHelper.GetParameter("@Staff", Model.Staff);
            parms[17] = SqlHelper.GetParameter("@Size", Model.Size);
            parms[18] = SqlHelper.GetParameter("@Production", Model.Production);
            parms[19] = SqlHelper.GetParameter("@Sale", Model.Sale);
            parms[20] = SqlHelper.GetParameter("@Credit", Model.Credit);
            parms[21] = SqlHelper.GetParameter("@Remark", Model.Remark);
            parms[22] = SqlHelper.GetParameter("@ModifiedUserID", Model.ModifiedUserID);
            SqlHelper.ExecuteTransSql(sql.ToString(), parms);

            return SqlHelper.Result.OprateCount > 0 ? true : false;
        }
예제 #3
0
        /// <summary>
        /// 增加公司信息
        /// </summary>
        /// <returns></returns>
        public static bool AddCompany(CompanyModel Model)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendLine("Insert into pubdba.company(CompanyCD,CompanyNameCn,CompanyNameEn,");
            sql.AppendLine("ProvCD,CityCD,Addr,Contact,Tel,Fax,Post,HomePage,Email,QQ,");
            sql.AppendLine("MSN,IM,TradeCD,Staff,Size,Production,Sale,Credit,Remark,ModifiedDate,ModifiedUserID)");
            sql.AppendLine("Values(@CompanyCD,@CompanyNameCn,@CompanyNameEn,@ProvCD,@CityCD,@Addr,");
            sql.AppendLine("@Contact,@Tel,@Fax,@Post,@HomePage,@Email,@QQ,@MSN,");
            sql.AppendLine("@IM,@TradeCD,@Staff,@Size,@Production,@Sale,@Credit,@Remark,getdate(),@ModifiedUserID)");
            SqlParameter[] parms = new SqlParameter[23];
            parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
            parms[1] = SqlHelper.GetParameter("@CompanyNameCn", Model.CompanyNameCn);
            parms[2] = SqlHelper.GetParameter("@CompanyNameEn", Model.CompanyNameEn);
            parms[3] = SqlHelper.GetParameter("@ProvCD", Model.ProvCD);
            parms[4] = SqlHelper.GetParameter("@CityCD", Model.CityCD);
            parms[5] = SqlHelper.GetParameter("@Addr", Model.Addr);
            parms[6] = SqlHelper.GetParameter("@Contact", Model.Contact);
            parms[7] = SqlHelper.GetParameter("@Tel", Model.Tel);
            parms[8] = SqlHelper.GetParameter("@Fax", Model.Fax);
            parms[9] = SqlHelper.GetParameter("@Post", Model.Post);
            parms[10] = SqlHelper.GetParameter("@HomePage", Model.HomePage);
            parms[11] = SqlHelper.GetParameter("@Email", Model.Email);
            parms[12] = SqlHelper.GetParameter("@QQ", Model.QQ);
            parms[13] = SqlHelper.GetParameter("@MSN", Model.MSN);
            parms[14] = SqlHelper.GetParameter("@IM", Model.IM);
            parms[15] = SqlHelper.GetParameter("@TradeCD", Model.TradeCD);
            parms[16] = SqlHelper.GetParameter("@Staff", Model.Staff);
            parms[17] = SqlHelper.GetParameter("@Size", Model.Size);
            parms[18] = SqlHelper.GetParameter("@Production", Model.Production);
            parms[19] = SqlHelper.GetParameter("@Sale", Model.Sale);
            parms[20] = SqlHelper.GetParameter("@Credit", Model.Credit);
            parms[21] = SqlHelper.GetParameter("@Remark", Model.Remark);
            parms[22] = SqlHelper.GetParameter("@ModifiedUserID", Model.ModifiedUserID);
            SqlHelper.ExecuteTransSql(sql.ToString(),parms);

            return SqlHelper.Result.OprateCount > 0 ? true : false;
        }
예제 #4
0
    protected void btnModify_Click(object sender, ImageClickEventArgs e)
    {
      
        CompanyModel Model = new CompanyModel();
        Model.CityCD = HideAction.Value;


        Model.CompanyCD = this.txtCompanyCD.Text.Trim();
        Model.CompanyNameCn = this.txtCompanyCn.Text.Trim();
        Model.CompanyNameEn = this.txtCompanyEn.Text.Trim();
        Model.ProvCD = this.SetPro.Value;
      
        Model.Addr = this.txtAddress.Text.Trim();
        Model.Contact = this.txtContact.Text.Trim();
        Model.Tel = this.txtTel.Text.Trim();
        Model.Fax = this.txtFax.Text.Trim();
        Model.Post = this.txtPost.Text.Trim();
        Model.HomePage = this.txtHomePage.Text.Trim();
        Model.Email = this.txtMail.Text.Trim();
        Model.QQ = this.txtQQ.Text.Trim();
        Model.MSN = this.txtMSN.Text.Trim();
        Model.IM = this.txtIM.Text.Trim();
        if (this.txtTradeCD.Text != "")
        {
            Model.TradeCD = Convert.ToInt32(this.txtTradeCD.Text);
        }
        if (this.txtStaff.Text != "")
        {
            Model.Staff = Convert.ToInt32(this.txtStaff.Text.Trim());
        }
        Model.Size = DrpSize.SelectedValue;
        Model.Production = this.txtProduction.Text.Trim();
        if (this.txtSale.Text != "")
        {
            Model.Sale = Convert.ToDecimal(this.txtSale.Text);
        }
        Model.Credit =this.txtCredit.Text.Trim();
        Model.Remark = this.txtRemark.Text.Trim();
        Model.ModifiedUserID = "admin";
        try
        {
            if (Action == ActionUtil.Add.ToString())
            {
                CompanyBus.AddCompany(Model);
                string url = "Company_Query.aspx?CompanyCD=" + Model.CompanyCD;
                Response.Redirect(url);
                //Response.Write("<script language='javascript'>window.location='Company_Query.aspx'</script>");
            }
            else if (Action == ActionUtil.Edit.ToString())
            {
                bool reult=CompanyBus.ModifyCompany(Model);

                string url = "Company_Query.aspx?CompanyCD=" + Model.CompanyCD;
                Response.Redirect(url);
              //  Response.Write("<script language='javascript'>window.location='Company_Query.aspx?CompanyCD='"++"''</script>");
            }
        }
        catch
        {
            lblMessage.Text = "数据操作失败,请联系管理员!";
        }
    }