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