public static string RegisterGuest(string mInfo)
{
string returnStr = "";
JObject objVenue = JObject.Parse(mInfo);
try
{
using (venuesEntities db = new venuesEntities())
{
string guestName = objVenue["GuestName"].ToString();
Boolean ishasUser = false;
string strSql = string.Format("SELECT tg.GuestName FROM tbl_guest AS tg WHERE tg.GuestName='{0}'", guestName);
ObjectQuery<DbDataRecord> results = db.CreateQuery<DbDataRecord>(strSql);
foreach (var ks in results)
{
ishasUser = true;
}
if (!ishasUser)
{
tbl_guest tbt = new tbl_guest();
tbt.GuestContact = objVenue["GuestContact"].ToString();
tbt.GuestCreateTime = DateTime.Now;
tbt.GuestEmail = objVenue["GuestEmail"].ToString();
tbt.GuestIP = objVenue["GuestIP"].ToString();
tbt.GuestName = objVenue["GuestName"].ToString();
tbt.GuestPassword =GeneralFuction.MD5Encrypt(objVenue["GuestPassword"].ToString());
tbt.GuestRemark = objVenue["GuestRemark"].ToString();
tbt.Region = objVenue["Region"].ToString();
tbt.Sector = objVenue["Sector"].ToString();
db.AddTotbl_guest(tbt);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
}
else
{
returnStr = KeyManager.RetrunUnSucceed;
}
}
else
{
returnStr = "不成功,已有名称为“" + guestName + "”的用户。";
}
}
}
catch (Exception e)
{
returnStr = e.Message;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VisitorManager, "注册新游客，mInfo=" + mInfo + ";错误信息：" + e.Message, null);
}
return returnStr;
}