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