private Entities.ProjectTask_AdditionalStatus LoadSingleProjectTask_AdditionalStatus(DataRow row) { Entities.ProjectTask_AdditionalStatus model = new Entities.ProjectTask_AdditionalStatus(); model.PTID = row["PTID"].ToString(); model.AdditionalStatus = row["AdditionalStatus"].ToString(); model.Description = row["Description"].ToString(); return(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.ProjectTask_AdditionalStatus model) { SqlParameter[] parameters = { new SqlParameter("@PTID", SqlDbType.VarChar, 20), new SqlParameter("@AdditionalStatus", SqlDbType.VarChar, 16), new SqlParameter("@Description", SqlDbType.NVarChar, 32) }; parameters[0].Value = model.PTID; parameters[1].Value = model.AdditionalStatus; parameters[2].Value = model.Description; return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_PROJECTTASK_ADDITIONALSTATUS_UPDATE, parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.ProjectTask_AdditionalStatus model) { SqlParameter[] parameters = { new SqlParameter("@PTID", SqlDbType.VarChar, 20), new SqlParameter("@AdditionalStatus", SqlDbType.VarChar, 16), new SqlParameter("@Description", SqlDbType.NVarChar, 32) }; parameters[0].Value = model.PTID; parameters[1].Value = model.AdditionalStatus; parameters[2].Value = model.Description; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_ADDITIONALSTATUS_INSERT, parameters); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.ProjectTask_AdditionalStatus model) { return(Dal.ProjectTask_AdditionalStatus.Instance.Update(sqltran, model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.ProjectTask_AdditionalStatus model) { return(Dal.ProjectTask_AdditionalStatus.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(SqlTransaction sqltran, Entities.ProjectTask_AdditionalStatus model) { Dal.ProjectTask_AdditionalStatus.Instance.Insert(sqltran, model); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.ProjectTask_AdditionalStatus model) { Dal.ProjectTask_AdditionalStatus.Instance.Insert(model); }