public int Update(WorkdayInfo oParam) { string sql = @"UPDATE Workday SET Name=@Name, Date=@Date, TimeSpan=@TimeSpan, Week=@Week, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50); SqlParameter paramDate = new SqlParameter("@Date", SqlDbType.DateTime); SqlParameter paramTimeSpan = new SqlParameter("@TimeSpan", SqlDbType.Int, 4); SqlParameter paramWeek = new SqlParameter("@Week", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.Name != AppConst.StringNull) { paramName.Value = oParam.Name; } else { paramName.Value = System.DBNull.Value; } if (oParam.Date != AppConst.DateTimeNull) { paramDate.Value = oParam.Date; } else { paramDate.Value = System.DBNull.Value; } if (oParam.TimeSpan != AppConst.IntNull) { paramTimeSpan.Value = oParam.TimeSpan; } else { paramTimeSpan.Value = System.DBNull.Value; } if (oParam.Week != AppConst.IntNull) { paramWeek.Value = oParam.Week; } else { paramWeek.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramName); cmd.Parameters.Add(paramDate); cmd.Parameters.Add(paramTimeSpan); cmd.Parameters.Add(paramWeek); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Insert(WorkdayInfo oParam) { string sql = @"INSERT INTO Workday ( Name, Date, TimeSpan, Week, Status ) VALUES ( @Name, @Date, @TimeSpan, @Week, @Status );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramName = new SqlParameter("@Name", SqlDbType.NVarChar, 50); SqlParameter paramDate = new SqlParameter("@Date", SqlDbType.DateTime); SqlParameter paramTimeSpan = new SqlParameter("@TimeSpan", SqlDbType.Int, 4); SqlParameter paramWeek = new SqlParameter("@Week", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.Name != AppConst.StringNull) { paramName.Value = oParam.Name; } else { paramName.Value = System.DBNull.Value; } if (oParam.Date != AppConst.DateTimeNull) { paramDate.Value = oParam.Date; } else { paramDate.Value = System.DBNull.Value; } if (oParam.TimeSpan != AppConst.IntNull) { paramTimeSpan.Value = oParam.TimeSpan; } else { paramTimeSpan.Value = System.DBNull.Value; } if (oParam.Week != AppConst.IntNull) { paramWeek.Value = oParam.Week; } else { paramWeek.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramName); cmd.Parameters.Add(paramDate); cmd.Parameters.Add(paramTimeSpan); cmd.Parameters.Add(paramWeek); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }