/// <summary> /// 用户注册 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddHolidayUsers(HD_HoliDayUsers model) { string sql = @"INSERT INTO [HD_HoliDayUsers] ([ID],[HID],[OpenID],[Phone],[NickName],[Married],[Age],[AddTime],[IsDel])" + " VALUES (@ID,@HID,@OpenID,@Phone,@NickName,@Married,@Age,@AddTime,@IsDel)"; System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ID", model.ID), new System.Data.SqlClient.SqlParameter("@HID", model.HID), new System.Data.SqlClient.SqlParameter("@OpenID", model.OpenID), new System.Data.SqlClient.SqlParameter("@Phone", model.Phone), new System.Data.SqlClient.SqlParameter("@NickName", model.NickName), new System.Data.SqlClient.SqlParameter("@Married", model.Married), new System.Data.SqlClient.SqlParameter("@Age", model.Age), new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now), new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0)) }; int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 用户注册 /// </summary> void saveUserinfo() { string nickname = string.Empty; string phone = string.Empty; string age = string.Empty; string married = string.Empty; if (Request["nickname"] != null && Request["nickname"] != "") { nickname = Common.Common.NoHtml(Request["nickname"]); } if (Request["phone"] != null && Request["phone"] != "") { phone = Common.Common.NoHtml(Request["phone"]); } if (Request["age"] != null && Request["age"] != "") { age = Common.Common.NoHtml(Request["age"]); } if (Request["married"] != null && Request["married"] != "") { married = Common.Common.NoHtml(Request["married"]); } HoliDayUsersDAL userdal = new HoliDayUsersDAL(); HD_HoliDayUsers usermodel = new HD_HoliDayUsers(); if (userdal.ExistHoliDayUsers("", phone, strSiteCode)) { Response.Write("{\"message\":\"不能重复提交!\"}"); return; } if (nickname.Trim() != null && nickname.Trim() != "") { usermodel.NickName = nickname; } if (phone.Trim() != null && phone.Trim() != "") { usermodel.Phone = phone; } if (age.Trim() != null && age.Trim() != "") { usermodel.Age = Convert.ToInt32(age); } if (married.Trim() != null && married.Trim() != "") { usermodel.Married = married; } usermodel.IsDel = 0; usermodel.HID = strID; usermodel.OpenID = ""; usermodel.ID = Guid.NewGuid().ToString("N").ToUpper(); if (userdal.AddHolidayUsers(usermodel)) { Response.Write("{\"message\":\"操作成功!\"}"); return; } }
/// <summary> /// 用户信息修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateHoliDayUsers(HD_HoliDayUsers model) { string safesql = " update HD_HoliDayUsers set "; if (model.HID != null && model.HID != "") { safesql += " HID='" + model.HID + "',"; } if (model.OpenID != null && model.OpenID != "") { safesql += " OpenID='" + model.OpenID + "',"; } if (model.Phone != null && model.Phone != "") { safesql += " Phone='" + model.Phone + "',"; } if (model.NickName != null && model.NickName.ToString() != "") { safesql += " NickName='" + model.NickName + "',"; } if (model.Married != null && model.Married.ToString() != "") { safesql += " Married='" + model.Married + "',"; } if (model.Age != null && model.Age.ToString() != "") { safesql += " Age=" + model.Age + ","; } safesql += " IsDel=" + (model.IsDel == 1 ? 1 : 0); safesql += " where ID='" + model.ID + "' "; int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }