public static bool Add(Vacation a)
{
sql = string.Format("insert into T_Vacation(ID,name,type,reason,daystart,dayover,applytime,condition,Number) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", a.id, a.name, a.type, a.reason, a.daystart, a.dayover, a.applytime, a.condition, a.number);
return(DBAcess.ExecSqlCommand(sql));
}
public static bool UpdateAgree(Vacation a)
{
sql = string.Format("update T_Vacation set agreepeople='{0}' where Number='{1}'", a.agreepeople, a.number);
return(DBAcess.ExecSqlCommand(sql));
}
public static int Count(Vacation a)
{
sql = string.Format("SELECT COUNT(condition) FROM T_Vacation WHERE condition = '未审批'");
return(DBAcess.ExecSqlCommand1(sql));
}