public List <TF.RunSafty.Model.Model_Plan_ToBeTake> GetPlaceList(List <TF.RunSafty.Model.Model_Plan_ToBeTake> placeList) { if (placeList != null) { List <TF.RunSafty.Model.Model_Plan_ToBeTake> resultList = new List <TF.RunSafty.Model.Model_Plan_ToBeTake>(); foreach (TF.RunSafty.Model.Model_Plan_ToBeTake place in placeList) { TF.RunSafty.Model.Model_Plan_ToBeTake model = new TF.RunSafty.Model.Model_Plan_ToBeTake(); model.strCheCi = place.strCheCi; model.dtCallWorkTime = place.dtCallWorkTime; model.dtWaitWorkTime = place.dtWaitWorkTime; model.strTrainmanGUID1 = place.strTrainmanGUID1; model.strTrainmanGUID2 = place.strTrainmanGUID2; model.strTrainmanGUID3 = place.strTrainmanGUID3; model.strTrainmanGUID4 = place.strTrainmanGUID4; model.NNeedRest = place.NNeedRest; model.NPlanState = place.NPlanState; model.StrTrainNo = place.StrTrainNo; model.strPlanGUID = place.strPlanGUID; resultList.Add(model); } return(resultList); } return(null); }
/// <summary> /// 得到一个对象实体 /// </summary> private List <TF.RunSafty.Model.Model_Plan_ToBeTake> GetPlanList(List <TF.RunSafty.Model.Model_Plan_ToBeTake> vPlans) { List <TF.RunSafty.Model.Model_Plan_ToBeTake> model = new List <TF.RunSafty.Model.Model_Plan_ToBeTake>(); TF.RunSafty.Model.Model_Plan_ToBeTake clientPlan = null; if (vPlans != null) { foreach (TF.RunSafty.Model.Model_Plan_ToBeTake plan in vPlans) { clientPlan = new TF.RunSafty.Model.Model_Plan_ToBeTake(); clientPlan.StrTrainNo = plan.StrTrainNo; clientPlan.strCheCi = plan.strCheCi; clientPlan.strTrainmanGUID1 = plan.strTrainmanGUID1; clientPlan.strTrainmanGUID2 = plan.strTrainmanGUID2; clientPlan.strTrainmanGUID3 = plan.strTrainmanGUID3; clientPlan.strTrainmanGUID4 = plan.strTrainmanGUID4; clientPlan.dtCallWorkTime = plan.dtCallWorkTime; clientPlan.dtWaitWorkTime = plan.dtWaitWorkTime; clientPlan.NNeedRest = plan.NNeedRest; clientPlan.NPlanState = plan.NPlanState; } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TF.RunSafty.Model.Model_Plan_ToBeTake model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TAB_Plan_ToBeTake("); strSql.Append("strPlanGUID,strCheCi,dtCallWorkTime,dtWaitWorkTime,strTrainmanGUID1,strTrainmanGUID2,strTrainmanGUID3,strTrainmanGUID4)"); strSql.Append(" values ("); strSql.Append("@strPlanGUID,@strCheCi,@dtCallWorkTime,@dtWaitWorkTime,@strTrainmanGUID1,@strTrainmanGUID2,@strTrainmanGUID3,@strTrainmanGUID4)"); SqlParameter[] parameters = { new SqlParameter("@strPlanGUID", SqlDbType.VarChar, 50), new SqlParameter("@strCheCi", SqlDbType.VarChar, 50), new SqlParameter("@dtCallWorkTime", SqlDbType.DateTime), new SqlParameter("@dtWaitWorkTime", SqlDbType.DateTime), new SqlParameter("@strTrainmanGUID1", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID2", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID3", SqlDbType.VarChar, 50), new SqlParameter("@strTrainmanGUID4", SqlDbType.VarChar, 50) }; parameters[0].Value = model.strPlanGUID; parameters[1].Value = model.strCheCi; parameters[2].Value = model.dtCallWorkTime; parameters[3].Value = model.dtWaitWorkTime; parameters[4].Value = model.strTrainmanGUID1; parameters[5].Value = model.strTrainmanGUID2; parameters[6].Value = model.strTrainmanGUID3; parameters[7].Value = model.strTrainmanGUID4; int rows = (int)SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void SetModelValue(TF.RunSafty.Model.InterfaceModel.PlanToTakes paramModel, TF.RunSafty.Model.Model_Plan_ToBeTake PlanTake) { PlanTake.strPlanGUID = paramModel.strPlanGUID; PlanTake.strCheCi = paramModel.strCheCi; PlanTake.dtCallWorkTime = paramModel.dtCallWorkTime; PlanTake.dtWaitWorkTime = paramModel.dtWaitWorkTime; PlanTake.strTrainmanGUID1 = paramModel.strTrainmanGUID1; PlanTake.strTrainmanGUID2 = paramModel.strTrainmanGUID2; PlanTake.strTrainmanGUID3 = paramModel.strTrainmanGUID3; PlanTake.strTrainmanGUID4 = paramModel.strTrainmanGUID4; }
public bool AddByParamModel(TF.RunSafty.Model.InterfaceModel.PlanToTakes paramModel, TF.RunSafty.Model.Model_Plan_ToBeTake PlanTake) { string strGUID = Guid.NewGuid().ToString(); PlanTake.strPlanGUID = strGUID; SetModelValue(paramModel, PlanTake); return(this.Add(PlanTake)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TF.RunSafty.Model.Model_Plan_ToBeTake model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Model.Model_Plan_ToBeTake DataRowToModelBeginWork(DataRow row) { TF.RunSafty.Model.Model_Plan_ToBeTake model = new TF.RunSafty.Model.Model_Plan_ToBeTake(); if (row != null) { if (row["dtArriveTime"] != null && row["dtArriveTime"].ToString() != "") { model.dtWaitWorkTime = row["dtArriveTime"].ToString(); } else { model.dtWaitWorkTime = ""; } if (row["dtCallTime"] != null && row["dtCallTime"].ToString() != "") { model.dtCallWorkTime = row["dtCallTime"].ToString(); } else { model.dtCallWorkTime = ""; } if (row["strGUID"] != null && row["strGUID"].ToString() != "") { model.strPlanGUID = row["strGUID"].ToString(); } else { model.strPlanGUID = ""; } if (row["strTrainNo"] != null) { model.StrTrainNo = row["strTrainNo"].ToString(); } else { model.StrTrainNo = ""; } if (row["strTrainNo"] != null) { model.strCheCi = row["strTrainNo"].ToString(); } else { model.strCheCi = ""; } if (row["strTrainmanGUID1"] != null) { model.strTrainmanGUID1 = row["strTrainmanGUID1"].ToString(); } else { model.strTrainmanGUID1 = ""; } if (row["strTrainmanGUID2"] != null) { model.strTrainmanGUID2 = row["strTrainmanGUID2"].ToString(); } else { model.strTrainmanGUID2 = ""; } if (row["strTrainmanGUID3"] != null) { model.strTrainmanGUID3 = row["strTrainmanGUID3"].ToString(); } else { model.strTrainmanGUID3 = ""; } if (row["strTrainmanGUID4"] != null) { model.strTrainmanGUID4 = row["strTrainmanGUID4"].ToString(); } else { model.strTrainmanGUID4 = ""; } if (row["nNeedRest"] != null && row["nNeedRest"].ToString() != "") { model.NNeedRest = row["nNeedRest"].ToString(); } else { model.NNeedRest = "0"; } if (row["ePlanState"] != null && row["ePlanState"].ToString() != "") { model.NPlanState = row["ePlanState"].ToString(); } else { model.NPlanState = "0"; } if (row["strTrainmanNumber1"] != null) { model.strTrainmanNumber1 = row["strTrainmanNumber1"].ToString(); } if (row["strTrainmanNumber2"] != null) { model.strTrainmanNumber2 = row["strTrainmanNumber2"].ToString(); } if (row["strTrainmanNumber3"] != null) { model.strTrainmanNumber3 = row["strTrainmanNumber3"].ToString(); } if (row["strTrainmanNumber4"] != null) { model.strTrainmanNumber4 = row["strTrainmanNumber4"].ToString(); } if (row["strTrainmanName1"] != null) { model.strTrainmanName1 = row["strTrainmanName1"].ToString(); } if (row["strTrainmanName2"] != null) { model.strTrainmanName2 = row["strTrainmanName2"].ToString(); } if (row["strTrainmanName3"] != null) { model.strTrainmanName3 = row["strTrainmanName3"].ToString(); } if (row["strTrainmanName4"] != null) { model.strTrainmanName4 = row["strTrainmanName4"].ToString(); } } return(model); }