/// <summary>
/// 增加客户信息
/// </summary>
/// <param name="info">客户信息</param>
/// <returns>客户编号</returns>
public string AddGuestInfo(GuestInfo info)
{
string sql = string.Format(@"INSERT [dbo].[GuestInfo]([Name], [CardNo], [Phone], [Sex])
VALUES ('{0}','{1}','{2}','{3}')
SELECT @@IDENTITY", info.Name, info.CardNo, info.Phone, info.Sex);
string guestId = DBHerper.Scalar(sql).ToString();
return(guestId);
}
/// <summary>
/// 修改客户信息
/// </summary>
/// <param name="info">客户信息</param>
/// <returns>客户编号</returns>
public string UpdateGuestInfo(GuestInfo info)
{
string sql = string.Format(@"UPDATE [dbo].[GuestInfo]
SET [Name]='{0}',[Phone]='{1}',[Sex]='{2}'
WHERE [CardNo]='{3}'
SELECT [ID]
FROM [dbo].[GuestInfo]
WHERE [CardNo]='{3}'", info.Name, info.Phone, info.Sex, info.CardNo);
string guestId = DBHerper.Scalar(sql).ToString();
return(guestId);
}