public int updateModel(BookTicketInfoModel model)
{
string sql = @"UPDATE dbo.BookTicketInfo
SET TrainNumber = @TrainNumber
,StartStation = @StartStation
,EndStation = @EndStation
,BookDate = @BookDate
,Phone = @Phone
,Remark = @Remark
WHERE Id = @Id";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@TrainNumber", SqlDbType.VarChar),
new SqlParameter("@StartStation", SqlDbType.NVarChar),
new SqlParameter("@EndStation", SqlDbType.NVarChar),
new SqlParameter("@BookDate", SqlDbType.DateTime),
new SqlParameter("@Phone", SqlDbType.NVarChar),
new SqlParameter("@Remark", SqlDbType.NVarChar),
new SqlParameter("@Id", SqlDbType.Int)
};
pars[0].Value = model.TrainNumber;
pars[1].Value = model.StartStation;
pars[2].Value = model.EndStation;
pars[3].Value = model.BookDate;
pars[4].Value = model.Phone;
pars[5].Value = model.Remark;
pars[6].Value = model.Id;
// continuing
int result = MSSQL.noQuery(sql, pars);
return(result);
}
public bool bookTicket(BookTicketInfoModel model, int lastOperatorId)
{
int count = dal.bookTicket(model, lastOperatorId);
bool isSuccess = true;
if (count < 2)
{
isSuccess = false;
}
return(isSuccess);
}
public int bookTicket(BookTicketInfoModel model, int lastOperatorId)
{
string procName = "proc_bookTicket";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@TrainNumber", SqlDbType.NVarChar),
new SqlParameter("@StartStation", SqlDbType.NVarChar),
new SqlParameter("@EndStation", SqlDbType.NVarChar),
new SqlParameter("@BookDate", SqlDbType.DateTime),
new SqlParameter("@StudentId", SqlDbType.Int),
new SqlParameter("@Phone", SqlDbType.NVarChar),
new SqlParameter("@Remark", SqlDbType.NText),
new SqlParameter("@LastOperatorId", SqlDbType.Int)
};
pars[0].Value = model.TrainNumber;
pars[1].Value = model.StartStation;
pars[2].Value = model.EndStation;
pars[3].Value = model.BookDate;
pars[4].Value = model.StudentId;
pars[5].Value = model.Phone;
pars[6].Value = model.Remark;
pars[7].Value = lastOperatorId;
return(MSSQL.ExecProcNonQuery(procName, pars));
}
public int editModel(BookTicketInfoModel model)
{
return(dal.updateModel(model));
}
