protected void hooyesRegisterBtn_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); string vName = Request["vName"].ToString(); string vGender = Request["vGender"].ToString(); string vTitle = Request["vTitle"].ToString(); string vPhone = Request["vPhone"].ToString(); string vCellPhone = Request["vCellPhone"].ToString(); string spacor = "|#|"; sb.Append(vName); sb.Append(spacor); sb.Append(vGender); sb.Append(spacor); sb.Append(vTitle); sb.Append(spacor); sb.Append(vPhone); sb.Append(spacor); sb.Append(vCellPhone); string Vistors = sb.ToString(); CRCapply model = new CRCapply(); model.sn =Request["sn"].ToString(); //Response.Write(model.sn); model.CompanyAddress = CompanyAddress.Text; model.CompanyName = CompanyName.Text; model.CompanyNameEn = CompanyNameEn.Text; model.WebSite = WebSite.Text; model.Phone = Phone.Text; model.CellPhone = CellPhone.Text; model.Fax = Fax.Text; model.PostCode = PostCode.Text; model.Suggestion = Suggestion.Text; model.Contact = Contact.Text; model.Email = Email.Text; model.CompanyType = RadioButtonCompanyType.SelectedValue; model.ProductType = RadioButtonProductType.SelectedValue; model.Vistors = Vistors; model.Pay = (RadioButtonListPay.SelectedValue == "1"); model.Invoice = (RadioButtonListInvoic.SelectedValue == "1"); RegisterAdmin reg = new RegisterAdmin(); bool flag = reg.update(model); if (flag) { GoThankYouUrl("../", "修改成功!", Request.Url.PathAndQuery, "javascript:parent.tb_remove();", " 查 看 ", "关闭窗口"); } }
protected void hooyesRegisterBtn_Click(object sender, EventArgs e) { Register reg = new Register(); if (!string.IsNullOrEmpty(CompanyName.Text)) { if (reg.exist(CompanyName.Text)) { string js = @"<script type='text/javascript'> alert('您填写的公司名称已经注册过了\r若需要更新信息请联系我们'); </script>"; this.Page.ClientScript.RegisterClientScriptBlock(typeof(System.Web.UI.Page), "script", js); } else { #region 注册 StringBuilder sb = new StringBuilder(); string vName = Request["vName"].ToString(); string vGender = Request["vGender"].ToString(); string vTitle = Request["vTitle"].ToString(); string vPhone = Request["vPhone"].ToString(); string vCellPhone = Request["vCellPhone"].ToString(); string spacor = "|#|"; sb.Append(vName); sb.Append(spacor); sb.Append(vGender); sb.Append(spacor); sb.Append(vTitle); sb.Append(spacor); sb.Append(vPhone); sb.Append(spacor); sb.Append(vCellPhone); string Vistors = sb.ToString(); CRCapply model = new CRCapply(); model.sn = Guid.NewGuid().ToString(); model.CompanyAddress = CompanyAddress.Text; model.CompanyName = CompanyName.Text; model.CompanyNameEn = CompanyNameEn.Text; model.WebSite = WebSite.Text; model.Phone = Phone.Text; model.CellPhone = CellPhone.Text; model.Fax = Fax.Text; model.PostCode = PostCode.Text; model.Suggestion = Suggestion.Text; model.Contact = Contact.Text; model.Email = Email.Text; model.CompanyType = RadioButtonCompanyType.SelectedValue; model.ProductType = RadioButtonProductType.SelectedValue; model.Vistors = Vistors; bool flag = reg.insert(model); if (flag) { GoThankYouUrl(",注册成功!请及时电汇会议注册费以确认参会! ", Request.Url.PathAndQuery, "javascript:parent.tb_remove();", "继续注册", "关闭窗口"); } #endregion } } }
protected void hooyesRegisterBtn_Click(object sender, EventArgs e) { Register reg = new Register(); if (!string.IsNullOrEmpty(CompanyName.Text)) { if (reg.exist(CompanyName.Text)) { string js = @"<script type='text/javascript'> alert('Your company have been register \rPlease Contact us to update infomation'); </script>"; this.Page.ClientScript.RegisterClientScriptBlock(typeof(System.Web.UI.Page), "script", js); } else { StringBuilder sb = new StringBuilder(); string vName = Request["vName"].ToString(); string vGender = Request["vGender"].ToString(); string vTitle = Request["vTitle"].ToString(); string vPhone = Request["vPhone"].ToString(); string vCellPhone = Request["vCellPhone"].ToString(); string spacor = "|#|"; sb.Append(vName); sb.Append(spacor); sb.Append(vGender); sb.Append(spacor); sb.Append(vTitle); sb.Append(spacor); sb.Append(vPhone); sb.Append(spacor); sb.Append(vCellPhone); string Vistors = sb.ToString(); CRCapply model = new CRCapply(); model.sn = Guid.NewGuid().ToString(); model.CompanyAddress = CompanyAddress.Text; model.CompanyName = CompanyName.Text; model.CompanyNameEn = CompanyName.Text;// CompanyNameEn.Text; model.WebSite = WebSite.Text; model.Phone = Phone.Text; model.CellPhone = Phone.Text;// CellPhone.Text; model.Fax = Fax.Text; model.PostCode = PostCode.Text; model.Suggestion = Suggestion.Text; model.Contact = Contact.Text; model.Email = Email.Text; model.CompanyType = RadioButtonCompanyType.SelectedValue; model.ProductType = RadioButtonProductType.SelectedValue; model.Vistors = Vistors; bool flag = reg.insert(model); if (flag) { GoThankYouUrl(",Successfully registered! Please make the payment now, and all registration is to be confirmed on the receipt of your conference fee. ", Request.Url.PathAndQuery, "javascript:parent.tb_remove();", "Register another one", "Close The Window"); } } } }
protected void InitPage() { string sn = Request.QueryString.Get("sn"); if (com.hooyes.crc.helper.Validate.GuidString(sn)) { CRCapply model = new CRCapply(); RegisterAdmin reg = new RegisterAdmin(); model = reg.model(sn); CompanyAddress.Text = model.CompanyAddress; CompanyName.Text = model.CompanyName; CompanyNameEn.Text = model.CompanyNameEn; WebSite.Text = model.WebSite; Phone.Text = model.Phone; CellPhone.Text = model.CellPhone; Fax.Text = model.Fax; PostCode.Text = model.PostCode; Suggestion.Text = model.Suggestion; Contact.Text = model.Contact; Email.Text = model.Email; //单选框初始化 RadioButtonListPay.SelectedIndex = (model.Pay) ? 0 : 1; RadioButtonListInvoic.SelectedIndex = (model.Invoice) ? 0 : 1; string TypeScript = "<script type=\"text/javascript\">SelectAapter('{0}','{1}');</script>"; this.Page.ClientScript.RegisterStartupScript(typeof(Page), "script1", string.Format(TypeScript,"RadioButtonCompanyType", model.CompanyType)); this.Page.ClientScript.RegisterStartupScript(typeof(Page), "script2", string.Format(TypeScript, "RadioButtonProductType", model.ProductType)); //Vistors string Vistors = model.Vistors; string[] vSpace ={ "|#|" }; string[] vComma ={ "," }; string[] vS = Vistors.Split(vSpace, StringSplitOptions.None); string[] vName = vS[0].Split(vComma, StringSplitOptions.None); string[] vGender = vS[1].Split(vComma, StringSplitOptions.None); string[] vTitle = vS[2].Split(vComma, StringSplitOptions.None); string[] vPhone = vS[3].Split(vComma, StringSplitOptions.None); string[] vCellPhone = vS[4].Split(vComma, StringSplitOptions.None); // HTML StringBuilder sb = new StringBuilder(); string HTMLTemplate = @"<div id=""HOOYESDIVCCC{7}""><table width='100%'> <tr><td><input name=""vName"" class=""RegisterInputShort"" type=""text"" value='{0}' /></td><td> <select name=""vGender""><option value="""">请选择</option><option {5} value=""female"">女</option> <option {6} value=""male"">男</option> </select> </td> <td><input name=""vTitle"" class=""RegisterInputShort"" type=""text"" value='{2}' /></td><td> <input name=""vPhone"" class=""RegisterInputShort"" type=""text"" value='{3}' /></td><td> <input name=""vCellPhone"" class=""RegisterInputShort"" type=""text"" value='{4}' /></td><td width='5%'><a href='javascript:void(0)' onclick=""Remove('HOOYESDIVCCC{7}')"">删除</a></td></tr></table></div>"; object[] param = new object[8]; for (int i = 0; i < vName.Length; i++) { param[0] = vName[i]; param[1] = vGender[i]; param[2] = vTitle[i]; param[3] = vPhone[i]; param[4] = vCellPhone[i]; param[5] = ""; param[6] = ""; param[7] = i; // Response.Write(param[1]); if (vGender[i] == "female") { param[5] = "selected=\"selected\""; } if (vGender[i] == "male") { param[6] = "selected=\"selected\""; } sb.AppendFormat(HTMLTemplate, param); } vLiteral1.Text = sb.ToString(); } else { Response.Write("sn 参数不正确"); Response.End(); } }
public List<CRCapply> ListModel() { List<CRCapply> lt = new List<CRCapply>(); string sql = "select * from CRC_apply order by ID desc"; OleDbDataReader dr = AccessHelper.ExecuteReader(AccessHelper.conn, sql); while (dr.Read()) { CRCapply model = new CRCapply(); model.ID = Convert.ToDecimal(dr["ID"]); model.sn = Convert.ToString(dr["sn"]); model.CompanyAddress = Convert.ToString(dr["CompanyAddress"]); model.CompanyName = Convert.ToString(dr["CompanyName"]); model.CompanyNameEn = Convert.ToString(dr["CompanyNameEn"]); model.WebSite = Convert.ToString(dr["WebSite"]); model.Phone = Convert.ToString(dr["Phone"]); model.CellPhone = Convert.ToString(dr["CellPhone"]); model.Fax = Convert.ToString(dr["Fax"]); model.PostCode = Convert.ToString(dr["PostCode"]); model.Suggestion = Convert.ToString(dr["Suggestion"]); model.Contact = Convert.ToString(dr["Contact"]); model.Email = Convert.ToString(dr["Email"]); model.Vistors = Convert.ToString(dr["Vistors"]); model.RegisterTime = Convert.ToDateTime(dr["RegisterTime"]); model.ProductType = Convert.ToString(dr["ProductType"]); model.CompanyType = Convert.ToString(dr["CompanyType"]); model.Pay = Convert.ToBoolean(dr["Pay"]); model.Invoice = Convert.ToBoolean(dr["Invoice"]); lt.Add(model); } dr.Close(); dr.Dispose(); return lt; }
public CRCapply model(string sn) { CRCapply model = new CRCapply(); string sql = "select * from CRC_apply where sn=@sn"; OleDbDataReader dr = AccessHelper.ExecuteReader(AccessHelper.conn, sql, new OleDbParameter("@sn", sn)); if (dr.Read()) { model.ID = Convert.ToDecimal(dr["ID"]); model.sn = Convert.ToString(dr["sn"]); model.CompanyAddress = Convert.ToString(dr["CompanyAddress"]); model.CompanyName = Convert.ToString(dr["CompanyName"]); model.CompanyNameEn = Convert.ToString(dr["CompanyNameEn"]); model.WebSite = Convert.ToString(dr["WebSite"]); model.Phone = Convert.ToString(dr["Phone"]); model.CellPhone = Convert.ToString(dr["CellPhone"]); model.Fax = Convert.ToString(dr["Fax"]); model.PostCode = Convert.ToString(dr["PostCode"]); model.Suggestion = Convert.ToString(dr["Suggestion"]); model.Contact = Convert.ToString(dr["Contact"]); model.Email = Convert.ToString(dr["Email"]); model.Vistors = Convert.ToString(dr["Vistors"]); model.RegisterTime = Convert.ToDateTime(dr["RegisterTime"]); model.ProductType = Convert.ToString(dr["ProductType"]); model.CompanyType = Convert.ToString(dr["CompanyType"]); model.Pay = Convert.ToBoolean(dr["Pay"]); model.Invoice = Convert.ToBoolean(dr["Invoice"]); } dr.Close(); dr.Dispose(); return model; }
public List<CRCapply> ListModel(int PageSize, int CurrentPage, string keyWord) { if (!string.IsNullOrEmpty(keyWord)) { keyWord = keyWord.Replace("'", ""); int RecordsCount = count(keyWord); PageSize = (PageSize > 0) ? PageSize : 1; int PagesCount = RecordsCount / PageSize; PagesCount = ((RecordsCount % PageSize) == 0) ? PagesCount : PagesCount + 1; CurrentPage = (CurrentPage > PagesCount) ? PagesCount : CurrentPage; List<CRCapply> lt = new List<CRCapply>(); StringBuilder sb = new StringBuilder(); sb.AppendFormat("select top {0} * from CRC_apply ", PageSize); sb.AppendFormat(" where CompanyName like '%{0}%'", keyWord); if (CurrentPage > 1) { sb.AppendFormat(" and ID not in(select top {0} id from CRC_apply order by id desc)", (CurrentPage - 1) * PageSize); } sb.Append(" order by ID desc"); string sql = sb.ToString(); OleDbDataReader dr = AccessHelper.ExecuteReader(AccessHelper.conn, sql); while (dr.Read()) { CRCapply model = new CRCapply(); model.ID = Convert.ToDecimal(dr["ID"]); model.sn = Convert.ToString(dr["sn"]); model.CompanyAddress = Convert.ToString(dr["CompanyAddress"]); model.CompanyName = Convert.ToString(dr["CompanyName"]); model.CompanyNameEn = Convert.ToString(dr["CompanyNameEn"]); model.WebSite = Convert.ToString(dr["WebSite"]); model.Phone = Convert.ToString(dr["Phone"]); model.CellPhone = Convert.ToString(dr["CellPhone"]); model.Fax = Convert.ToString(dr["Fax"]); model.PostCode = Convert.ToString(dr["PostCode"]); model.Suggestion = Convert.ToString(dr["Suggestion"]); model.Contact = Convert.ToString(dr["Contact"]); model.Email = Convert.ToString(dr["Email"]); model.Vistors = Convert.ToString(dr["Vistors"]); model.RegisterTime = Convert.ToDateTime(dr["RegisterTime"]); model.ProductType = Convert.ToString(dr["ProductType"]); model.CompanyType = Convert.ToString(dr["CompanyType"]); model.Pay = Convert.ToBoolean(dr["Pay"]); model.Invoice = Convert.ToBoolean(dr["Invoice"]); lt.Add(model); } dr.Close(); dr.Dispose(); return lt; } else { return ListModel(PageSize, CurrentPage); } }