/// <summary>
/// 返回新增成功后的ID
/// </summary>
/// <param name="mHis"></param>
/// <returns></returns>
public int InsertCustomer(CustomerModel mCustomer)
{
try
{
CUSTOMER_INFO ci = new CUSTOMER_INFO();
ci.ADDRESS = mCustomer.Address;
ci.BIRTHDAY = mCustomer.Birthday;
ci.COMPANY = mCustomer.Company;
ci.CREATE_DATE = GetDBTime;
ci.CREATE_USERID = mCustomer.CommonInfo.CreateUserId;
ci.ID_CARD = mCustomer.IdCardNo;
ci.NAME = mCustomer.Name;
ci.NATION = mCustomer.Nation;
ci.PHONE = mCustomer.Phone;
ci.PICTURE = mCustomer.Picture;
ci.SEX = mCustomer.Sex;
ci.TYPE = mCustomer.Type;
ci.UPDATE_DATE = GetDBTime;
ci.UPDATE_USERID = mCustomer.CommonInfo.UpdateUserId;
dc.CUSTOMER_INFO.InsertOnSubmit(ci);
dc.SubmitChanges();
return ci.CUSTOMER_ID;
}
catch (Exception err)
{
throw err;
}
}
public List<CustomerModel> GetCustomerInfo(CustomerModel mCustomer, ObjectControls oCtrl)
{
string sql = @"SELECT CUSTOMER_ID, ID_CARD, NAME, SEX, NATION, BIRTHDAY, ADDRESS, COMPANY,
PHONE, PICTURE, TYPE, CREATE_DATE, CREATE_USERID, UPDATE_DATE,
UPDATE_USERID
FROM CUSTOMER_INFO WHERE 1=1";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByCustomerId) && oCtrl.Append(ref sql, " AND CUSTOMER_ID=" + mCustomer.CustomerId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByName) && oCtrl.Append(ref sql, " AND NAME=" + SQL(mCustomer.Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByIdCard)&& oCtrl.Append( ref sql, " AND ID_CARD=" + SQL(mCustomer.IdCardNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.BySex)&& oCtrl.Append( ref sql, " AND SEX=" + SQL(mCustomer.Sex)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByPhone)&& oCtrl.Append(ref sql, " AND PHONE=" + SQL(mCustomer.Phone)));
//oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayId)&& oCtrl.Append(ref sql, " AND A.STAY_ID=" + mCustomer.StayId));
sdr = ExecuteReader(sql);
List<CustomerModel> listCustomer = new List<CustomerModel>();
using (sdr)
{
while (sdr.Read())
{
CustomerModel mCustomerInfo = new CustomerModel();
mCustomerInfo.CustomerId = ToInt32(sdr["CUSTOMER_ID"]);
// mCustomerInfo.CustomerStayHisInfo.StayId = ToInt32(sdr["STAY_ID"]);
mCustomerInfo.IdCardNo = ToString(sdr["ID_CARD"]);
mCustomerInfo.Name = ToString(sdr["NAME"]);
mCustomerInfo.Sex = ToString(sdr["SEX"]);
mCustomerInfo.Birthday = ToDateTime(sdr["BIRTHDAY"]);
mCustomerInfo.Address = ToString(sdr["ADDRESS"]);
mCustomerInfo.Company = ToString(sdr["COMPANY"]);
mCustomerInfo.Nation = ToString(sdr["NATION"]);
mCustomerInfo.Phone = ToString(sdr["PHONE"]);
mCustomerInfo.Picture = ToString(sdr["PICTURE"]);
mCustomerInfo.Type = ToChar(sdr["TYPE"]);
mCustomerInfo.CommonInfo = new CommonModel();
mCustomerInfo.CommonInfo.CreateDate = ToDateTime(sdr["CREATE_DATE"]);
mCustomerInfo.CommonInfo.CreateUserId = ToInt32(sdr["CREATE_USERID"]);
mCustomerInfo.CommonInfo.UpdateDate = ToDateTime(sdr["UPDATE_DATE"]);
mCustomerInfo.CommonInfo.UpdateUserId = ToInt32(sdr["UPDATE_USERID"]);
listCustomer.Add(mCustomerInfo);
}
}
return listCustomer;
}
public List<CustomerStayModel> GetMainRoomGroup()
{
string sql = @"SELECT DISTINCT A.MAIN_ROOM_ID,B.NAME,D.ROOM_NO,B.CUSTOMER_ID
FROM CUSTOMER_STAY_INFO A,CUSTOMER_INFO B,CUSTOMER_STAY_HIS C,BAS_ROOM_INFO D
WHERE A.STAY_ID=C.STAY_ID AND C.CUSTOMER_ID=B.CUSTOMER_ID
AND A.MAIN_ROOM_ID=D.ROOM_ID
AND A.STATUS='I'
AND C.HIS_STATUS='E'
AND C.STAY_TYPE='M'
AND MAIN_ROOM_ID>0";
sdr = ExecuteReader(sql);
List<CustomerStayModel> listTeamRoom = new List<CustomerStayModel>();
using (sdr)
{
while (sdr.Read())
{
CustomerStayModel mCustomerStay = new CustomerStayModel();
mCustomerStay.MainRoomId = ToInt32(sdr["MAIN_ROOM_ID"]);
mCustomerStay.RoomInfo.RoomNo = ToString(sdr["ROOM_NO"]);
mCustomerStay.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerId = ToInt32(sdr["CUSTOMER_ID"]);
mc.Name = ToString(sdr["NAME"]);
mCustomerStay.CustomerList.Add(mc);
listTeamRoom.Add(mCustomerStay);
}
}
return listTeamRoom;
}
public CustomerStayModel GetCustomerStayInfo(CustomerStayModel mCustomerStay, ObjectControls oCtrl)
{
string sql = @"SELECT A.STAY_ID,A.STAY_NO, A.ROOM_ID, A.MAIN_ROOM_ID, A.ROOM_STAY_TYPE,
A.START_DATE, A.END_DATE,A.HOURS, A.DEPOSIT, A.ROOM_RATES AS CURRENT_RATE,A.PAID_MONEY, A.PAY_TYPE,A.TOTAL_MONEY, A.STATUS,
A.NOTICE, A.CREATE_DATE, A.CREATE_USERID,F.USER_NAME AS CREATE_USER_NAME,G.USER_NAME AS UPDATE_USER_NAME, A.UPDATE_DATE,
A.UPDATE_USERID, B.CUSTOMER_ID, B.ID_CARD, B.NAME, B.SEX, B.NATION,
B.BIRTHDAY, B.ADDRESS, B.COMPANY, B.PHONE, B.PICTURE, B.TYPE, E.STAY_TYPE,E.HIS_STATUS,E.HIS_ID,
E.START_TIME,E.END_TIME,
C.ROOM_NO, C.ROOM_TYPE, C.ROOM_RATES AS DEFAULT_RATE, C.ROOM_NOTICE,
C.ROOM_PHONE, C.STATUS AS ROOM_STATUS, C.FLOOR_ID,D.FLOOR_NAME
FROM CUSTOMER_STAY_INFO AS A INNER JOIN
CUSTOMER_STAY_HIS E ON A.STAY_ID =E.STAY_ID";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayType) && oCtrl.Append(ref sql, " AND E.STAY_TYPE=" + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.StayType)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByHisStatus) && oCtrl.Append(ref sql, " AND E.HIS_STATUS=" + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.HisStatus)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByHisStatusNotEqual) && oCtrl.Append(ref sql, " AND E.HIS_STATUS !=" + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.HisStatus)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByHisStartTime) && oCtrl.Append(ref sql, " AND E.START_TIME BETWEEN " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.StartDate) + " AND " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByHisEndTime) && oCtrl.Append(ref sql, " AND E.END_TIME BETWEEN " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.StartDate) + " AND " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByHisStartOrEndTime) && oCtrl.Append(ref sql, " AND (E.START_TIME BETWEEN " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.StartDate)
+ " AND " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.EndDate)
+ " OR E.END_TIME BETWEEN " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.StartDate)
+ " AND " + SQL(mCustomerStay.CustomerList[0].CustomerStayHisInfo.CommonInfo.EndDate) + ")"));
sql += @" INNER JOIN
CUSTOMER_INFO AS B ON E.CUSTOMER_ID = B.CUSTOMER_ID ";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByName) && oCtrl.Append(ref sql, " AND B.NAME=" + SQL(mCustomerStay.CustomerList[0].Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByPhone) && oCtrl.Append(ref sql, " AND B.PHONE=" + SQL(mCustomerStay.CustomerList[0].Phone)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByCustomerType) && oCtrl.Append(ref sql, " AND B.TYPE=" + SQL(mCustomerStay.CustomerList[0].Type)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByCustomerId) && oCtrl.Append(ref sql, " AND B.CUSTOMER_ID=" + mCustomerStay.CustomerList[0].CustomerId));
sql+=@" INNER JOIN
BAS_ROOM_INFO AS C ON A.ROOM_ID = C.ROOM_ID INNER JOIN
SYS_USER_INFO AS F ON A.CREATE_USERID = F.USER_ID INNER JOIN
SYS_USER_INFO AS G ON A.UPDATE_USERID = G.USER_ID INNER JOIN
BAS_FLOOR_INFO AS D ON C.FLOOR_ID = D.FLOOR_ID";
sql += " WHERE 1=1";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomId) && oCtrl.Append(ref sql, " AND A.ROOM_ID=" + mCustomerStay.RoomId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByFloorId) && oCtrl.Append(ref sql, " AND D.FLOOR_ID=" + mCustomerStay.RoomInfo.FloorInfo.FloorId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomNo) && oCtrl.Append(ref sql, " AND C.ROOM_NO=" + SQL(mCustomerStay.RoomInfo.RoomNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStartDate) && oCtrl.Append(ref sql, " AND A.START_DATE=" + SQL(mCustomerStay.CommonInfo.StartDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByEndDate)&& oCtrl.Append(ref sql, " AND A.END_DATE=" + SQL(mCustomerStay.CommonInfo.EndDate)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayStatus) && oCtrl.Append(ref sql, " AND A.STATUS=" + SQL(mCustomerStay.Status)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByRoomStayType) && oCtrl.Append(ref sql, " AND A.ROOM_STAY_TYPE=" + mCustomerStay.RoomStayType));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayNo) && oCtrl.Append(ref sql, " AND A.STAY_NO=" + mCustomerStay.StayNo));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByStayId) && oCtrl.Append(ref sql, " AND A.STAY_ID=" + mCustomerStay.StayId));
sdr = ExecuteReader(sql);
using (sdr)
{
if (!sdr.HasRows)
{
return null;
}
CustomerStayModel mCustomerStayInfo = new CustomerStayModel();
mCustomerStayInfo.CustomerList = new List<CustomerModel>();
while(sdr.Read())
{
mCustomerStayInfo.CommonInfo = new CommonModel();
mCustomerStayInfo.StayNo = ToString(sdr["STAY_NO"]);
mCustomerStayInfo.StayId = ToInt32(sdr["STAY_ID"]);
mCustomerStayInfo.RoomId = ToInt32(sdr["ROOM_ID"]);
mCustomerStayInfo.MainRoomId = ToInt32(sdr["MAIN_ROOM_ID"]);
mCustomerStayInfo.CommonInfo.StartDate = ToDateTime(sdr["START_DATE"]);
mCustomerStayInfo.CommonInfo.EndDate = ToDateTime(sdr["END_DATE"]);
mCustomerStayInfo.Deposit = ToDouble(sdr["DEPOSIT"]);
mCustomerStayInfo.RoomRate = ToInt32(sdr["CURRENT_RATE"]);
mCustomerStayInfo.Total = ToDouble(sdr["TOTAL_MONEY"]);
mCustomerStayInfo.PayType = ToChar(sdr["PAY_TYPE"]);
mCustomerStayInfo.Status = ToChar(sdr["STATUS"]);
mCustomerStayInfo.Notice = ToString(sdr["NOTICE"]);
mCustomerStayInfo.Hours = ToInt32(sdr["HOURS"]);
mCustomerStayInfo.RoomStayType = ToChar(sdr["ROOM_STAY_TYPE"]);
mCustomerStayInfo.PaidMoney = ToDouble(sdr["PAID_MONEY"]);
mCustomerStayInfo.CommonInfo.CreateDate = ToDateTime(sdr["CREATE_DATE"]);
mCustomerStayInfo.CommonInfo.CreateUserId = ToInt32(sdr["CREATE_USERID"]);
mCustomerStayInfo.CommonInfo.CreateUserName = ToString(sdr["CREATE_USER_NAME"]);
mCustomerStayInfo.CommonInfo.UpdateDate = ToDateTime(sdr["UPDATE_DATE"]);
mCustomerStayInfo.CommonInfo.UpdateUserId = ToInt32(sdr["UPDATE_USERID"]);
mCustomerStayInfo.CommonInfo.UpateUserName = ToString(sdr["UPDATE_USER_NAME"]);
CustomerModel mCustomerInfo = new CustomerModel();
mCustomerInfo.CustomerId = ToInt32(sdr["CUSTOMER_ID"]);
mCustomerInfo.IdCardNo = ToString(sdr["ID_CARD"]);
mCustomerInfo.Name = ToString(sdr["NAME"]);
mCustomerInfo.Nation = ToString(sdr["NATION"]);
mCustomerInfo.Phone = ToString(sdr["PHONE"]);
mCustomerInfo.Picture = ToString(sdr["PICTURE"]);
mCustomerInfo.Type = ToChar(sdr["TYPE"]);
mCustomerInfo.Sex = ToString(sdr["SEX"]);
mCustomerInfo.Birthday = ToDateTime(sdr["BIRTHDAY"]);
mCustomerInfo.Address = ToString(sdr["ADDRESS"]);
mCustomerInfo.Company = ToString(sdr["COMPANY"]);
mCustomerInfo.CustomerStayHisInfo = new CustomerStayHisModel();
mCustomerInfo.CustomerStayHisInfo.HisId = ToInt32(sdr["HIS_ID"]);
mCustomerInfo.CustomerStayHisInfo.StayId = ToInt32(sdr["STAY_ID"]);
mCustomerInfo.CustomerStayHisInfo.CustomerId = ToInt32(sdr["CUSTOMER_ID"]);
mCustomerInfo.CustomerStayHisInfo.StayType = ToChar(sdr["STAY_TYPE"]);
mCustomerInfo.CustomerStayHisInfo.HisStatus = ToChar(sdr["HIS_STATUS"]);
mCustomerInfo.CustomerStayHisInfo.CommonInfo.StartDate = ToDateTime(sdr["START_TIME"]);
mCustomerInfo.CustomerStayHisInfo.CommonInfo.EndDate = ToDateTime(sdr["END_TIME"]);
mCustomerInfo.CommonInfo = new CommonModel();
mCustomerStayInfo.CustomerList.Add(mCustomerInfo);
mCustomerStayInfo.RoomInfo = new BasRoomModel();
mCustomerStayInfo.RoomInfo.RoomId = ToInt32(sdr["ROOM_ID"]);
mCustomerStayInfo.RoomInfo.RoomNo = ToString(sdr["ROOM_NO"]);
mCustomerStayInfo.RoomInfo.RoomType = ToChar(sdr["ROOM_TYPE"]);
mCustomerStayInfo.RoomInfo.RoomRate = ToDouble(sdr["DEFAULT_RATE"]);
mCustomerStayInfo.RoomInfo.RoomPhone = ToString(sdr["ROOM_PHONE"]);
mCustomerStayInfo.RoomInfo.Status = ToChar(sdr["ROOM_STATUS"]);
mCustomerStayInfo.RoomInfo.RoomNotice = ToString(sdr["ROOM_NOTICE"]);
mCustomerStayInfo.RoomInfo.FloorInfo = new BasFloorModel();
mCustomerStayInfo.RoomInfo.FloorInfo.FloorId = ToInt32(sdr["FLOOR_ID"]);
mCustomerStayInfo.RoomInfo.FloorInfo.FloorName = ToString(sdr["FLOOR_NAME"]);
}
return mCustomerStayInfo;
}
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="mCustomerNew">新的信息</param>
/// <param name="mCustomerOld">以前旧信息</param>
public void UpdateExsitCustomerInfo(CustomerModel mCustomerNew,CustomerModel mCustomerOld)
{
ObjectControls oCtrl = new ObjectControls();
if (!string.IsNullOrEmpty(mCustomerNew.Name))
{
mCustomerOld.Name = mCustomerNew.Name;
oCtrl.Add(MCtrl.SetName);
}
if (!string.IsNullOrEmpty(mCustomerNew.IdCardNo))
{
mCustomerOld.IdCardNo = mCustomerNew.IdCardNo;
oCtrl.Add(MCtrl.SetIdCard);
}
if (!string.IsNullOrEmpty(mCustomerNew.Address))
{
mCustomerOld.Address = mCustomerNew.Address;
oCtrl.Add(MCtrl.SetAddress);
}
if (mCustomerNew.Birthday != DateTime.MinValue)
{
mCustomerOld.Birthday = mCustomerNew.Birthday;
oCtrl.Add(MCtrl.SetBirthday);
}
if (!string.IsNullOrEmpty(mCustomerNew.Company))
{
mCustomerOld.Company = mCustomerNew.Company;
oCtrl.Add(MCtrl.SetCompanyName);
}
if (!string.IsNullOrEmpty(mCustomerNew.Nation))
{
mCustomerOld.Nation = mCustomerNew.Nation;
oCtrl.Add(MCtrl.SetNation);
}
if (!string.IsNullOrEmpty(mCustomerNew.Phone))
{
mCustomerOld.Phone = mCustomerNew.Phone;
oCtrl.Add(MCtrl.SetPhone);
}
if (!string.IsNullOrEmpty(mCustomerNew.Picture))
{
mCustomerOld.Picture = mCustomerNew.Picture;
oCtrl.Add(MCtrl.SetPicture);
}
if (!string.IsNullOrEmpty(mCustomerNew.Sex))
{
mCustomerOld.Sex = mCustomerNew.Sex;
oCtrl.Add(MCtrl.SetSex);
}
if (!mCustomerNew.Type.Equals(mCustomerOld.Type))
{
mCustomerOld.Type = mCustomerNew.Type;
oCtrl.Add(MCtrl.SetCustomerType);
}
mCustomerNew.CustomerId = mCustomerOld.CustomerId;
mCustomerOld.CommonInfo.UpdateUserId = mCustomerNew.CommonInfo.UpdateUserId;
bCustomer.UpdateCustomer(mCustomerOld, oCtrl);
}
/// <summary>
/// 获取在宾客信息清单
/// </summary>
/// <param name="listRoomInfo"></param>
/// <param name="cStayStatus">该入住单是否在住</param>
/// <param name="sStayType">宾客类型,主客Or从客</param>
/// <param name="HisStayStatus">宾客是否退房</param>
/// <param name="IsCountConsume">是否统计消费</param>
/// <returns></returns>
public List<CustomerStayModel> GetStayInRoomInfo(List<BasRoomModel> listRoomInfo, char cStayStatus,string sStayType, bool IsCountConsume)
{
List<CustomerStayModel> listCustomerStayInfo = new List<CustomerStayModel>();
CustomerStayModel mStayInfo = new CustomerStayModel();
ObjectControls oCtrl = new ObjectControls();
foreach (BasRoomModel mRoom in listRoomInfo)
{
mStayInfo.RoomInfo.RoomIdGroup += Cmn.MakeGroup(mRoom.RoomId.ToString());
}
mStayInfo.RoomInfo.RoomIdGroup = Cmn.RemoveLastDou(mStayInfo.RoomInfo.RoomIdGroup);
mStayInfo.Status = cStayStatus;
mStayInfo.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
if (!string.IsNullOrEmpty(sStayType))
{
mc.CustomerStayHisInfo.StayType = Cmn.ToChar(sStayType);
oCtrl.Add(MCtrl.ByStayType);
}
mc.CustomerStayHisInfo.HisStatus = cStayStatus == 'I' ? 'E' : 'O';
mStayInfo.CustomerList.Add(mc);
if (Cmn.CheckEOF(listRoomInfo))
{
oCtrl.Add(MCtrl.ByRoomIdGroup);
}
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
listCustomerStayInfo = bCustomerStay.GetCustomerStayList(mStayInfo, oCtrl);
if (Cmn.CheckEOF(listCustomerStayInfo) && IsCountConsume)
{
foreach (CustomerStayModel mCustomerStay in listCustomerStayInfo)
{
List<ConsumeDetailModel> listGetConsumeDetail = new List<ConsumeDetailModel>();
ConsumeDetailModel mConsume = new ConsumeDetailModel();
mConsume.StayId = mCustomerStay.StayId;
oCtrl.Reset();
oCtrl.Add(MCtrl.ByStayId);
listGetConsumeDetail = bConsume.GetConsumeList(mConsume, oCtrl);
if (Cmn.CheckEOF(listGetConsumeDetail))
{
mCustomerStay.ConSumeDetailList = listGetConsumeDetail;
}
}
}
return listCustomerStayInfo;
}
/// <summary>
/// 获取宾客入住信息,消费明细
/// </summary>
/// <param name="mRoom">房间信息</param>
/// <param name="cStayStatus">入住状态 I In / O off</param>
/// <param name="sStayType">入住类型,主客M从客S,如包含主从则为""</param>
/// <returns></returns>
public CustomerStayModel GetStayInRoomInfo(BasRoomModel mRoom, char cStayStatus, string sStayType)
{
CustomerStayModel mStayInfo = new CustomerStayModel();
ObjectControls oCtrl = new ObjectControls();
mStayInfo.RoomId = mRoom.RoomId;
mStayInfo.Status = cStayStatus;
mStayInfo.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
if (!string.IsNullOrEmpty(sStayType))
{
mc.CustomerStayHisInfo.StayType = Cmn.ToChar(sStayType);
oCtrl.Add(MCtrl.ByStayType);
}
mc.CustomerStayHisInfo.HisStatus = cStayStatus == 'I' ? 'E' : 'O';
mStayInfo.CustomerList.Add(mc);
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
CustomerStayModel mCustomerStay = bCustomerStay.GetCustomerStayInfo(mStayInfo, oCtrl);
if (mCustomerStay != null)
{
List<ConsumeDetailModel> listGetConsumeDetail = new List<ConsumeDetailModel>();
ConsumeDetailModel mConsume = new ConsumeDetailModel();
mConsume.StayId = mCustomerStay.StayId;
oCtrl.Reset();
oCtrl.Add(MCtrl.ByStayId);
listGetConsumeDetail = bConsume.GetConsumeList(mConsume, oCtrl);
if (Cmn.CheckEOF(listGetConsumeDetail))
{
mCustomerStay.ConSumeDetailList = listGetConsumeDetail;
}
}
return mCustomerStay;
}
private void pbtnSearch_Click(object sender, EventArgs e)
{
try
{
CustomerStayModel mCustomerStay = new CustomerStayModel();
oCtrl.Reset();
mCustomerStay.ConSumeDetailList = new List<ConsumeDetailModel>();
CustomerModel mCustomer = new CustomerModel();
mCustomer.Name = txtCondition.Text;
mCustomerStay.RoomInfo = new BasRoomModel();
mCustomerStay.RoomInfo.RoomNo = txtCondition.Text;
if (!string.IsNullOrEmpty(txtCondition.Text))
{
oCtrl.Add(MCtrl.ByNPR);
}
if (cboStayStaus.SelectedIndex != 0)//如果选择在住或者离店
{
//mCustomerStay.Status = cmn.ToChar(cboStayStaus.SelectedValue);
mCustomer.CustomerStayHisInfo.HisStatus = cmn.ToChar(cboStayStaus.SelectedValue) == 'I' ? 'E' : 'O';
oCtrl.Add(MCtrl.ByHisStatus);
//oCtrl.Add(MCtrl.ByStayStatus);
}
else//如果选择所有,则查询his中状态不为D的宾客.E为在住,O为离店.D为删除的用户.没有意义.
{
//mCustomerStay.Status = cmn.ToChar(cboStayStaus.SelectedValue);
mCustomer.CustomerStayHisInfo.HisStatus = 'D';
oCtrl.Add(MCtrl.ByHisStatusNotEqual);
}
if (chkByDateTime.Checked)
{
mCustomer.CustomerStayHisInfo.CommonInfo.StartDate = GetDateTimePickValue(dtpStart, cboHourS);
mCustomer.CustomerStayHisInfo.CommonInfo.EndDate = GetDateTimePickValue(dtpEnd, cboHourE);
if (mCustomer.CustomerStayHisInfo.HisStatus == 'E')
{
oCtrl.Add(MCtrl.ByHisStartTime);
}
else if (mCustomer.CustomerStayHisInfo.HisStatus == 'O')
{
oCtrl.Add(MCtrl.ByHisEndTime);
}
else
{
oCtrl.Add(MCtrl.ByHisStartOrEndTime);
}
}
mCustomerStay.CustomerList.Add(mCustomer);
List<CustomerStayModel> listCustomerStay = bCustomerStay.GetCustomerStayList(mCustomerStay, oCtrl);
BindDgv(listCustomerStay);
}
catch (Exception err)
{
tslblMsg.Text = err.Message;
}
}
private void LoadInfo()
{
BindCodeInfo(cboPayType, "CUSTOMER_STAY_INFO", "PAY_TYPE");
BindCodeInfo(cboCustomerType, "CUSTOMER_STAY_HIS", "STAY_TYPE");
cboSex.SelectedIndex = 0;
lblRoomInfo.Text = mRoomInfo.RoomNo;
lblRoomType.Text = mRoomInfo.RoomTypeDesc;
lblRoomRate.Text = mRoomInfo.RoomRate + "元";
if (!mRoomInfo.Status.Equals('E'))
{
CustomerStayModel mCustomerStayInfo = new CustomerStayModel();
mCustomerStayInfo.RoomId = mRoomInfo.RoomId;
mCustomerStayInfo.Status = 'I';
mCustomerStayInfo.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
mc.CustomerStayHisInfo.HisStatus = 'E';
mCustomerStayInfo.CustomerList.Add(mc);
oCtrl = new ObjectControls();
oCtrl.Add(MCtrl.ByRoomId);
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
CustomerStayModel mCustomerStay =bCustomer.GetCustomerStayInfo(mCustomerStayInfo, oCtrl);
if (mCustomerStay != null)
{
this.Text = "修改登记";
listCustomerStay.Add(mCustomerStay);
txtDay.Text = (mCustomerStay.Hours / 24).ToString(); //hml.GetCustomerStayDays(mCustomerStay.CommonInfo.StartDate, mCustomerStay.CommonInfo.EndDate, listSysParameter).ToString("0.0"); //listSysParameter.Where(c => c.ParamNo == "DEFAULT_STAY_DAYS").Select(c => c.Value1).First();
txtCurrentDeposit.Text = mCustomerStay.Deposit.ToString();
txtCurrentRate.Text = mCustomerStay.RoomRate.ToString();
txtDiskonRate.Enabled = false;
//txtDiskonRate.Text = (mCustomerStay.RoomRate / mCustomerStay.RoomInfo.RoomRate).ToString("0.00");
txtCustomerNumber.Text = mCustomerStay.CustomerList.Count.ToString();
txtNotice.Text = mCustomerStay.Notice;
chkHourRoom.Checked = mCustomerStay.RoomStayType == 'H' ? true : false;
cboPayType.SelectedIndex = GetComboxIndexByKey(cboPayType, mCustomerStay.PayType);
if (cmn.FileExsit(cmn.GetImgFilePath(mCustomerStay.CustomerList[0].Picture)))
{
pbxUserImg.Image = Image.FromFile(cmn.GetImgFilePath(mCustomerStay.CustomerList[0].Picture));
}
listCustomer = mCustomerStay.CustomerList;
BindCustomer(listCustomer);
return;
}
}
this.Text = "散客开单";
List<OrderInfoModel> listOrder = hml.GetRoomOrder(mRoomInfo);
if (cmn.CheckEOF(listOrder))
{
FormSelectOrder frmSelectOrder = new FormSelectOrder(listOrder);
if (frmSelectOrder.ShowDialog() == DialogResult.OK)
{
mOrderInfo = frmSelectOrder.mOrderInfo;
if (mOrderInfo != null)
{
txtCustomerName.Text = mOrderInfo.Name;
txtPhone.Text = mOrderInfo.Phone;
txtIDCard.Text = mOrderInfo.IdCardNo;
txtCurrentRate.Text = mOrderInfo.OrderRoomRate.ToString();
txtNotice.Text = mOrderInfo.Notice;
btnAddCustomer_Click(null, new EventArgs());
}
}
}
txtDay.Text = hml.ToParameter(listSysParameter, "DEFAULT_STAY_DAYS").Value1; //listSysParameter.Where(c => c.ParamNo == "DEFAULT_STAY_DAYS").Select(c => c.Value1).First();
txtCurrentDeposit.Text = hml.ToParameter(listSysParameter, "DEFAULT_DEPOSIT").Value1;
txtCurrentRate.Text = txtCurrentRate.Text.Equals("") ? mRoomInfo.RoomRate.ToString() : txtCurrentRate.Text;
txtDiskonRate.Text = hml.ToParameter(listSysParameter, "DEFAULT_DISKON").Value1;
txtCustomerNumber.Text = hml.ToParameter(listSysParameter, "DEFAULT_CUSTOMER_NUMBER").Value1;
}
private void dgvCustomerInfo_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e != null)
{
cboCustomerType.Text = dgvCustomerInfo["Type", e.RowIndex].Value.ToString();
cboSex.SelectedItem = dgvCustomerInfo["Sex", e.RowIndex].Value;
txtCustomerName.Text = dgvCustomerInfo["CustomerName", e.RowIndex].Value.ToString();
txtIDCard.Text = dgvCustomerInfo["IDCard", e.RowIndex].Value.ToString();
txtCompany.Text = dgvCustomerInfo["Company", e.RowIndex].Value.ToString();
txtAddress.Text = dgvCustomerInfo["Address", e.RowIndex].Value.ToString();
txtPhone.Text = dgvCustomerInfo["Phone", e.RowIndex].Value.ToString();
mCustomerInfo = new CustomerModel();
mCustomerInfo = listCustomer.Where(c => c.CustomerId == Convert.ToInt32(dgvCustomerInfo["CustomerId", e.RowIndex].Value)).FirstOrDefault();
if (cmn.FileExsit(cmn.GetImgFilePath(mCustomerInfo.Picture)))
{
pbxUserImg.Image = Image.FromFile(cmn.GetImgFilePath(mCustomerInfo.Picture));
}
//dgvCustomerInfo.Rows.RemoveAt(e.RowIndex);
//listCustomer.Remove(mCustomerInfo);
//BindCustomer(listCustomer);
}
}
private void btnReadIDCard_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = string.Empty;
pbxUserImg.Image = null;
IdentityCardProviderImp IdCard = new IdentityCardProviderImp();
IdentityCardInfo mCardInfo = IdCard.ReadIdCard(1, true);
pbxUserImg.Image = mCardInfo.IdImage;
txtCustomerName.Text = mCardInfo.Name;
txtAddress.Text = mCardInfo.Address;
cboSex.SelectedItem = mCardInfo.SexName;
txtIDCard.Text = mCardInfo.CardId;
mCustomerInfo = new CustomerModel();
mCustomerInfo.Nation = mCardInfo.NationName;
mCustomerInfo.Birthday = mCardInfo.Birthday;
//btnAddCustomer_Click(sender, new EventArgs());
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
public int UpdateCustomer(CustomerModel mCustomer, ObjectControls oCtrl)
{
return dCustomer.UpdateCustomer(mCustomer, oCtrl);
}
public int InsertCustomer(CustomerModel mCustomer)
{
return dCustomer.InsertCustomer(mCustomer);
}
/// <summary>
/// 获取宾客信息
/// </summary>
/// <param name="mCustomer"></param>
/// <param name="oCtrl"></param>
/// <returns></returns>
public List<CustomerModel> GetCustomerInfo(CustomerModel mCustomer, ObjectControls oCtrl)
{
return dCustomer.GetCustomerInfo(mCustomer, oCtrl);
}
public int DeleteCustomer(CustomerModel mCustomer)
{
return dCustomer.DeleteCustomer(mCustomer);
}
public int DeleteCustomer(CustomerModel mCustomer)
{
string sql = "DELETE FROM CUSTOMER_INFO WHERE CUSTOMER_ID=" + mCustomer.CustomerId;
return ExcuteNonQuery(sql);
}
private void btnAddCustomer_Click(object sender, EventArgs e)
{
try
{
lblMsg.Text = "";
if (mCustomerInfo == null)
{
mCustomerInfo = new CustomerModel();
}
mCustomerInfo.Name = cmn.CheckNullOrEmpty(txtCustomerName, "宾客姓名");
mCustomerInfo.Address = txtAddress.Text;
mCustomerInfo.Company = txtCompany.Text;
mCustomerInfo.IdCardNo = cmn.CheckNullOrEmpty(txtIDCard, "证件号码");
mCustomerInfo.Phone = txtPhone.Text;
mCustomerInfo.Sex = cboSex.SelectedItem.ToString();
mCustomerInfo.CustomerStayHisInfo=new CustomerStayHisModel ();
mCustomerInfo.CustomerStayHisInfo.HisStatus='E';
if (pbxUserImg.Image != null)
{
mCustomerInfo.Picture = cmn.SaveImage(pbxUserImg.Image, cmn.DateBaseDate.ToString("yyyyMMddHHmmss"), "CARD_IMG");
}
//第一个加入的宾客默认为主客.
if (listCustomer.Count == 0)
{
mCustomerInfo.CustomerStayHisInfo.StayType = 'M';
}
else
{
mCustomerInfo.CustomerStayHisInfo.StayType = cmn.ToChar(cboCustomerType.SelectedValue);
}
mCustomerInfo.CommonInfo = new CommonModel();
mCustomerInfo.CommonInfo.CreateUserId = UserInfo.UserId;
mCustomerInfo.CommonInfo.UpdateUserId = UserInfo.UserId;
var query=listCustomer.Where(c => c.IdCardNo == mCustomerInfo.IdCardNo && c.Name == mCustomerInfo.Name);
if (query.Count() > 0)
{
listCustomer.Remove(query.First());
}
query = listCustomer.Where(c => c.CustomerStayHisInfo.StayType == mCustomerInfo.CustomerStayHisInfo.StayType && c.CustomerStayHisInfo.StayType=='M');
if (query.Count() > 0)
{
if (cmn.Confirm(string.Format("已指定主客为{0}确实要将主客变更为{1}?", query.First().Name, mCustomerInfo.Name)))
{
query.First().CustomerStayHisInfo.StayType = 'S';
}
else { return; }
}
if (!listCustomer.Contains(mCustomerInfo))
{
listCustomer.Add(mCustomerInfo);
}
BindCustomer(listCustomer);
if (mCustomerInfo.CustomerStayHisInfo.StayType.Equals('M'))
{
cboCustomerType.SelectedValue = "S";
}
mCustomerInfo = null;
ClearUI();
}
catch (Exception err)
{
lblMsg.Text = err.Message;
}
}
/// <summary>
/// By用户证件以及姓名获取用户信息
/// </summary>
/// <param name="mCustomer"></param>
/// <returns></returns>
public List<CustomerModel> GetExistCustomerInfo(CustomerModel mCustomer)
{
ObjectControls oCtrl = new ObjectControls();
if (mCustomer.CustomerId > 0)
{
oCtrl.Add(MCtrl.ByCustomerId);
}
else
{
oCtrl.Add(MCtrl.ByIdCard);
oCtrl.Add(MCtrl.ByName);
}
return bCustomer.GetCustomerInfo(mCustomer, oCtrl);
}
public int UpdateCustomer(CustomerModel mCustomer, ObjectControls oCtrl)
{
string sql = "UPDATE CUSTOMER_INFO SET CREATE_DATE = CREATE_DATE";
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetName) && oCtrl.Append(ref sql, ",NAME=" + SQL(mCustomer.Name)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetNation) && oCtrl.Append(ref sql, ",NATION=" + SQL(mCustomer.Nation)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetIdCard) && oCtrl.Append(ref sql, ",ID_CARD=" + SQL(mCustomer.IdCardNo)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetSex) && oCtrl.Append(ref sql, ",SEX=" + SQL(mCustomer.Sex)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetBirthday) && oCtrl.Append(ref sql, ",BIRTHDAY=" + SQL(mCustomer.Birthday)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetCompanyName) && oCtrl.Append( ref sql, ",COMPANY=" + SQL(mCustomer.Company)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetAddress) && oCtrl.Append(ref sql, ",ADDRESS=" + SQL(mCustomer.Address)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetCustomerType) && oCtrl.Append( ref sql, ",ADDRESS=" + SQL(mCustomer.Type)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetPicture) && oCtrl.Append(ref sql, ",PICTURE=" + SQL(mCustomer.Picture)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetPhone) && oCtrl.Append(ref sql, ",PHONE=" + SQL(mCustomer.Phone)));
sql += ",UPDATE_DATE=" + SQL(GetDBTime);
sql += ",UPDATE_USERID=" + SQL(mCustomer.CommonInfo.UpdateUserId);
sql += " WHERE CUSTOMER_ID=" + mCustomer.CustomerId;
return ExcuteNonQuery(sql);
}
private void pbtnSearch_Click(object sender, EventArgs e)
{
try
{
CustomerStayModel mCustomerStay = new CustomerStayModel();
mCustomerStay.CommonInfo.StartDate = GetDateTimePickValue(dtpStart, cboHourS);
mCustomerStay.CommonInfo.EndDate = GetDateTimePickValue(dtpEnd, cboHourE);
mCustomerStay.Status = 'O';
ObjectControls oCtrl = new ObjectControls();
mCustomerStay.CustomerList = new List<CustomerModel>();
CustomerModel mc = new CustomerModel();
mc.CustomerStayHisInfo = new CustomerStayHisModel();
//mc.CustomerStayHisInfo.StayType = 'M';
mc.CustomerStayHisInfo.HisStatus = 'O';//取离店宾客入住历史记录.
mCustomerStay.CustomerList.Add(mc);
oCtrl.Add(MCtrl.ByStayStatus);
oCtrl.Add(MCtrl.ByHisStatus);
oCtrl.Add(MCtrl.ByUpdateDate);
listCustomerStay = bCustomerStay.GetCustomerStayList(mCustomerStay, oCtrl);
BindDgv(listCustomerStay);
}
catch (Exception err)
{
cmn.Show(err.Message);
}
}
