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);
}
}
