/// <summary> /// 增加一条数据OutRoom /// </summary> public bool AddOutRoom(TF.RunSafty.Model.Model_Plan_OutRoom model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_OutRoom("); strSql.Append("strOutRoomGUID,strTrainPlanGUID,strTrainmanGUID,dtOutRoomTime,nOutRoomVerifyID,strDutyUserGUID,strTrainmanNumber,dtCreateTime,strInRoomGUID,strSiteGUID,dtArriveTime,strWaitPlanGUID,ePlanType,strRoomNumber,nBedNumber)"); strSql.Append(" values ("); strSql.Append("@strOutRoomGUID,@strTrainPlanGUID,@strTrainmanGUID,@dtOutRoomTime,@nOutRoomVerifyID,@strDutyUserGUID,@strTrainmanNumber,@dtCreateTime,@strInRoomGUID,@strSiteGUID,@dtArriveTime,@strWaitPlanGUID,@ePlanType,@strRoomNumber,@nBedNumber)"); SqlParameter[] parameters = { new SqlParameter("@strOutRoomGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtOutRoomTime", SqlDbType.DateTime), new SqlParameter("@nOutRoomVerifyID", SqlDbType.Int, 4), new SqlParameter("@strDutyUserGUID", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanNumber", SqlDbType.VarChar, 50), new SqlParameter("@dtCreateTime", SqlDbType.DateTime), new SqlParameter("@strInRoomGUID", SqlDbType.VarChar, 50), new SqlParameter("@strSiteGUID", SqlDbType.VarChar, 50), new SqlParameter("@dtArriveTime", SqlDbType.DateTime), new SqlParameter("@strWaitPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@ePlanType", SqlDbType.Int, 4), new SqlParameter("@strRoomNumber", SqlDbType.VarChar, 50), new SqlParameter("@nBedNumber", SqlDbType.Int, 4) }; parameters[0].Value = model.strOutRoomGUID; parameters[1].Value = model.strTrainPlanGUID; parameters[2].Value = model.strTrainmanGUID; parameters[3].Value = model.dtOutRoomTime; parameters[4].Value = model.nOutRoomVerifyID; parameters[5].Value = model.strDutyUserGUID; parameters[6].Value = model.strTrainmanNumber; parameters[7].Value = model.dtCreateTime; parameters[8].Value = model.strInRoomGUID; parameters[9].Value = model.strSiteGUID; parameters[10].Value = model.dtArriveTime; parameters[11].Value = model.strWaitPlanGUID; parameters[12].Value = model.ePlanType; parameters[13].Value = model.strRoomNumber; parameters[14].Value = model.nBedNumber; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { string strSql3 = "update TAB_Org_Trainman set dtLastOutRoomTime='" + model.dtOutRoomTime + "' where strTrainmanGUID='" + model.strTrainmanGUID + "'"; int rows2 = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql3.ToString()); return(true); } else { return(false); } }
public bool AddByParamModel(TF.RunSafty.Model.InterfaceModel.PlanOutRoom paramModel, TF.RunSafty.Model.Model_Plan_OutRoom PlanInRoom) { SetModelValue(paramModel, PlanInRoom); return(this.Add(PlanInRoom)); }
public void SetModelValue(TF.RunSafty.Model.InterfaceModel.PlanOutRoom paramModel, TF.RunSafty.Model.Model_Plan_OutRoom PlanOutRoom) { PlanOutRoom.strOutRoomGUID = paramModel.strOutRoomGUID; PlanOutRoom.strTrainPlanGUID = paramModel.strTrainPlanGUID; PlanOutRoom.strTrainmanGUID = paramModel.strTrainmanGUID; PlanOutRoom.dtOutRoomTime = paramModel.dtOutRoomTime; PlanOutRoom.nOutRoomVerifyID = paramModel.nOutRoomVerifyID; PlanOutRoom.strDutyUserGUID = paramModel.strDutyUserGUID; PlanOutRoom.strTrainmanNumber = paramModel.strTrainmanNumber; PlanOutRoom.dtCreateTime = paramModel.dtCreateTime; PlanOutRoom.strInRoomGUID = paramModel.strInRoomGUID; PlanOutRoom.strSiteGUID = paramModel.strSiteGUID; PlanOutRoom.dtArriveTime = paramModel.dtArriveTime; PlanOutRoom.strWaitPlanGUID = paramModel.strWaitPlanGUID; PlanOutRoom.ePlanType = paramModel.ePlanType; PlanOutRoom.nBedNumber = paramModel.nBedNumber; PlanOutRoom.strRoomNumber = paramModel.strRoomNumber; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TF.RunSafty.Model.Model_Plan_OutRoom model) { return(dal.AddOutRoom(model)); }