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);
}
