private List <SqlParameter> Set_Values_In_Customer_Address(CustomerAddressInfo customerAddress)
        {
            List <SqlParameter> sqlparam = new List <SqlParameter>();

            if (customerAddress.Customer_Address_Id != 0)
            {
                sqlparam.Add(new SqlParameter("@Customer_Address_Id", customerAddress.Customer_Address_Id));
            }
            sqlparam.Add(new SqlParameter("@Customer_Id", customerAddress.Customer_Id));
            sqlparam.Add(new SqlParameter("@Address_Type", customerAddress.Address_Type));
            sqlparam.Add(new SqlParameter("@Addresss", customerAddress.Addresss));
            sqlparam.Add(new SqlParameter("@Landline1", customerAddress.Landline1));
            sqlparam.Add(new SqlParameter("@landline2", customerAddress.landline2));
            sqlparam.Add(new SqlParameter("@FaxNo", customerAddress.FaxNo));
            sqlparam.Add(new SqlParameter("@Is_Active", customerAddress.Is_Active));
            if (customerAddress.Customer_Address_Id == 0)
            {
                sqlparam.Add(new SqlParameter("@CreatedBy", customerAddress.CreatedBy));
                sqlparam.Add(new SqlParameter("@CreatedOn", customerAddress.CreatedOn));
            }
            sqlparam.Add(new SqlParameter("@UpdatedBy", customerAddress.UpdatedBy));
            sqlparam.Add(new SqlParameter("@UpdatedOn", customerAddress.UpdatedOn));

            return(sqlparam);
        }
Exemple #2
0
        //protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        //{
        //    if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.SelectedItem)
        //    {
        //        if (e.CommandName == "Select")
        //        {
        //            foreach (DataListItem item in DataList1.Items)
        //            {
        //                if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem || item.ItemType == ListItemType.SelectedItem)
        //                {
        //                    ImageButton imgbtn = item.FindControl("btnSelect") as ImageButton;
        //                    if(item.ItemIndex == e.Item.ItemIndex)
        //                    {
        //                        imgbtn.ImageUrl = "../Images/site/SelectedIcon.jpg";
        //                    }
        //                    else
        //                    {
        //                        imgbtn.ImageUrl = "../Images/site/UnSelectedIcon.jpg";
        //                    }
        //                }
        //            }

        //            int sysno = Int32.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
        //            lblSysNo.Text = sysno.ToString();
        //            CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
        //            txtBrief.Text = o.Brief;
        //            txtName.Text = o.Name;
        //            txtContact.Text = o.Contact;
        //            txtCellPhone.Text = o.CellPhone;
        //            txtPhone.Text = o.Phone;
        //            scArea.AreaSysNo = o.AreaSysNo;
        //            txtAddress.Text = o.Address;
        //            txtZip.Text = o.Zip;
        //            txtFax.Text = o.Fax;
        //        }
        //    }
        //}

        //protected void lnkbtnNewAddress_Click(object sender, EventArgs e)
        //{
        //    foreach (DataListItem item in DataList1.Items)
        //    {
        //        if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem || item.ItemType == ListItemType.SelectedItem)
        //        {
        //            ImageButton imgbtn = item.FindControl("btnSelect") as ImageButton;
        //            imgbtn.ImageUrl = "../Images/site/UnSelectedIcon.jpg";
        //        }
        //    }

        //    lblSysNo.Text = "0";

        //    txtBrief.Text = "";
        //    txtName.Text = "";
        //    txtCellPhone.Text = "";
        //    txtPhone.Text = "";
        //    txtAddress.Text = "";
        //    scArea.AreaSysNo = AppConst.IntNull;
        //    txtZip.Text = "";
        //    txtFax.Text = "";
        //}

        /// <summary>
        /// 选择地址
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ddlAddresses_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlAddresses.SelectedValue == "create")//创建新地址
            {
                oldAddress = CustomerManager.GetInstance().LoadCustomerAddress(Int32.Parse(lblSysNo.Text));

                lblSysNo.Text = "0";

                txtBrief.Text     = "";
                txtName.Text      = "";
                txtCellPhone.Text = "";
                txtPhone.Text     = "";
                txtAddress.Text   = "";
                scArea.AreaSysNo  = AppConst.IntNull;
                txtZip.Text       = "";
                txtFax.Text       = "";
            }
            else //选择其他地址
            {
                int sysno = Int32.Parse(ddlAddresses.SelectedValue);
                lblSysNo.Text = sysno.ToString();
                CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
                txtBrief.Text     = o.Brief;
                txtName.Text      = o.Name;
                txtContact.Text   = o.Contact;
                txtCellPhone.Text = o.CellPhone;
                txtPhone.Text     = o.Phone;
                scArea.AreaSysNo  = o.AreaSysNo;
                txtAddress.Text   = o.Address;
                txtZip.Text       = o.Zip;
                txtFax.Text       = o.Fax;
            }
        }
        protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                Label       lbl1   = e.Item.FindControl("lblIsDefault") as Label;
                Label       lbl2   = e.Item.FindControl("lblBrief") as Label;
                ImageButton imgbtn = e.Item.FindControl("btnSelect") as ImageButton;

                int IsDefault = Int32.Parse(lbl1.Text);
                if (IsDefault == (int)AppEnum.BiStatus.Valid)
                {
                    lbl2.Text       = lbl2.Text + "[默认]";
                    imgbtn.ImageUrl = "../Images/site/SelectedIcon.jpg";

                    int sysno = Int32.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
                    // lblSysNo.Text = sysno.ToString();

                    CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
                    txtRname.Text = o.Name;

                    txtRCellPhone.Text = o.CellPhone;
                    txtRPhone.Text     = o.Phone;
                    if (oSession.sCustomer.DwellAreaSysNo != 1)//这个是new user的默认值。
                    {
                        RArea.AreaSysNo = o.AreaSysNo;
                    }
                    txtRaddress.Text = o.Address;
                    txtRzip.Text     = o.Zip;
                }
                else
                {
                    imgbtn.ImageUrl = "../Images/site/UnSelectedIcon.jpg";
                }
            }
        }
        private List <CustomerAddressInfo> Get_Customer_Addresses(DataTable dt2)
        {
            List <CustomerAddressInfo> customer_Address_List = new List <CustomerAddressInfo>();

            List <DataRow> drList = new List <DataRow>();

            drList = dt2.AsEnumerable().ToList();

            foreach (DataRow dr in drList)
            {
                CustomerAddressInfo customerAddress = new CustomerAddressInfo();

                customerAddress.Customer_Address_Id = Convert.ToInt32(dr["Customer_Address_Id"]);
                customerAddress.Customer_Id         = Convert.ToInt32(dr["Customer_Id"]);
                customerAddress.Address_Type        = Convert.ToInt32(dr["Address_Type"]);
                customerAddress.Addresss            = Convert.ToString(dr["Addresss"]);
                customerAddress.Landline1           = Convert.ToString(dr["Landline1"]);
                customerAddress.landline2           = Convert.ToString(dr["landline2"]);
                customerAddress.FaxNo     = Convert.ToString(dr["FaxNo"]);
                customerAddress.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
                customerAddress.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
                customerAddress.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
                customerAddress.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
                customerAddress.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);

                customer_Address_List.Add(customerAddress);
            }

            return(customer_Address_List);
        }
Exemple #5
0
        public CustomerAddressInfo LoadCustomerAddress(int sysno)
        {
            string  sql = "select * from customer_address where sysno=" + sysno;
            DataSet ds  = SqlHelper.ExecuteDataSet(sql);

            if (Util.HasMoreRow(ds))
            {
                CustomerAddressInfo o = new CustomerAddressInfo();
                map(o, ds.Tables[0].Rows[0]);
                return(o);
            }
            else
            {
                return(null);
            }
        }
Exemple #6
0
 private void map(CustomerAddressInfo oParam, DataRow tempdr)
 {
     oParam.SysNo         = Util.TrimIntNull(tempdr["SysNo"]);
     oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]);
     oParam.Brief         = Util.TrimNull(tempdr["Brief"]);
     oParam.Name          = Util.TrimNull(tempdr["Name"]);
     oParam.Contact       = Util.TrimNull(tempdr["Contact"]);
     oParam.Phone         = Util.TrimNull(tempdr["Phone"]);
     oParam.CellPhone     = Util.TrimNull(tempdr["CellPhone"]);
     oParam.Fax           = Util.TrimNull(tempdr["Fax"]);
     oParam.Address       = Util.TrimNull(tempdr["Address"]);
     oParam.Zip           = Util.TrimNull(tempdr["Zip"]);
     oParam.AreaSysNo     = Util.TrimIntNull(tempdr["AreaSysNo"]);
     oParam.IsDefault     = Util.TrimIntNull(tempdr["IsDefault"]);
     oParam.UpdateTime    = Util.TrimDateNull(tempdr["UpdateTime"]);
 }
Exemple #7
0
        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                int sysno = Int32.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
                if (e.CommandName == "Update")
                {
                    CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);

                    lblSysNo.Text     = sysno.ToString();
                    lblIsDefault.Text = o.IsDefault.ToString();
                    txtBrief.Text     = o.Brief;
                    txtName.Text      = o.Name;
                    txtContact.Text   = o.Contact;
                    txtCellPhone.Text = o.CellPhone;
                    txtPhone.Text     = o.Phone;
                    txtAddress.Text   = o.Address;
                    scArea.AreaSysNo  = o.AreaSysNo;
                    txtZip.Text       = o.Zip;
                    txtFax.Text       = o.Fax;

                    btnSubmit.Text      = "修改收货地址";
                    btnSubmit.Enabled   = true;
                    AddressInfo.Visible = true;
                }
                else if (e.CommandName == "Delete")
                {
                    CustomerManager.GetInstance().DeleteCustomerAddress(sysno);
                    AddressInfo.Visible = false;
                }
                else if (e.CommandName == "SetDefault")
                {
                    CustomerManager.GetInstance().CustomerAddressSetDefault(sysno);
                    AddressInfo.Visible = false;
                }

                BindAddressList();
            }
        }
        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.SelectedItem)
            {
                if (e.CommandName == "Select")
                {
                    foreach (DataListItem item in DataList1.Items)
                    {
                        if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem || item.ItemType == ListItemType.SelectedItem)
                        {
                            ImageButton imgbtn = item.FindControl("btnSelect") as ImageButton;
                            if (item.ItemIndex == e.Item.ItemIndex)
                            {
                                imgbtn.ImageUrl = "../Images/site/SelectedIcon.jpg";
                            }
                            else
                            {
                                imgbtn.ImageUrl = "../Images/site/UnSelectedIcon.jpg";
                            }
                        }
                    }

                    int sysno = Int32.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
                    //lblSysNo.Text = sysno.ToString();
                    CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
                    txtRname.Text = o.Name;

                    txtRCellPhone.Text = o.CellPhone;
                    txtRPhone.Text     = o.Phone;
                    if (oSession.sCustomer.DwellAreaSysNo != 1)//这个是new user的默认值。
                    {
                        RArea.AreaSysNo = o.AreaSysNo;
                    }
                    txtRaddress.Text = o.Address;
                    txtRzip.Text     = o.Zip;
                }
            }
        }
Exemple #9
0
        /// <summary>
        /// 收货地址绑定
        /// </summary>
        private void BindAddressList()
        {
            ddlAddresses.Items.Add(new ListItem("创建新地址", "create"));

            int     customerSysNo = oSession.sCustomer.SysNo;
            DataSet ds            = CustomerManager.GetInstance().GetCustomerAddressDs(customerSysNo);

            if (!Util.HasMoreRow(ds))
            {
                lblSysNo.Text = "0";
            }

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                ddlAddresses.Items.Add(new ListItem(dr["AreaName"].ToString() + dr["Address"].ToString(), dr["sysno"].ToString()));
                if (Int32.Parse(dr["IsDefault"].ToString()) == 0)
                {
                    ddlAddresses.SelectedValue = dr["sysno"].ToString();

                    int sysno = Int32.Parse(ddlAddresses.SelectedValue);
                    lblSysNo.Text = sysno.ToString();
                    CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
                    txtBrief.Text     = o.Brief;
                    txtName.Text      = o.Name;
                    txtContact.Text   = o.Contact;
                    txtCellPhone.Text = o.CellPhone;
                    txtPhone.Text     = o.Phone;
                    scArea.AreaSysNo  = o.AreaSysNo;
                    txtAddress.Text   = o.Address;
                    txtZip.Text       = o.Zip;
                    txtFax.Text       = o.Fax;
                }
            }

            //DataList1.DataSource = ds;
            //DataList1.DataBind();
        }
Exemple #10
0
        //public int Update(Hashtable paramHash)
        //{
        //    StringBuilder sb = new StringBuilder(200);
        //    sb.Append("UPDATE Customer SET ");

        //    if ( paramHash != null && paramHash.Count != 0 )
        //    {
        //        int index = 0;
        //        foreach(string key in paramHash.Keys)
        //        {
        //            object item = paramHash[key];
        //            if ( key.ToLower()=="sysno" )
        //                continue;

        //            if ( index != 0 )
        //                sb.Append(",");
        //            index++;


        //            if (item is int || item is decimal)
        //            {
        //                sb.Append(key).Append("=").Append(item.ToString());
        //            }
        //            else if (item is string)
        //            {
        //                sb.Append(key).Append(" = ").Append(Util.ToSqlString(item.ToString()));
        //            }
        //            else if (item is DateTime)
        //            {
        //                sb.Append(key).Append(" = cast(").Append( Util.ToSqlString(((DateTime)item).ToString(AppConst.DateFormatLong))).Append(" as DateTime)");
        //            }
        //        }
        //    }

        //    sb.Append(" WHERE SysNo=").Append(paramHash["SysNo"]);

        //    return SqlHelper.ExecuteNonQuery(sb.ToString());
        //}

        public int Insert(CustomerAddressInfo oParam)
        {
            string     sql = @"INSERT INTO Customer_Address
                            (
                            CustomerSysNo, Brief, Name, Contact, 
                            Phone, CellPhone, Fax, Address, 
                            Zip, AreaSysNo, IsDefault, UpdateTime
                            )
                            VALUES (
                            @CustomerSysNo, @Brief, @Name, @Contact, 
                            @Phone, @CellPhone, @Fax, @Address, 
                            @Zip, @AreaSysNo, @IsDefault, @UpdateTime
                            );set @SysNo = SCOPE_IDENTITY();";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo         = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
            SqlParameter paramBrief         = new SqlParameter("@Brief", SqlDbType.NVarChar, 50);
            SqlParameter paramName          = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
            SqlParameter paramContact       = new SqlParameter("@Contact", SqlDbType.NVarChar, 50);
            SqlParameter paramPhone         = new SqlParameter("@Phone", SqlDbType.NVarChar, 50);
            SqlParameter paramCellPhone     = new SqlParameter("@CellPhone", SqlDbType.NVarChar, 50);
            SqlParameter paramFax           = new SqlParameter("@Fax", SqlDbType.NVarChar, 50);
            SqlParameter paramAddress       = new SqlParameter("@Address", SqlDbType.NVarChar, 200);
            SqlParameter paramZip           = new SqlParameter("@Zip", SqlDbType.NVarChar, 50);
            SqlParameter paramAreaSysNo     = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
            SqlParameter paramIsDefault     = new SqlParameter("@IsDefault", SqlDbType.Int, 4);
            SqlParameter paramUpdateTime    = new SqlParameter("@UpdateTime", SqlDbType.DateTime);

            paramSysNo.Direction = ParameterDirection.Output;
            if (oParam.CustomerSysNo != AppConst.IntNull)
            {
                paramCustomerSysNo.Value = oParam.CustomerSysNo;
            }
            else
            {
                paramCustomerSysNo.Value = System.DBNull.Value;
            }
            if (oParam.Brief != AppConst.StringNull)
            {
                paramBrief.Value = oParam.Brief;
            }
            else
            {
                paramBrief.Value = System.DBNull.Value;
            }
            if (oParam.Name != AppConst.StringNull)
            {
                paramName.Value = oParam.Name;
            }
            else
            {
                paramName.Value = System.DBNull.Value;
            }
            if (oParam.Contact != AppConst.StringNull)
            {
                paramContact.Value = oParam.Contact;
            }
            else
            {
                paramContact.Value = System.DBNull.Value;
            }
            if (oParam.Phone != AppConst.StringNull)
            {
                paramPhone.Value = oParam.Phone;
            }
            else
            {
                paramPhone.Value = System.DBNull.Value;
            }
            if (oParam.CellPhone != AppConst.StringNull)
            {
                paramCellPhone.Value = oParam.CellPhone;
            }
            else
            {
                paramCellPhone.Value = System.DBNull.Value;
            }
            if (oParam.Fax != AppConst.StringNull)
            {
                paramFax.Value = oParam.Fax;
            }
            else
            {
                paramFax.Value = System.DBNull.Value;
            }
            if (oParam.Address != AppConst.StringNull)
            {
                paramAddress.Value = oParam.Address;
            }
            else
            {
                paramAddress.Value = System.DBNull.Value;
            }
            if (oParam.Zip != AppConst.StringNull)
            {
                paramZip.Value = oParam.Zip;
            }
            else
            {
                paramZip.Value = System.DBNull.Value;
            }
            if (oParam.AreaSysNo != AppConst.IntNull)
            {
                paramAreaSysNo.Value = oParam.AreaSysNo;
            }
            else
            {
                paramAreaSysNo.Value = System.DBNull.Value;
            }
            if (oParam.IsDefault != AppConst.IntNull)
            {
                paramIsDefault.Value = oParam.IsDefault;
            }
            else
            {
                paramIsDefault.Value = System.DBNull.Value;
            }
            if (oParam.UpdateTime != AppConst.DateTimeNull)
            {
                paramUpdateTime.Value = oParam.UpdateTime;
            }
            else
            {
                paramUpdateTime.Value = System.DBNull.Value;
            }

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramCustomerSysNo);
            cmd.Parameters.Add(paramBrief);
            cmd.Parameters.Add(paramName);
            cmd.Parameters.Add(paramContact);
            cmd.Parameters.Add(paramPhone);
            cmd.Parameters.Add(paramCellPhone);
            cmd.Parameters.Add(paramFax);
            cmd.Parameters.Add(paramAddress);
            cmd.Parameters.Add(paramZip);
            cmd.Parameters.Add(paramAreaSysNo);
            cmd.Parameters.Add(paramIsDefault);
            cmd.Parameters.Add(paramUpdateTime);

            return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
        }
Exemple #11
0
 public int UpdateCustomerAddress(CustomerAddressInfo oParam)
 {
     return(new CustomerDac().Update(oParam));
 }
Exemple #12
0
 public int InsertCustomerAddress(CustomerAddressInfo oParam)
 {
     return(new CustomerDac().Insert(oParam));
 }
        protected void btnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            if (txtName.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入您的姓名!";
                return;
            }

            if (txtNickname.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入您的昵称!";
                return;
            }

            if (txtDwellAddress.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入联系地址!";
                return;
            }

            if (txtPhone.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入联系电话!";
                return;
            }

            if (scArea.DistrictSysNo == AppConst.IntNull)
            {
                lblErrMsg.Text = "请选择地区(包括省、市、区县)";
                return;
            }

            if (txtCellPhone.Text.Trim() != "")
            {
                if (!Util.IsCellNumber(txtCellPhone.Text.Trim()))
                {
                    lblErrMsg.Text = "手机号码格式不正确,您可以不输入";
                    return;
                }
            }

            if (txtZip.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入邮政编码!";
                return;
            }

            if (txtZip.Text.Trim() != "")
            {
                if (!Util.IsZipCode(txtZip.Text.Trim()))
                {
                    lblErrMsg.Text = "邮政编码格式不正确!";
                    return;
                }
            }

            if (String.IsNullOrEmpty(txtBirthDay.Text.ToString()))
            {
                lblErrMsg.Text = "生日不能为空";
                return;
            }

            if (!Util.IsEmailAddress(txtEmail.Text.Trim()))
            {
                lblErrMsg.Text = "Email地址格式不正确";
                return;
            }

            IcsonSessionInfo oSession = (IcsonSessionInfo)Session["IcsonSessionInfo"];

            if (oSession == null)
            {
                oSession = new IcsonSessionInfo();
                Session["IcsonSessionInfo"] = oSession;
            }

            if (oSession.sCustomer == null || oSession.sCustomer.SysNo == AppConst.IntNull)
            {
                string url = "../CustomError.aspx?msg=" + Server.UrlEncode("缺少注册信息,不能更新或继续注册,请登录");
                Response.Redirect(url);
            }

            bool         isOK      = false;
            CustomerInfo oCustomer = oSession.sCustomer;

            try
            {
                oCustomer.CustomerName   = txtName.Text.Trim();
                oCustomer.NickName       = txtNickname.Text.Trim();
                oCustomer.Gender         = int.Parse(rblGeneder.SelectedItem.Value.Trim());
                oCustomer.Phone          = txtPhone.Text.Trim();
                oCustomer.CellPhone      = txtCellPhone.Text.Trim();
                oCustomer.Fax            = txtFax.Text.Trim();
                oCustomer.DwellAreaSysNo = scArea.AreaSysNo;
                oCustomer.DwellZip       = txtZip.Text.Trim();
                oCustomer.DwellAddress   = txtDwellAddress.Text.Trim();
                oCustomer.Email          = txtEmail.Text.Trim();
                oCustomer.BirthDay       = txtBirthDay.Text.Trim();

                Hashtable ht = new Hashtable(20);

                ht.Add("SysNo", oCustomer.SysNo);
                ht.Add("CustomerName", oCustomer.CustomerName);
                ht.Add("Nickname", oCustomer.NickName);
                ht.Add("Gender", oCustomer.Gender);
                ht.Add("Phone", oCustomer.Phone);
                ht.Add("CellPhone", oCustomer.CellPhone);
                ht.Add("Fax", oCustomer.Fax);
                ht.Add("DwellAreaSysNo", oCustomer.DwellAreaSysNo);
                ht.Add("DwellZip", oCustomer.DwellZip);
                ht.Add("DwellAddress", oCustomer.DwellAddress);
                ht.Add("Email", oCustomer.Email);
                ht.Add("Birthday", oCustomer.BirthDay);
                CustomerManager.GetInstance().Update(ht);

                isOK           = true;
                lblErrMsg.Text = "更新个人信息成功";
            }
            catch (BizException exp)
            {
                lblErrMsg.Text = exp.Message;
            }
            catch (Exception exp)
            {
                ErrorLog.GetInstance().Write(exp.ToString());
                string url = "../CustomError.aspx?msg=" + Server.UrlEncode("更新用户信息失败");
                Response.Redirect(url);
            }

            if (this.opt == "New" && isOK)
            {
                //新注册用户,联系人资料作为默认的收货地址添加到收货地址表中
                CustomerAddressInfo caInfo = new CustomerAddressInfo();
                caInfo.CustomerSysNo = oCustomer.SysNo;
                caInfo.Brief         = "收货地址1";
                caInfo.Contact       = txtName.Text.Trim();
                caInfo.Name          = txtName.Text.Trim();
                caInfo.Phone         = txtPhone.Text.Trim();
                caInfo.CellPhone     = txtCellPhone.Text.Trim();
                caInfo.Fax           = txtFax.Text.Trim();
                caInfo.AreaSysNo     = scArea.AreaSysNo;
                caInfo.Zip           = txtZip.Text.Trim();
                caInfo.Address       = txtDwellAddress.Text.Trim();
                caInfo.IsDefault     = (int)AppEnum.BiStatus.Valid;
                caInfo.UpdateTime    = DateTime.Now;
                CustomerManager.GetInstance().InsertCustomerAddress(caInfo);

                Response.Redirect("../Account/AddressManagement.html");
                //Response.Redirect("Register2.aspx?opt=reg");
            }
        }
Exemple #14
0
        //protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
        //{
        //    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        //    {
        //        Label lbl1 = e.Item.FindControl("lblIsDefault") as Label;
        //        Label lbl2 = e.Item.FindControl("lblBrief") as Label;
        //        ImageButton imgbtn = e.Item.FindControl("btnSelect") as ImageButton;

        //        int IsDefault = Int32.Parse(lbl1.Text);
        //        if (IsDefault == (int)AppEnum.BiStatus.Valid)
        //        {
        //            lbl2.Text = lbl2.Text + "[默认]";
        //            imgbtn.ImageUrl = "../Images/site/SelectedIcon.jpg";

        //            int sysno = Int32.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
        //            lblSysNo.Text = sysno.ToString();

        //            CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
        //            txtBrief.Text = o.Brief;
        //            txtName.Text = o.Name;
        //            txtContact.Text = o.Contact;
        //            txtCellPhone.Text = o.CellPhone;
        //            txtPhone.Text = o.Phone;
        //            scArea.AreaSysNo = o.AreaSysNo;
        //            txtAddress.Text = o.Address;
        //            txtZip.Text = o.Zip;
        //            txtFax.Text = o.Fax;
        //        }
        //        else
        //        {
        //            imgbtn.ImageUrl = "../Images/site/UnSelectedIcon.jpg";
        //        }
        //    }
        //}

        protected void btnNext_Click(object sender, EventArgs e)
        {
            if (txtName.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入收货人姓名!";
                return;
            }

            if (txtAddress.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入联系地址!";
                return;
            }

            if (txtPhone.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入联系电话!";
                return;
            }

            if (scArea.DistrictSysNo == AppConst.IntNull)
            {
                lblErrMsg.Text = "请选择地区(包括省、市、区县)";
                return;
            }

            if (txtCellPhone.Text.Trim() != "")
            {
                if (!Util.IsCellNumber(txtCellPhone.Text.Trim()))
                {
                    lblErrMsg.Text = "手机号码格式不正确,您可以不输入";
                    return;
                }
            }

            if (txtZip.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入邮政编码!";
                return;
            }
            if (txtZip.Text.Trim() != "")
            {
                if (!Util.IsZipCode(txtZip.Text.Trim()))
                {
                    lblErrMsg.Text = "邮政编码格式不正确!";
                    return;
                }
            }

            string msgLimited1 = "";  //普包、EMS限运
            string msgLimited2 = "";  //圆通航空限运

            Hashtable cartHash = CartManager.GetInstance().GetCartHash();

            if (cartHash.Count == 0)
            {
                Response.Redirect("ShoppingCart.aspx");
            }
            Hashtable sysNoHash = new Hashtable(5);

            foreach (CartInfo cartInfo in cartHash.Values)
            {
                sysNoHash.Add(cartInfo.ProductSysNo, null);
            }

            //笔记本、打火机 是圆通航空限运,笔记本是普包、EMS不限运
            string LimitedShip = "";  //包含1,为盘片、音箱耳机、液体、打火机;包含2为笔记本、打火机,1为普包、EMS全部限运,2为圆通航空限运

            Hashtable ProductHash = ProductManager.GetInstance().LoadProducts(sysNoHash);

            foreach (ProductBasicInfo oInfo in ProductHash.Values)
            {
                //盘片、音箱耳机、液体、打火机, 笔记本、液晶显示器、液晶电视
                //if (",62,64,67,72,73,74,83,169,170,171,186,191,196,197,198,210,214,239,287,434,111,234,386,562,576,577,578,579,580,".IndexOf("," + oInfo.C3SysNo + ",") >= 0)
                //笔记本,液晶不再限运
                if (",62,64,67,72,73,74,83,169,170,171,186,191,196,197,198,210,214,239,287,434,576,577,578,579,580,".IndexOf("," + oInfo.C3SysNo + ",") >= 0)
                {
                    msgLimited1 += oInfo.ProductName + "<br />";
                    LimitedShip += "1";
                }
                if (",234,562,434,576,577,578,579,580,".IndexOf("," + oInfo.C3SysNo + ",") >= 0)  //笔记本、打火机
                {
                    LimitedShip += "2";
                }
                if (oInfo.C3SysNo == 234) //笔记本
                {
                    msgLimited2 += oInfo.ProductName + "<br />";
                }
            }
            if (LimitedShip.Length > 0)
            {
                Session["HasLimitedShipProduct"]      = LimitedShip;
                Session["HasLimitedShipProductInfo1"] = msgLimited1;
                Session["HasLimitedShipProductInfo2"] = msgLimited2;
                //msgLimited += " 属限运商品,请从购物车中删除! <a href='http://www.icson.com/Service/NewsDetail.aspx?Type=Bulletin&ID=35' target='_blank'>查看限运说明</a>";
            }
            else
            {
                Session["HasLimitedShipProduct"]      = "0";
                Session["HasLimitedShipProductInfo1"] = "";
                Session["HasLimitedShipProductInfo2"] = "";
            }

            //if (scArea.ProvinceSysNo != 1 && scArea.ProvinceSysNo != 1591 && scArea.ProvinceSysNo != 3225 && scArea.ProvinceSysNo != 2621)
            //{
            //    if (msgLimited.Length > 0)
            //    {
            //        lblErrMsg.Text = msgLimited;
            //        return;
            //    }
            //}

            //是否是新增地址状态
            if (ddlAddresses.SelectedValue == "create")
            {
                ////将原来的默认地址取消默认
                //oldAddress.IsDefault = -1;
                //CustomerManager.GetInstance().UpdateCustomerAddress();

                //新地址保存
                CustomerAddressInfo o = new CustomerAddressInfo();
                o.CustomerSysNo = oSession.sCustomer.SysNo;
                o.Brief         = txtBrief.Text.Trim();
                o.Name          = txtName.Text.Trim();
                o.Contact       = txtContact.Text.Trim();
                o.Address       = txtAddress.Text.Trim();
                o.AreaSysNo     = scArea.AreaSysNo;
                o.Phone         = txtPhone.Text.Trim();
                o.CellPhone     = txtCellPhone.Text.Trim();
                o.Zip           = txtZip.Text.Trim();
                o.Fax           = txtFax.Text.Trim();
                o.IsDefault     = (int)AppEnum.BiStatus.InValid;
                o.UpdateTime    = DateTime.Now;

                if (lblSysNo.Text.Trim() == "")//原来没有默认地址,就将新增的设置为默认地址
                {
                    o.IsDefault = 0;
                }

                CustomerManager.GetInstance().InsertCustomerAddress(o);

                //新地址存入当前用户信息
                oSession.sSO = new SOInfo();
                oSession.sSO.CustomerSysNo    = o.CustomerSysNo;
                oSession.sSO.ReceiveAddress   = o.Address;
                oSession.sSO.ReceiveAreaSysNo = o.AreaSysNo;
                oSession.sSO.ReceiveCellPhone = o.CellPhone;
                oSession.sSO.ReceiveContact   = o.Contact;
                oSession.sSO.ReceiveName      = o.Name;
                oSession.sSO.ReceivePhone     = o.Phone;
                oSession.sSO.ReceiveZip       = o.Zip;

                Response.Redirect("CheckOut4.aspx");
            }
            else
            {
                int sysno             = Int32.Parse(ddlAddresses.SelectedValue);
                CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
                o.Brief     = txtBrief.Text.Trim();
                o.Name      = txtName.Text.Trim();
                o.Contact   = txtContact.Text.Trim();
                o.Address   = txtAddress.Text.Trim();
                o.AreaSysNo = scArea.AreaSysNo;
                o.Phone     = txtPhone.Text.Trim();
                o.CellPhone = txtCellPhone.Text.Trim();
                o.Zip       = txtZip.Text.Trim();
                o.Fax       = txtFax.Text.Trim();
                CustomerManager.GetInstance().UpdateCustomerAddress(o);

                oSession.sSO = new SOInfo();
                oSession.sSO.CustomerSysNo    = o.CustomerSysNo;
                oSession.sSO.ReceiveAddress   = o.Address;
                oSession.sSO.ReceiveAreaSysNo = o.AreaSysNo;
                oSession.sSO.ReceiveCellPhone = o.CellPhone;
                oSession.sSO.ReceiveContact   = o.Contact;
                oSession.sSO.ReceiveName      = o.Name;
                oSession.sSO.ReceivePhone     = o.Phone;
                oSession.sSO.ReceiveZip       = o.Zip;

                Response.Redirect("CheckOut.aspx");
            }


            //if(lblSysNo.Text == "0")
            //{
            //    CustomerAddressInfo o = new CustomerAddressInfo();
            //    o.CustomerSysNo = oSession.sCustomer.SysNo;
            //    o.Brief = txtBrief.Text.Trim();
            //    o.Name = txtName.Text.Trim();
            //    o.Contact = txtContact.Text.Trim();
            //    o.Address = txtAddress.Text.Trim();
            //    o.AreaSysNo = scArea.AreaSysNo;
            //    o.Phone = txtPhone.Text.Trim();
            //    o.CellPhone = txtCellPhone.Text.Trim();
            //    o.Zip = txtZip.Text.Trim();
            //    o.Fax = txtFax.Text.Trim();
            //    o.IsDefault = (int) AppEnum.BiStatus.InValid;
            //    o.UpdateTime = DateTime.Now;
            //    CustomerManager.GetInstance().InsertCustomerAddress(o);

            //    oSession.sSO = new SOInfo();
            //    oSession.sSO.CustomerSysNo = o.CustomerSysNo;
            //    oSession.sSO.ReceiveAddress = o.Address;
            //    oSession.sSO.ReceiveAreaSysNo = o.AreaSysNo;
            //    oSession.sSO.ReceiveCellPhone = o.CellPhone;
            //    oSession.sSO.ReceiveContact = o.Contact;
            //    oSession.sSO.ReceiveName = o.Name;
            //    oSession.sSO.ReceivePhone = o.Phone;
            //    oSession.sSO.ReceiveZip = o.Zip;

            //    Response.Redirect("CheckOut2.aspx");
            //}
            //else
            //{
            //    foreach (DataListItem item in DataList1.Items)
            //    {
            //        if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem || item.ItemType == ListItemType.SelectedItem)
            //        {
            //            ImageButton imgbtn = item.FindControl("btnSelect") as ImageButton;
            //            if (imgbtn.ImageUrl == "../Images/site/SelectedIcon.jpg")
            //            {
            //                int sysno = Int32.Parse(DataList1.DataKeys[item.ItemIndex].ToString());
            //                CustomerAddressInfo o = CustomerManager.GetInstance().LoadCustomerAddress(sysno);
            //                o.Brief = txtBrief.Text.Trim();
            //                o.Name = txtName.Text.Trim();
            //                o.Contact = txtContact.Text.Trim();
            //                o.Address = txtAddress.Text.Trim();
            //                o.AreaSysNo = scArea.AreaSysNo;
            //                o.Phone = txtPhone.Text.Trim();
            //                o.CellPhone = txtCellPhone.Text.Trim();
            //                o.Zip = txtZip.Text.Trim();
            //                o.Fax = txtFax.Text.Trim();
            //                CustomerManager.GetInstance().UpdateCustomerAddress(o);

            //                oSession.sSO = new SOInfo();
            //                oSession.sSO.CustomerSysNo = o.CustomerSysNo;
            //                oSession.sSO.ReceiveAddress = o.Address;
            //                oSession.sSO.ReceiveAreaSysNo = o.AreaSysNo;
            //                oSession.sSO.ReceiveCellPhone = o.CellPhone;
            //                oSession.sSO.ReceiveContact = o.Contact;
            //                oSession.sSO.ReceiveName = o.Name;
            //                oSession.sSO.ReceivePhone = o.Phone;
            //                oSession.sSO.ReceiveZip = o.Zip;

            //                Response.Redirect("CheckOut2.aspx");
            //                break;
            //            }
            ////        }
            //    }

            //    //没有默认的收获地址,新增的一个设为默认
            //    CustomerAddressInfo o2 = new CustomerAddressInfo();
            //    o2.CustomerSysNo = oSession.sCustomer.SysNo;
            //    o2.Brief = txtBrief.Text.Trim();
            //    o2.Name = txtName.Text.Trim();
            //    o2.Contact = txtContact.Text.Trim();
            //    o2.Address = txtAddress.Text.Trim();
            //    o2.AreaSysNo = scArea.AreaSysNo;
            //    o2.Phone = txtPhone.Text.Trim();
            //    o2.CellPhone = txtCellPhone.Text.Trim();
            //    o2.Zip = txtZip.Text.Trim();
            //    o2.Fax = txtFax.Text.Trim();
            //    o2.IsDefault = (int)AppEnum.BiStatus.Valid;
            //    o2.UpdateTime = DateTime.Now;
            //    CustomerManager.GetInstance().InsertCustomerAddress(o2);

            //    oSession.sSO = new SOInfo();
            //    oSession.sSO.CustomerSysNo = o2.CustomerSysNo;
            //    oSession.sSO.ReceiveAddress = o2.Address;
            //    oSession.sSO.ReceiveAreaSysNo = o2.AreaSysNo;
            //    oSession.sSO.ReceiveCellPhone = o2.CellPhone;
            //    oSession.sSO.ReceiveContact = o2.Contact;
            //    oSession.sSO.ReceiveName = o2.Name;
            //    oSession.sSO.ReceivePhone = o2.Phone;
            //    oSession.sSO.ReceiveZip = o2.Zip;

            //    Response.Redirect("CheckOut2.aspx");
            //}
        }
 public void Update_Customer_Address(CustomerAddressInfo customer_Address)
 {
     _sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Address(customer_Address), StoredProcedures.Update_Customer_Address.ToString(), CommandType.StoredProcedure);
 }
Exemple #16
0
        public int Update(CustomerAddressInfo oParam)
        {
            string     sql = @"UPDATE Customer_Address SET 
                            CustomerSysNo=@CustomerSysNo, Brief=@Brief, 
                            Name=@Name, Contact=@Contact, 
                            Phone=@Phone, CellPhone=@CellPhone, 
                            Fax=@Fax, Address=@Address, 
                            Zip=@Zip, AreaSysNo=@AreaSysNo, 
                            IsDefault=@IsDefault, UpdateTime=@UpdateTime
                            WHERE SysNo=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo         = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
            SqlParameter paramBrief         = new SqlParameter("@Brief", SqlDbType.NVarChar, 50);
            SqlParameter paramName          = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
            SqlParameter paramContact       = new SqlParameter("@Contact", SqlDbType.NVarChar, 50);
            SqlParameter paramPhone         = new SqlParameter("@Phone", SqlDbType.NVarChar, 50);
            SqlParameter paramCellPhone     = new SqlParameter("@CellPhone", SqlDbType.NVarChar, 50);
            SqlParameter paramFax           = new SqlParameter("@Fax", SqlDbType.NVarChar, 50);
            SqlParameter paramAddress       = new SqlParameter("@Address", SqlDbType.NVarChar, 200);
            SqlParameter paramZip           = new SqlParameter("@Zip", SqlDbType.NVarChar, 50);
            SqlParameter paramAreaSysNo     = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
            SqlParameter paramIsDefault     = new SqlParameter("@IsDefault", SqlDbType.Int, 4);
            SqlParameter paramUpdateTime    = new SqlParameter("@UpdateTime", SqlDbType.DateTime);

            if (oParam.SysNo != AppConst.IntNull)
            {
                paramSysNo.Value = oParam.SysNo;
            }
            else
            {
                paramSysNo.Value = System.DBNull.Value;
            }
            if (oParam.CustomerSysNo != AppConst.IntNull)
            {
                paramCustomerSysNo.Value = oParam.CustomerSysNo;
            }
            else
            {
                paramCustomerSysNo.Value = System.DBNull.Value;
            }
            if (oParam.Brief != AppConst.StringNull)
            {
                paramBrief.Value = oParam.Brief;
            }
            else
            {
                paramBrief.Value = System.DBNull.Value;
            }
            if (oParam.Name != AppConst.StringNull)
            {
                paramName.Value = oParam.Name;
            }
            else
            {
                paramName.Value = System.DBNull.Value;
            }
            if (oParam.Contact != AppConst.StringNull)
            {
                paramContact.Value = oParam.Contact;
            }
            else
            {
                paramContact.Value = System.DBNull.Value;
            }
            if (oParam.Phone != AppConst.StringNull)
            {
                paramPhone.Value = oParam.Phone;
            }
            else
            {
                paramPhone.Value = System.DBNull.Value;
            }
            if (oParam.CellPhone != AppConst.StringNull)
            {
                paramCellPhone.Value = oParam.CellPhone;
            }
            else
            {
                paramCellPhone.Value = System.DBNull.Value;
            }
            if (oParam.Fax != AppConst.StringNull)
            {
                paramFax.Value = oParam.Fax;
            }
            else
            {
                paramFax.Value = System.DBNull.Value;
            }
            if (oParam.Address != AppConst.StringNull)
            {
                paramAddress.Value = oParam.Address;
            }
            else
            {
                paramAddress.Value = System.DBNull.Value;
            }
            if (oParam.Zip != AppConst.StringNull)
            {
                paramZip.Value = oParam.Zip;
            }
            else
            {
                paramZip.Value = System.DBNull.Value;
            }
            if (oParam.AreaSysNo != AppConst.IntNull)
            {
                paramAreaSysNo.Value = oParam.AreaSysNo;
            }
            else
            {
                paramAreaSysNo.Value = System.DBNull.Value;
            }
            if (oParam.IsDefault != AppConst.IntNull)
            {
                paramIsDefault.Value = oParam.IsDefault;
            }
            else
            {
                paramIsDefault.Value = System.DBNull.Value;
            }
            if (oParam.UpdateTime != AppConst.DateTimeNull)
            {
                paramUpdateTime.Value = oParam.UpdateTime;
            }
            else
            {
                paramUpdateTime.Value = System.DBNull.Value;
            }

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramCustomerSysNo);
            cmd.Parameters.Add(paramBrief);
            cmd.Parameters.Add(paramName);
            cmd.Parameters.Add(paramContact);
            cmd.Parameters.Add(paramPhone);
            cmd.Parameters.Add(paramCellPhone);
            cmd.Parameters.Add(paramFax);
            cmd.Parameters.Add(paramAddress);
            cmd.Parameters.Add(paramZip);
            cmd.Parameters.Add(paramAreaSysNo);
            cmd.Parameters.Add(paramIsDefault);
            cmd.Parameters.Add(paramUpdateTime);

            return(SqlHelper.ExecuteNonQuery(cmd));
        }
Exemple #17
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            AddressInfo.Visible = true;
            if (txtName.Text == "" || txtName.Text == null)
            {
                lblErrMsg.Text = "请输入收货人姓名!";
                return;
            }
            if (txtContact.Text == "" || txtContact.Text == null)
            {
                lblErrMsg.Text = "请输入收货联系人信息!";
                return;
            }
            if (txtPhone.Text == null || txtPhone.Text == "")
            {
                lblErrMsg.Text = "请输入收货联系电话!";
                return;
            }
            if (txtAddress.Text == "" || txtAddress.Text == null)
            {
                lblErrMsg.Text = "请输入收货联系地址!";
                return;
            }
            if (scArea.DistrictSysNo == AppConst.IntNull)
            {
                lblErrMsg.Text = "请选择地区(包括省、市、区县)";
                return;
            }

            if (txtCellPhone.Text.Trim() != "")
            {
                if (!Util.IsCellNumber(txtCellPhone.Text.Trim()))
                {
                    lblErrMsg.Text = "手机号码格式不正确,您可以不输入";
                    return;
                }
            }

            if (txtZip.Text.Trim() == "")
            {
                lblErrMsg.Text = "请输入邮政编码!";
                return;
            }

            if (txtZip.Text.Trim() != "")
            {
                if (!Util.IsZipCode(txtZip.Text.Trim()))
                {
                    lblErrMsg.Text = "邮政编码格式不正确!";
                    return;
                }
            }

            CustomerAddressInfo o = new CustomerAddressInfo();
            int sysno             = Int32.Parse(lblSysNo.Text);

            o.SysNo         = sysno;
            o.CustomerSysNo = Int32.Parse(lblCustomerSysNo.Text);
            o.Brief         = txtBrief.Text.Trim();
            o.Name          = txtName.Text.Trim();
            o.Contact       = txtContact.Text.Trim();
            o.CellPhone     = txtCellPhone.Text.Trim();
            o.Phone         = txtPhone.Text.Trim();
            o.Address       = txtAddress.Text.Trim();
            o.AreaSysNo     = scArea.AreaSysNo;
            o.Zip           = txtZip.Text.Trim();
            o.Fax           = txtFax.Text.Trim();
            o.IsDefault     = Int32.Parse(lblIsDefault.Text);
            o.UpdateTime    = DateTime.Now;

            if (sysno > 0)
            {
                CustomerManager.GetInstance().UpdateCustomerAddress(o);
            }
            else
            {
                if (CustomerManager.GetInstance().LoadCustomerAddressByCustomer(o.CustomerSysNo) == null)
                {
                    o.IsDefault = (int)AppEnum.BiStatus.Valid;
                }
                CustomerManager.GetInstance().InsertCustomerAddress(o);
            }
            BindAddressList();

            btnSubmit.Enabled   = false;
            AddressInfo.Visible = false;
        }
Exemple #18
0
 public void Update_Customer_Address(CustomerAddressInfo customer_Address)
 {
     _customerRepo.Update_Customer_Address(customer_Address);
 }
Exemple #19
0
 public void Insert_Customer_Address(CustomerAddressInfo customer_Address)
 {
     _customerRepo.Insert_Customer_Address(customer_Address);
 }
Exemple #20
0
        public HttpResponseMessage Post([FromBody] jsonOperatorRequest injson)
        {
            HttpResponseMessage      message  = null;
            jsonCustomerInfoResponse response = new jsonCustomerInfoResponse();

            try
            {
                string idcardinfo             = string.Format(constantValue.REQUESTXML, constantValue.IDCARDWS, injson.customerFingerPrint, injson.customerRegNo, injson.operatorFingerPrint, injson.operatorRegNo);
                string addressinfo            = string.Format(constantValue.REQUESTXML, constantValue.ADDRESSWS, injson.customerFingerPrint, injson.customerRegNo, injson.operatorFingerPrint, injson.operatorRegNo);
                string idcardresponse         = string.Empty;
                string addressresponse        = string.Empty;
                bool   _workingStatus         = false;
                string __workingStatusMessage = string.Empty;
                if (httpPoster.Poster(idcardinfo, out idcardresponse))
                {
                    if (httpPoster.Poster(addressinfo, out addressresponse))
                    {
                        LogWriter._xyp(TAG, string.Format("WS: [{0}], OPERATOR:[{1}], RESPONSE: [{2}], REQUEST:[{3}]", constantValue.IDCARDWS, injson.loginName, idcardresponse, idcardinfo));
                        LogWriter._xyp(TAG, string.Format("WS: [{0}], OPERATOR:[{1}], RESPONSE: [{2}], REQUEST:[{3}]", constantValue.ADDRESSWS, injson.loginName, addressresponse, addressinfo));
                        XmlSerializer xmlserIDCARD = new XmlSerializer(typeof(IDCardInfo));
                        XmlSerializer xmlserADDR   = new XmlSerializer(typeof(AddressInfo));
                        XNamespace    nsS          = "http://schemas.xmlsoap.org/soap/envelope/";
                        XNamespace    ns2          = "http://citizen.xyp.gov.mn/";

                        #region Parse IDCARDINFO
                        XElement xIDCARDresponse = XElement.Parse(idcardresponse);
                        var      soapResponseXml = xIDCARDresponse.Element(nsS + "Body").Element(ns2 + "WS100101_getCitizenIDCardInfoResponse").Element("return");
                        string   orgIDCARDres    = soapResponseXml.ToString().Replace("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"", "").Replace("xsi:type=\"ns2:citizenRequestData\"", "").Replace("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"", "").Replace("xsi:type=\"ns2:citizenData\"", "");//.Replace(" ","");
                        //LogWriter._error(TAG, orgIDCARDres);
                        using (TextReader sertext = new StringReader(orgIDCARDres))
                        {
                            IDCardInfo idcard = (IDCardInfo)xmlserIDCARD.Deserialize(sertext);
                            try
                            {
                                if (idcard.ResultCode == "0")
                                {
                                    response.aimagCityCode      = idcard.resp.AimagCityCode;
                                    response.aimagCityName      = idcard.resp.AimagCityName;
                                    response.bagKhorooCode      = idcard.resp.BagKhorooCode;
                                    response.bagKhorooName      = idcard.resp.BagKhorooName;
                                    response.birthDateAsText    = idcard.resp.BirthDateAsText;
                                    response.birthPlace         = idcard.resp.BirthPlace;
                                    response.civilId            = idcard.resp.CivilId;
                                    response.firstName          = idcard.resp.Firstname;
                                    response.gender             = idcard.resp.Gender;
                                    response.lastName           = idcard.resp.Lastname;
                                    response.nationality        = idcard.resp.Nationality;
                                    response.image              = idcard.resp.Image;
                                    response.passportAddress    = idcard.resp.PassportAddress;
                                    response.passportExpireDate = idcard.resp.PassportExpireDate;
                                    response.passportIssueDate  = idcard.resp.PassportIssueDate;
                                    response.personId           = idcard.resp.PersonId;
                                    response.regnum             = idcard.resp.Regnum;
                                    response.soumDistrictCode   = idcard.resp.SoumDistrictCode;
                                    response.soumDistrictName   = idcard.resp.SoumDistrictName;
                                    response.surname            = idcard.resp.Surname;
                                    _workingStatus              = true;
                                    __workingStatusMessage      = "success";
                                }
                                else
                                {
                                    _workingStatus         = false;
                                    __workingStatusMessage = string.Format("[XYP] CODE: [{0}], MESSAGE: [{1}]", idcard.ResultCode, idcard.ResultMessage);
                                }
                            }
                            catch (Exception ex)
                            {
                                exceptionManager.ManageException(ex, TAG);
                                _workingStatus         = false;
                                __workingStatusMessage = "Иргэний үнэмлэхний мэдээлэл задлахад алдаа гарлаа. Систем админд хандана уу.";
                            }
                        }
                        #endregion
                        #region Parse ADDRESSINFO
                        XElement xADDRESSresponse    = XElement.Parse(addressresponse);
                        var      soapaddrResponseXml = xADDRESSresponse.Element(nsS + "Body").Element(ns2 + "WS100103_getCitizenAddressInfoResponse").Element("return");
                        string   orgADDRres          = soapaddrResponseXml.ToString().Replace("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"", "").Replace("xsi:type=\"ns2:citizenRequestData\"", "").Replace("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"", "").Replace("xsi:type=\"ns2:citizenAddressData\"", "");//.Replace(" ", "");
                        //LogWriter._error(TAG, orgADDRres);

                        using (TextReader seraddrtext = new StringReader(orgADDRres))
                        {
                            try
                            {
                                AddressInfo addrInfo = (AddressInfo)xmlserADDR.Deserialize(seraddrtext);
                                if (_workingStatus)
                                {
                                    if (addrInfo.ResultCode == "0")
                                    {
                                        CustomerAddressInfo cusAddrinfo = new CustomerAddressInfo();
                                        cusAddrinfo.addressApartmentName = addrInfo.resp.AddressApartmentName;
                                        cusAddrinfo.addressDetail        = addrInfo.resp.AddressDetail;
                                        cusAddrinfo.addressRegionName    = addrInfo.resp.AddressRegionName;
                                        cusAddrinfo.aimagCityCode        = addrInfo.resp.AimagCityCode;
                                        cusAddrinfo.aimagCityName        = addrInfo.resp.AimagCityName;
                                        cusAddrinfo.bagKhorooCode        = addrInfo.resp.BagKhorooCode;
                                        cusAddrinfo.bagKhorooName        = addrInfo.resp.BagKhorooName;
                                        cusAddrinfo.fullAddress          = addrInfo.resp.FullAddress;
                                        cusAddrinfo.soumDistrictCode     = addrInfo.resp.SoumDistrictCode;
                                        cusAddrinfo.soumDistrictName     = addrInfo.resp.SoumDistrictName;
                                        response.customerAddressInfo     = cusAddrinfo;
                                        _workingStatus         = true;
                                        __workingStatusMessage = "success";
                                    }
                                    else
                                    {
                                        _workingStatus         = false;
                                        __workingStatusMessage = string.Format("[XYP] CODE: [{0}], MESSAGE: [{1}]", addrInfo.ResultCode, addrInfo.ResultMessage);
                                    }
                                }
                            }
                            catch (Exception EX)
                            {
                                exceptionManager.ManageException(EX, TAG);
                                _workingStatus         = false;
                                __workingStatusMessage = "Иргэний хаягийн мэдээлэл задлахад алдаа гарлаа. Систем админд хандана уу.";
                            }
                        }
                        #endregion
                        if (_workingStatus)
                        {
                            response.isSuccess     = true;
                            response.resultMessage = "success";
                        }
                        else
                        {
                            response.isSuccess     = false;
                            response.resultMessage = __workingStatusMessage;
                        }
                    }
                    else
                    {
                        response.isSuccess     = false;
                        response.resultMessage = "ХУР системээс иргэний хаягийн мэдээлэл авахад алдаа гарлаа. Систем админд хандана уу.";
                    }
                }
                else
                {
                    response.isSuccess     = false;
                    response.resultMessage = "ХУР системээс Иргэний үнэмлэхний мэдээлэл авахад алдаа гарлаа. Систем админд хандана уу.";
                }
            }
            catch (Exception ex)
            {
                exceptionManager.ManageException(ex, TAG);
                response.isSuccess     = false;
                response.resultMessage = ex.Message;
            }
            message = Request.CreateResponse(HttpStatusCode.OK, response);
            LogWriter._service(TAG, string.Format("IP: [{0}], REQUEST: [{1}], RESPONSE: [{2}]", httpPoster.GetClientIPAddress(HttpContext.Current.Request), serialzer.Serialize(injson), serialzer.Serialize(response)));
            return(message);
        }